Sage 100

New adventure in invoicing which started with R3 Astro: Daily, but not on every invoice with a back order, we are getting error 40 SO_158SALESJOURNAL_UPD.pvc statement 2462, pointing at a back ordered line on the invoice. Error 40 is typically divide by zero, but all the fields that should not be zero are NOT zero. This appears to be happening just before the records are removed from the SO_InvoiceDetail file, as the problem record is the first one in the file when you open it, and there were earlier invoices in the batch. The only way to get the update to complete is to delete the record via DFDM. This error also does not respond to the End button, and you have to use task manager to kill it. Has anyone else seen this?

There is a similar error in ""normal"" MAS during the update process. You have to track down the record in the SO history table and change UOM to a 1. I wonder if there is any connection.

@JeffSchwenk - do you mean UOM conversion factor in the SO_SalesOrderHistoryDetail? No zeros there.

Yes, that was the one.