I need to know if there is a script or perform logic that can help my situation.
- I have a VI Import Job importing Invoices from Sales Orders
- The source file does NOT contain the Misc or Charge items from the SO
Can this be done without the lines not living in the source data? Is there a script I can run or perform logic that can pull everything on write?
Sage 100 v2016 premium with ACS multi-bin, Dm2/PDI software
Thank you!
I don't know about script / perform logic options, but this is how we've dealt with this problem for one customer:
Import into a UDT, and write a SQL View to merge the UDT data with the open SO…
Hi David -
Yes, the SO contains Freight for some customers and the Freight is setup as a Misc/Charge item. The source file only contains the InvtType 1 Lines. We have a dispatch system, Deliveryworks that…
