Sage 100

I am getting this error "Missing record to calculate taxes." while trying to import Sales order in Sage using BOI. Has anybody faced this issue before? OR anyone has some idea how to solve this. Appreciated your help

Hello, I've used VI jobs for various import and export jobs to import things from sales order info to bill structure. I dont use a lot of conditional based columns. What im trying to do is have the ShipExpireDate be 5 business days added to the order…

Using Visual Integrator, how can i prevent the importing of a Sales Orrder, and make it update an old sales order instead, if the PO number of the currently importing Sales Order is the same as the PO number of an old sales order?

Can i import a Sales Order through Visual Integrator by description rather than alias or item number? How would this be done?

here is the line i'm testing my import on: 1,00,ROYAL,66ITM67161,1,, col 1: H.SalesOrderNo 'Next' col 2: H.ARDivisionNo col 3: H. CustoemrNo When I attempt to import, I'm getting this error: However, when I manually enter a sales order,…

I am trying to import our Web Sales orders with Credit Card Pre-Auth and getting this error. Anyone know what this error means?

We use VI quite extensively and it works great. We use it to import many of our orders. After the VI jobs run, we open the sales order entry screen and enter the sales order number to do final editing and to print/email. Does anyone know how to add…

Hi All, I am trying to set the value of OrderDate while importing Sales order. Record imported successfully, but order date does not reflect in Sage100. It remains the same as previous order date. I don't know where I am wrong. Please help me. Do…

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…

Hi, using Sage 100 Standard ERP 2014 I am writing a VI job to import a Customers Sales Orders, the source file is a CSV file, Loading into SO_SalesOrderHeader the field i am having trouble with is OrderDate The date on the CSV file comes across…

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…

How do I pull out a list of all the sales orders that had back orders (at the time of first shipment) from a previous month?