• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

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
11/12/2015 11:58 AM
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
11/12/2015 2:54 PM
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
11/13/2015 7:04 PM
Thank you very much. This helps!
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
Jeremy
Veteran Member
Posts: 129
Veteran Member
4/6/2017 10:38 PM
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
5/11/2017 5:53 PM
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
5/12/2017 1:33 PM
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.