PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/27/2017 1:06 PM by  Jason Beard
Multiple companies in MA540csv
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Bev Edwards
Systems Analyst
CTG
Veteran Member
(692 points)
Veteran Member
Posts:340


Send Message:

--
03/16/2017 11:43 AM

    My user wants to be able to run her MA540 and choose the company she wants to run, but from what Infor tells me, there needs to be a custom script written to handle this.

    Has anyone or is anyone doing this now?

    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    03/17/2017 8:26 AM
    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.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Bev Edwards
    Systems Analyst
    CTG
    Veteran Member
    (692 points)
    Veteran Member
    Posts:340


    Send Message:

    --
    03/17/2017 2:28 PM

    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.

    Bev Edwards
    Systems Analyst
    CTG
    Veteran Member
    (692 points)
    Veteran Member
    Posts:340


    Send Message:

    --
    03/17/2017 2:38 PM
    Do you know if all companies will be transmitted in one csv file??
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    03/17/2017 2:57 PM
    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.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Jason Beard
    Private
    Private
    Veteran Member
    (219 points)
    Veteran Member
    Posts:79


    Send Message:

    --
    04/27/2017 1:06 PM
    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 .
    Jason Beard
    617-548-5568
    jabeard3@gmail.com
    You are not authorized to post a reply.