Sage 100

I am able to import records into the WOS and WOU files individually through visual integrator, but the issue I am having is how to determine the Line Index for the WOU file. I can get the index from the WOS file after I import it in, but I would like…

Hi, I have been trying to import new or exisiting sales order into SalesOrderHeader. However, when importing. i get these errors. it seems creating the new SO was fine. the only problem right now is the LotSerialNo.

We are considering using a 3PL company pick, pack, and ship some of our orders. The 3 PL would download the orders from us on a daily basis and each day send back a file with information on all the orders they shipped. This file would contain the line…

I am putting together a VI import job to import invoices into the AR_InvoiceHeader table in Sage 100 2016. The import appears to be identifying the headers and line items appropriately, however it does not skip duplicates as all existing invoices are…

I have an integration built that works really well. The problem I run into is if the order has more than 40 lines on it, I get an "Internal Server Error". Is anyone using it in a similar manner and have you run into this? Is there a workaround or…

Is there a fairly simple straightforward way of importing timecard information into payroll data entry without using Visual Integrator? Thanks!

Hi, Thought I would post this as an FYI that can hopefully be found if someone searches with a similar issue in future. A client accidentally imported the XLSX version of their spreadsheet into CI_Item instead of their CSV. Normally V/I and the business…

Hi All, I have been importing sales order invoices from an external source but I can't make the price level information work properly. I would expect that if I just import the unit that the price level would be transferred to the unit prices properly…

We are importing SO invoice records using VI. There are 445 lines in the file. The summary says that none of them failed or were skipped, yes the number "passed" is not equal to the number read. What causes this to happen? From looking at the summary…

First, I'm an IT guy, but have little Sage 100 knowledge. We have created a new company in Sage. I need to move some inventory records from the old company to the new company. I have two CSV files. The first contains inventory records of items that…

We were looking to clean up and standardize our misc item codes across our MAS companies. Our support group said you can't delete them if they had been used in the past, but we could switch "UseInPO" to N to hide them. I've built a VI job that seems…

Has anyone had experience importing data into Sales Order Entry for a credit card order that has already been pre-authorized outside of Sage 100 ERP? In particular, we're working with Sage 100 ERP Advanced 2013 PU3 and an online store that uses a third…

We are constantly updating the Bill #'s & Quantities for Gross Requirement Reports. In an effort to eliminate that data entry, I am looking for tips on importing this data into the table (whatever table that is). Thanks, Scott

I am a veteran MAS 200/Sage 100 ERP user and have done many types of imports over many years. I am working on a 4.5 Sage 100 Advanced version of Sage (we are upgrading in early September) and need to import some temporary vendors and their invoices…

I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.

Hello! I am having a problem importing records with Visual Integrator using the IM_PriceCode table. HELP! In the past, we have used this table to manually import customer pricing, basically uploading the CustomerNo, ItemCode, & Price directly into…

I am currently new to VI and looking to see if there is a lookup function that would determine a value to be passed during the import based on a value found in the import file. As an example, the import file that has been provided includes an account…

Hi, Couldnt find anything in KB so thought i would post a question. was looking to create an import that would maintain the Standard Price in Item Maintenance. is there a way to create a VI Job to CI_ITEM? has anyone done this? wanted to just…

Hello - I am looking for someone to be so kind as to post the syntax for Perform Logic to look for already posted duplicate A/P invoices during VI. I used perform logic in the past (non-framework) but do not know what the current syntax should be. …

Has anyone used Visa Commercial Format (VCF) with MAS 90? I've been told I need to export a file in "VCF" format. Is anyone familiar with this requirement? Thanks.

When importing a new Sales Order the Primary Ship To Code is assigned to the new order even though a different address is imported and Ship To code is not even used in the import. I don't want the Primary Ship To code to be assigned to an order that is…

Hello, Everyone has been so helpful in the past, I thought I would ask about another issue I am having. While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…

I have created a UDF in the IM_ItemCustomerHIstoryByPeriod table to store the item unit sales forecast. I want to import the forecast qty to this field, but any item that has never been sold to the customer does not have an existing record, so can't import…

I'm attempting to import MRP Demands for a client, but unlike the entry screens, the imports will not work without a customer number. They don't want a customer number related to the forecasted demand. Is there a workaround other than using an internal…

Hello, I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…