AOC error in MA54.

Sort:
You are not authorized to post a reply.
Author
Messages
maharuchi
Advanced Member
Posts: 28
Advanced 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
    Posts: 1162
    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
      Advanced Member
      Posts: 28
      Advanced 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
        Posts: 1162
        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
          Advanced Member
          Posts: 28
          Advanced Member

            Thanks for your reply Jon.

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

            JonA
            Veteran Member
            Posts: 1162
            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
              Posts: 1162
              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
                Advanced Member
                Posts: 28
                Advanced 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.

                   

                  You are not authorized to post a reply.