what to do with OE posting error

[randva]

Macola 7.5.102e, Pervasive

The last invoice posted last Thursday did not finish posting properly.

The invoice amount shows up in AR, but the order is still in OEORDHDR and OEORDLIN. (not just the backorders, but the whole order).

Friday's invoice posting gave a message for that order "Can not be posted to the AR open file due to duplication". And the order is still in open orders.

Can anyone give me a process whereby I can move the invoiced lines to the OE history files and still leave the backorders in OE open orders? Thanks in advance for any suggestions.

 

[dgillz]

Did this happen to all orders or only certain orders?

The only time I have seen this is when the next invoice # was duplicated. Have your invoice numbers rolled over? Is there already an invoice with this # in the AROPNFIL?

Please note that you cannot determine this by running an aging unless you show all items. You are better off querying the file for that particular doc_no.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[randva]

The doc_no is in AROPNFIL, but only for this order in question.

It appears that 1/2 of the order posted (In IM/reports/history/trx by item, I can see that the first dozen or so show lines posted. The last dozen or so did not.)

Invoices after this one were posted on the next day with no problems.

 

[dgillz]

If the entire order is still open, I would delete the open item from AR using open item load, then delete anything in OELINHST and OEHDRHST with this order #, and then try to reinvoice the order.

You may have to change the status of the order to select it again, and most likely you have some bad quantities on hand, and GL distributions. If any of the items are serial/lot/bin items, that data may be hosed as well.

This is probably something you need your Macola reseller to look to get it right.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[crystalreporting]

If the invoice is not posting due to duplication in AR you can force the sales order to pick up a different invoice number.

Print the invoice for that one order again using the 'print duplicates' check box and respond 'no' when asked if the invoice printed correctly. Unselect and reselect the order again and then print the invoice. These steps should allow the invoice to post OK using a new invoice number - if there is still an overlap in numbers and it wont post, then repeat the process but advance the next invoice number in the setup to clear the overlapping numbers in AR.

Once you get the order to post, check IM and GL distributions and adjust as required.

Peter Shirley

http://www.srhconsulting.com