Sage 100

Sage 100 2016.5 Advanced. Relatively high volume shipper where an invoice is coming out-of-balance every couple of days. They run a Sage Alerts to detect this but for $20k a year expect their accounting software should product in balance transactions. I can't say that I blame them. They use MAPADOC, Starship and have a UPC enhancement from IIG. I know there was an issue back in the 2013 and 2014 days where the lines would not total to the invoice total. However, they are on a version past that. I'm not taking questions from other customers so am not really sure if this is something that high transaction volume sites live with and just correct on their own or if there is another glitch somewhere in this version of Sage. Anyone else have customers on SO / IM who experience random out of balance invoices at v2016.5 or higher?

Is the invoice OOB or perhaps the SO? Are they using shipping data entry or is Starship writing the information back to the invoice? Besides the alert, is there any visible way to tell the OOB other than the printed invoice?

By the time they notice the issue it has already gotten to the invoice. I don't know if the SO is the OOB and carries to Invoice. They use shipping data entry and Starship and writing info back to invoice. They have a squad of about 1/2 dozen shippers who are primarily heads down box packers and don't have any access to other parts of Sage.

I have seen out of balance invoices where the decimal precision is the culprit. If the invoice gets populated with a decimal on a line like 1.023 and the total lines is 1.02 then an out of balance will occur. have you looked at the data of the out of balance invoices to determine why it is out of balance?

This doesn't appear to be a decimal issue. The most recent occurrence seems to be exactly the amount of a line on the invoice. Could be that they added/removed a line at some point in the order process. The owner is one of the people entering orders so it's a bit awkward for Sage to have them ""check the order every time and be sure that it balances"".

Could they set up an Alert to monitor SO's to rule that out? Since Starship is writing back, that might be a place to start. Though it is starting to sound as if they are exiting a line without it firing off a recalc. Perhaps they are changing a line value and exiting the order without going to the totals tab.

I'm thinking of whether to create an ""out of balance"" banner in sales order though i'm not sure if I can do the same on the pick sheet.

I seem to remember this happening to a client. They would make a line change, not hit the enter key and go straight to Accept. So as @JeffSchwenk suggested, have them hit the enter key after changing a value and visit the totals page before clicking accept.

We had this with a client who had kits with invalid valuation methods.

@WayneSchulz Did you ever discover the cause of this issue? I have a customer reporting out of balance sales orders in version 2017 standard. They are getting two or three a week.

I did not. They are on 2016.5 and a few mods. I hope an upgrade might resolve it. Mods= mapadoc, Starship, IIG UPC enhancement.

OK. Thanks. I am going to research this further.

I had another user on 2017 with similar issue. I followed the KB which advised to swap the tax codes. That fixed the issue. Seems that Sage may not know what is causing this as they have a fix for earlier version but this customer is on a later release. And this swapping of tax codes is a pure after-the-fact remedy. The customer is left red-faced that their invoice doesn't foot. Sure, you can add a ""OUT OF BALANCE"" to the form but that doesn't help in high volume sites where invoices are mostly emailed. Here is the KB https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=48952&sliceId=1&cmd=&noCount=true¤tmsID=MS_Customer&docLink=true&isDocLink=true&languageId=&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl

My customer has been changing tax schedules for a couple of months now. Sometimes the tax schedule change doesn't correct the out of balance so they delete the order and start over. I am going to try rebuilding all of the SO key and sort files early tomorrow before users are in Sage 100. It is worth a try.

I feel your pain. One of my users can have 300 lines spread across 100 boxes and deleting and re-entering a shipment also means pulling inventory that's been packed from a box. Not bad if you have two boxes but when it's up in the 100 range the customer isn't happy.