PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/29/2018 2:42 PM by  ajn
Multiple companies in MA540csv
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Bev Edwards
Systems Analyst
CTG
Veteran Member
(704 points)
Veteran Member
Posts:350


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
    (2959 points)
    Veteran Member
    Posts:1041


    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
    (704 points)
    Veteran Member
    Posts:350


    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
    (704 points)
    Veteran Member
    Posts:350


    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
    (2959 points)
    Veteran Member
    Posts:1041


    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
    (300 points)
    Veteran Member
    Posts:106


    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
    ajn
    Private
    Private
    Basic Member
    (37 points)
    Basic Member
    Posts:13


    Send Message:

    --
    05/29/2018 2:42 PM
    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.
    You are not authorized to post a reply.