EDI and Credit Memos

 5 Replies
 2 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
JonA
Veteran Member
Posts: 1163
Veteran Member
    How do you process a credit memo when it comes via EDI and is translated to the MA540CSV file? Our AP departments says they error out and they just deleted them and request a paper credit memo from the vendor. The Infor/Lawson KB says that you can receive credit memos via EDI but doesn't say anything about how to process them with MA540.
    Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
    Maria
    Basic Member
    Posts: 11
    Basic Member
      Hi Jon, you will need to add a substitution table entry in ED40: The EDILIST-NAME=TPID_I_INVOICE_TYPE. The LAWSON-VALUE = C. The EXTERNAL-VALUE=The value for credits that the vendor is sending you. This value is stored in the Invoice Type field in your MA540CSV file. It is usually C, CR or CM, you will need to look at the data in the MA540 raw data file to determine the value that should be set in ED40. The only issue you may encounter is that if the CM is linked to a return in PO31, the vendor doesn't typically send the return number in the MA540 file so you will need to either manually apply the Return number in MA54 or manually close the Return in PO31. Hope this helps.
      JonA
      Veteran Member
      Posts: 1163
      Veteran Member
        Thank you very much. This helps!
        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        Jeremy
        Veteran Member
        Posts: 129
        Veteran Member
          Did you get this to work?
          I'm trying to bring in a credit memo, but it keeps going to the fatal error report with message "Problem: Invoice type "C" not allowed on PO Invoices."

          Infor isn't much help right now. They just can't seem to believe me that the MA540 isn't at least bringing it into MA54 to edit it...
          JonA
          Veteran Member
          Posts: 1163
          Veteran Member
            No we decided to continue processing credits manually because the of the vendor not sending the return number.
            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
            Jeremy
            Veteran Member
            Posts: 129
            Veteran Member
              I finally got an answer from Infor and, long story short, my system should still be bringing the records in and placing them in MA54. What was wrong was that for some reason, when we had a fatal error, it was not bringing those records into MA54. It just reported "fatal error" and skipped over it, not writing it to the MA54 tables.