PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/14/2016 10:06 AM by  Brian Veldhouse
Ma540 sample
 14 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Peter Griffen
It
Private
Basic Member
(16 points)
Basic Member
Posts:6


Send Message:

--
02/15/2016 2:12 AM
    Hi everyone

    Does anyone have a sample ma540 file that would work for a three way match? I'm am having some issues with the match and am having a hard time tracing the problem.
    Thanks
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    02/15/2016 8:08 AM
    Here's an MA540CSV file from a one of our EDI invoices. Hope it helps.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Attachments
    Peter Griffen
    It
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    02/15/2016 8:29 AM
    And you're doing an auto three way match? What is the item type on the purchase order? We are trying to match on x type items
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    02/15/2016 9:22 AM
    Yes, we're doing three-way matching. The items in that file are most likely nonstock items. But here's an EDI invoice from our primary supplier with two X type items.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Attachments
    Peter Griffen
    It
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    02/15/2016 10:04 AM
    For that description you have on the detail line what field is that mapping to on the PO

    Thanks for the help so far
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    02/15/2016 12:03 PM
    The description comes in the MA540CSV file comes from the 810. MA540 matches on the item number or vendor catalog number so the description should not matter. What are some of the errors you're seeing in the MA540 Fatal Errors report?
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Peter Griffen
    It
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    02/15/2016 1:19 PM
    I was not getting fatal issues but I am getting these when trying to match

    Invoice details out of balance

    And

    Inv amount not equal goods amt, aoc and aoc tax cannot match

    We are not using aoc either
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    02/15/2016 3:08 PM
    You might not be using AOC on the PO side but it sounds like the vendor may be charging freight or some other fee. The invoice total is not equal to the total of the lines (goods amount) and the add on cost. The vendor might be sending you the AOC in two SAC segments (detail and summary) on the 810, I've seen this before. Can you post the MA540CSV file for the invoice/PO that is causing this error? Also, would it be possible to post the 810 file for this invoice. This would be in the edi/archive/in/ directory.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Peter Griffen
    It
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    02/15/2016 3:41 PM
    We are not using edi or 810. We are using a handling code on the header.'
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    02/16/2016 6:40 AM
    Handling codes are not universal so I don't know what MAT is. Sorry, I assumed this was an EDI invoice issue because that's all we use MA540 for. How is the MA540CSV file being created in your system? And can you just post the part of the MA540CSV file that's giving you this error?
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Peter Griffen
    It
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    02/17/2016 7:07 PM
    On the file I can't do that right now but looking at something I had we were calculating the extended amount on the detail line and I see you just do quantity, uom, and cost. I will attempt that maybe the issue lies there.

    On ma43.1 the line detail wasn't fully calculating
    Steve T
    Director Accounting & Payroll
    Private
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    08/14/2016 11:24 AM
    Hi Jon. I ran into this conversation while researching a matching problems. We are having trouble with our EDI invoices flowing into Lawson ever since we became a for-profit business back in March. The EDI invoices now have sales tax on them and that is stopping our files from processing automatically. We also noticed that the freight is not posting to the account we have setup in our MA08.1 like it should be. I believe our 810 & MA540 jobs are not mapped correctly. Would you be willing to assist Russ and I with a solution if we can send some files for review?
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    08/15/2016 7:27 AM
    Sure, do you want to post the files here or go through email?
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Steve T
    Director Accounting & Payroll
    Private
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    08/15/2016 12:15 PM
    Email would be great. Mine is s.timm@lph.org. If you can send me a quick message I will reply on it. Thanks!
    Brian Veldhouse
    IS Senior Analyst
    Holland Hospital
    Basic Member
    (11 points)
    Basic Member
    Posts:5


    Send Message:

    --
    10/14/2016 10:06 AM
    Does anyone use the "C" (csv) option on the MA540? We are currently only using the "E" (EDI) option successfully. We would like to start importing non-EDI invoices into Lawson using the MA540. If anyone could shed some light on the set up differences between these two processing options, it would help. Thank you
    You are not authorized to post a reply.