Sage 100

Importing to accounts payable invoice data entry. The source file has an invoice due date of 4/2/2016. The invoice date is 3/7/2017. It seems the business object uses the terms code to recalculate the due date. The due dates vary and aren't always based on the terms code. How can I import and use the due date in the source file?

WAG - put the Terms code actually on the import (just pull in the standard vendor terms) and then put the Due Date AFTER that line? Kind of like how it tells you to put the zip code before the City field or it will just change the City when it hits the zip code in a Customer import?

Import/set (file assign) the terms code first and then import the due date second

try moving the assigned due date from your file, to a location ""after"" the Terms code.

WOW. I was looking to help but in 3 minutes you have it answered. This is why I like this group.

Damn that was easy. Thanks a million. This is why I love this group.

Whether it's modification programming, scripting, or VI, it's all about overrides.