Sage 100

End user on 2014.5 sends me an invoice where the lines don't match the totals. I know in the past this has been an issue but Sage reports that it was fixed with PU5 for Sage 100 2014 ( https://goo.gl/FvjRGN ). Am I overlooking something else? This is rather scary to receive and especially because the customer's customer caught it. I logged in and invoice history inquiry shows the incorrect total so I believe that rules out a form issue.

I have 2 companies, both on 2017 that receive the ""out of balance"" condition about once every two weeks. If you catch it before updating the sales journal it is easily fixed. You can change the tax schedule to another value, then change it back. The totals get re-calculated.

Is this an Avalara issue? I don't think this customer has implemented Avalara yet. They are using a custom form so they may not have any ""out of balance"" code to notify them if an order is OOB.

Naturally, the customer wants to know how did this happen and how can we prevent it in the future? It's a bit scary to think your invoices may randomly not foot.

I ran into this with Misc Items when printing from Invoice History. They were entering Qty = 0, but an ExtensionAmt, so the Invoice reflected the right amount, but then that line was not written to the history file (so re-prints were wrong). I never got a solution from Sage, so I ended up forcing the item to a Misc Charge.

And... Thank you We would also like to know how to determine if this has happened before to prior invoices and how to identify which invoices were affected.

I've seen this with a pre-write script changing line data, but without retriggering the pre-totals event (so header values aren't updated correctly).

We've been told by Sage it can happen when someone changes an amount or a quantity on a line and doesn't hit the OK button and doesn't go to the Totals tab. It doesn't recalc the way it should.

I would also check the standard invoice versus custom form to make sure it isn't something in the form itself.