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 level detail of each order shipped including the quantity that was shipped.

I am trying to take this file and build a VI job to create an invoice batch in Sage 100.  I have a working VI job that creates a batch and invoices for each sales order, but the job is not working 100% correctly despite the fact that I don't get any errors when running the job.

The issue appears to be that the job doesn't seem to be connecting the information I import to the line level detail on the sales order.  For example, if I have a sales order with a single SKU where 2 of this SKU were ordered, the invoice created shows a quantity ordered of 0 with 2 being shipped.  It is almost like it is adding a line to the sales order rather than referencing the original line to the sales order.  To make sure I am referencing the original sales order line I have added the line key field from the sales order to the VI job but it still does not seem to work.

Any advice on how to go about this?

Thanks in advance!