Sage 100

Not exactly urgent but trying to import into PO Receipt of Invoice. Everything worked ok until we started trying to hit the freight amount on the totals tab (see attached). Not sure why it's not recalculating the amounts correctly after the import (version 5.0)

What's your setting in SO Options for freight calc? You may try setting the value to ""No"".

Can you attach a copy of the job?

it's PO, not SO Doug but good idea. I'll upload the job tomorrow Nicole.

@EricAnderson You mean changing the SO freight options doesn't affect PO receipt of goods? .... Holy smoke.... it has been a long day.

I've been testing some more and it just seems like when it reads the first line it creates a header record, then reads all of the lines, and then when we read the freight amount on the last line it creates another header record and throws off the totals on the totals tab. Is there a way to run perform logic after-writing that recalcs the totals tab? We used to be able to do that with legacy imports but I don't see any options. If that doesn't work we're going to have to change the file format so the first row is the header info with the freight. I've tested that and it works but it's a few hours of coding time for our developer.