Ma540 sample

Here's an MA540CSV file from a one of our EDI invoices. Hope it helps.

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

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.

For that description you have on the detail line what field is that mapping to on the PO

Thanks for the help so far

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?

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

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.

We are not using edi or 810. We are using a handling code on the header.'

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?

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

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?

Sure, do you want to post the files here or go through email?

Email would be great. Mine is s.timm@lph.org. If you can send me a quick message I will reply on it. Thanks!

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

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.

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?

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?

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)"