Sage 100

v2013 - accumulate freight (Add Value) on S/O Invoice import Does anyone have a way to have imported Freight accumulate (i.e., Add Value via VI)? So for a given invoice if I'm importing multiple records containing multiple freight amounts (e.g., 10.00, 15.00, 20.00), I want the S/O Invoice Entry Freight amount/field to be 45.00. I'm working with Temp fields and do have it working, but I'm unable to get it to Reset after each Invoice #.

Have you tried unchecking the ""clear on each record"" box?

Use access and query the file the way you want

I tried different combinations of enablling the ""clear on each record"" setting on the 2 Temp fields, but no luck. No matter what, the freight amount just keeps accumulating on each invoice. I ended up creating a process using the Excel Subtotal function.

Back on this again. Now come to find out that sometimes invoices in S/O Invoice Entry that we need to import Freight to will already have a handling fee in the Freight field. So how do you import freight to an invoice that already has freight? - since the accumulate function (i.e., AddValue) isn't available in VI, and therefore the import overwrites the existing value in the Freight field? Even if I could get FedEx to export the Freight data as accumulated amounts, we still have this new issue. Currently I'm considering having the client enter that handling fee as a Misc line item, although it wouldn't surprise me if they prefer that it doesn't show like that on the invoice to the customer. Therefore I may have to suppress those particular Misc lines, and create a custom Freight amt field on the form. Any other thoughts?