PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/12/2017 9:33 AM by  Jeremy
EDI and Credit Memos
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
JonA
Private
Private
Veteran Member
(2766 points)
Veteran Member
Posts:972


Send Message:

--
11/12/2015 6: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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    Basia
    Analyst
    CHOC
    Basic Member
    (22 points)
    Basic Member
    Posts:10


    Send Message:

    --
    11/12/2015 9:54 AM
    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
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    11/13/2015 2:04 PM
    Thank you very much. This helps!
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Jeremy
    Private
    Private
    Veteran Member
    (204 points)
    Veteran Member
    Posts:82


    Send Message:

    --
    04/06/2017 6: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
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    05/11/2017 1:53 PM
    No we decided to continue processing credits manually because the of the vendor not sending the return number.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Jeremy
    Private
    Private
    Veteran Member
    (204 points)
    Veteran Member
    Posts:82


    Send Message:

    --
    05/12/2017 9:33 AM
    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.
    You are not authorized to post a reply.