Ma540 sample

Sort:
You are not authorized to post a reply.
Author
Messages
Peter Griffen
Basic Member
Posts: 6
Basic Member
    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
    Veteran Member
    Posts: 1162
    Veteran Member
      Here's an MA540CSV file from a one of our EDI invoices. Hope it helps.
      Attachments
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      Peter Griffen
      Basic Member
      Posts: 6
      Basic Member
        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
        Veteran Member
        Posts: 1162
        Veteran Member
          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.
          Attachments
          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
          Peter Griffen
          Basic Member
          Posts: 6
          Basic Member
            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
            Veteran Member
            Posts: 1162
            Veteran Member
              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 - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
              Peter Griffen
              Basic Member
              Posts: 6
              Basic Member
                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
                Veteran Member
                Posts: 1162
                Veteran Member
                  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 - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                  Peter Griffen
                  Basic Member
                  Posts: 6
                  Basic Member
                    We are not using edi or 810. We are using a handling code on the header.'
                    JonA
                    Veteran Member
                    Posts: 1162
                    Veteran Member
                      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 - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                      Peter Griffen
                      Basic Member
                      Posts: 6
                      Basic Member
                        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
                        New Member
                        Posts: 2
                        New Member
                          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
                          Veteran Member
                          Posts: 1162
                          Veteran Member
                            Sure, do you want to post the files here or go through email?
                            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                            Steve T
                            New Member
                            Posts: 2
                            New Member
                              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
                              Basic Member
                              Posts: 9
                              Basic Member
                                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
                                Jeremy
                                Veteran Member
                                Posts: 129
                                Veteran Member
                                  I know this is old, but did you ever get an answer? I'm curious about how the three different options all work and the difference between them.
                                  JonA
                                  Veteran Member
                                  Posts: 1162
                                  Veteran Member
                                    I can really only speak to the C and D options. When the 810 comes in ED502 converts the data to a csv file. We run MA540 with option C to convert the csv data to invoices. Any data that errors is worked on in MA54 and those errors are released and become a database input file. We run MA540 again with option D to convert the DB input file to invoices. We don't use option E at all so I'm not sure if "Lawson EDI file" means you can convert straight from the 810 or what?
                                    Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                                    Jeremy
                                    Veteran Member
                                    Posts: 129
                                    Veteran Member
                                      Thanks Jon. Option "D" is how I assumed it worked, too. But, instead of option "C" for CSV, I used option "E" against the CSV. I think it works the same, honestly, but not really sure?
                                      Rani Ilapa
                                      Basic Member
                                      Posts: 5
                                      Basic Member
                                        Hello , Can someone help us with the Query for uploads for matching? or sample CSV upload file. There was file attached on top. But I am not able to open it. We built a query and created header using MA54.1 But we are getting this following error messages when we trying to upload lines via MA54.3
                                        "Values not in list:[I,N,P,C, +,-] (_f1)"
                                        You are not authorized to post a reply.