Invoiced/Posted order stuck in Open status

[Prognewb]

While billing an order, the computer it was being done on lost power and shut down. Upon restarting, the order was successfully billed and invoiced (it has an invoice number), and shows up in the general ledger, but it remains in open order status (the row is still showing up in the oeordhdr_sql table instead of oehdrhst_sql). I tried to force it by changing the status to 'P' (posted) right in the table, but it didn't work.

Any advice on how to transition the order from open to history would be greatly appreciated. Thanks.

 

[NEmacGuy]

If you have access to the Exact customer portal I would search for document# Document: 13.061.209 - OE: power failure while printing.

 

[jaustill]

When you print an invoice, Macola changes the selection_cd in the oeordhdr_sql to an "N" and then waits for the person printing the invoice to acknowledge it printed correctly. If they do, Macola changes the the "N" selection_cd in the oeordhdr_sql to an "X" which allows you to post that order. If you crash it never changes from the "N". Change the "N" to an "X" in ONLY the order that will not post then re-post for the day shown on that order for the invoice date.

 

[crystalreporting]

You can do the same thing by printing just the problem order and selecting the 'reprint' function. When the invoice prints, respond 'no' when asked if it printed OK. This takes the order back to the selected stage where you can unselect it and edit it to correct the problem, or delete it altogether. This saves you from having to edit anything 'through the back door'.

The most important thing though is to determine why it did not post and what steps did and did not get completed - GL, AR, IM and OE history must all be checked. For example, if all of these are good except OE history, then you could do as described above, delete the order, then populate the sales order history using the history load function.

This problem most often happens when an existing AR document exists that has the same invoice number as the one being posted, however there are many reasons why a posting fails. Research is required each time an invoice fails to post and the portal document that NEmacGUY posted above explains this in more detail.



Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.srhconsulting.com