Multiple companies in MA540csv

We aren't doing this as most of our activity is in one company but I don't know why they would say that. MA540 has a company field so you can set up an MA540 job for each company.

Hi Jon!

That's what I had told them. But then I opened a Lawson case and the engineer told me that some companies write a custom script to separate the companies out of the inboud  csv file. That kind of threw me off and made me think that multiple companies in one csv file needed to be handled differently.

Do you know if all companies will be transmitted in one csv file??

I would think you would be able to run the MA540 job for each company, making sure Delete CSV File = N, and the job would pick off the lines with the matching company number. Maybe that's wishful thinking for Lawson to do that.

But if it's true you have to partition the invoices into separate csv files by company I can see then you would need a custom script. ED502 doesn't differentiate data by company. You can send data to different csv files based on vendor (trading partner) but not company.

Bev -
Jon is correct, 1 CSV file containing records for multiple companies is fine as long as delete CSV is set to N. Personally I prefer to load the input file(s) to the database and process that way. No risk of the CSV files getting deleted before records are processed .

I just saw this post and we recently started to use MA540, we received a file from the vendor that has all companies included and we just run a MA540 job for each company and that seems to be working fine for us.