AOC error in MA54.

 7 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
maharuchi
New Member Send Private Message
Posts: 0
New Member
We receive 810 invoices from some vendows. One vendor sends AOC in Invoice and at the time of PO, AOC amount is not confirmed.It becomes really cumbersome to unreceive line and add AOC at PO lin.Receive line again and then work on M54.
Does anybody face the same issue?Anyone have input on how to handle this?
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
We do not put AOC on the PO at all for that exact reason. Difficult to match without a lot of work on the back end. AP apples the AOC at time of invoice.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
maharuchi
New Member Send Private Message
Posts: 0
New Member
We don't add AOC at po. Instead we receive AOC amout from Vendor at Invoice which is causing issue for MA54.Invoice has AOC and PO doesn't ,so MA540 shows errors for AOC not found for poline.
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member

AP doesn't do anything special to process AOC on EDI invoices. What is the exact error your seeing on the MA540 Fatal EDI Invoice Errors Report?

Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
maharuchi
New Member Send Private Message
Posts: 0
New Member

Thanks for your reply Jon.

We get errors as- "AOC code SH not found for poline 000001."

JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
Would it be possible to send me an EDI 810 file that is resulting in this error? jon.athey@midmichigan.org
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
Thanks for the file.  As I suspected the vendor is sending AOC at both the line level and summary level. By default Lawson will map both to the MA540CSV file. But when I've seen this happen here the error message refers to the invoice being out of balance because the AOC is duplicated. You could try adding the following to your substitution table (ED40) to map only the summary AOC.

List Name: MAP_AOC_LEVEL
Lawson Value: SUM
External Value: (tpid for the vendor(s) sending line AOC)
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
maharuchi
New Member Send Private Message
Posts: 0
New Member

Thanks a lot Jon. We will try to ask vendor to send AOC only at summary level. Hope that will fix the issue too.

I highly appreciate your help.Currently it is a painful process for our operational folks.