Sage 100

FWIW, we have had two Sale Order Invoicing events in the last couple weeks, one from a client (MAS 200 4.4) and one from our in house system (MAS 200 4.5) The client had a Sales Order Invoice with two backordered items and 4 shipped items. The invoice added one of the backordered items to the Invoice Total. The line on the invoice showed one ordered, one backordered, the correct price and an extension of zero; however, the amount for this item was added to the invoice total. The item in question was still available to ship. On our in house system, a Sales Order Invoice consisting of 11 miscellaneous items (All related to Managed Services, some taxable and some not) dropped two items off the invoice total. In this case the quantities were ordered and shipped and the price and extension were there. The extensions did not make it to the invoice total. In both cases, the AR Open Invoice, AR Invoice History Header, the related Tax Summary files and the AR Transaction Payment History File were affected. The AR Invoice History Lines files were fine. Also, the DTR was out of balance in both cases with the error being in the AR account. There were no displayed errors or activity log entries. I would be interested to know if anyone else has seen this or similar issues.

What PU's are in play? Aren't you importing your managed services invoices? Was an import in play at the client?

I've seen this occasionally. Usually, it relates to someone going back to the lines tab and changing something - quantity, pricing, etc. - and not going back to the Totals tab. I've also seen it with credit memo's but that's usually because they enter a negative quantity and a negative price - really messes it up!

Thanks for replying. @JeffSchwenk, 4.40.0.06 and 4.50.4. Yes, the invoices are imported from ConnectWise. There is about 180 of them that all use a mix of the same Misc Chg codes and this it the first time we have seen this. The Copy produced by ConnectWise was accurate and the import data looked good. The client's Sales group writes the Sales Orders, there is no import. @ThereseLogeais, I will ask about editing once the invoices are created in MAS. Because they are generated in ConnectWise which sends them directly to the customer, editing on the MAS side should not happen very often.