PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 5/16/2013 4:48 PM by  John Henley
mx10 interface
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Matt
sys ananlyst
ccf
New Member
(7 points)
New Member
Posts:3


Send Message:

--
5/14/2013 6:23 PM
    We're currently trying to mockup creating an org hierarchy using attributes on accounting units. Our levels are all messed up in GLNAMES and we aren't going to be fixing that anytime soon.

    So my question is, can we somehow externally interface with mx10 to either create a manual or dynamic list? Update that list? I'm not seeing anything out of the box that allows such interaction. Am I missing anything?
    John Henley
    Private
    Private
    Senior Member
    (9887 points)
    Senior Member
    Posts:3313


    Send Message:

    --
    5/14/2013 7:37 PM
    I think you should be able to use a combination of the AUMXCONV conversion/interface table and GL162 conversion program to set up the attributes for the desired accounting units, and then use the MX500 list member population program to create a list.
    Thanks for using the LawsonGuru.com forums!
    John
    Matt
    sys ananlyst
    ccf
    New Member
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    5/14/2013 8:40 PM
    We are/plan on using aumxconv to populate the attributes. I'm unfamiliar with mx500 though. After reading about it I think it provides the inverse of what we need. Though I could be wrong. We need a way to create/update lists on a scheduled batch from aumxvalue attributes.

    So like...

    gl20 / glnames accouting unit = 1111111111

    gl20.7 aumxvalue matrix cat = division, matrixvalue = marketing

    mx10 / mxlistmbr listtype=acctu, listname = mylist, attribute = division, fromval = marketing, toval=marketing

    We need a way to keep that list up to date via external interface.
    John Henley
    Private
    Private
    Senior Member
    (9887 points)
    Senior Member
    Posts:3313


    Send Message:

    --
    5/14/2013 8:56 PM
    I think your external interface just needs to keep the attribute values updated, and you can use an automated list, probably will want to use MX123 after re-loading just to make sure, but I don't see why you would even need a manual list. If all you are doing is generating a list based on an attribute value, that's already built in...
    Thanks for using the LawsonGuru.com forums!
    John
    Matt
    sys ananlyst
    ccf
    New Member
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    5/14/2013 10:25 PM
    No we cant unfortunetly...

    As what if in that example above the attribute for the AU changes division = "accounting" and there isn't an "accounting" list. We'd need to create a new list programatically somehow using the division attribute where equals accounting.. That's where I was hopeing there was some type of interface into lists/mx10/mxlistmbr.
    John Henley
    Private
    Private
    Senior Member
    (9887 points)
    Senior Member
    Posts:3313


    Send Message:

    --
    5/16/2013 4:48 PM
    You can create the list, and based on attribute value, it will populate automatically.
    Assuming the DIVISION attribute has been created on the accounting unit (ACCTU object type).
    On MX10.2 : create new list for object type ACCTU; call the list ACCTG
    On MX10.1, inquire on the new list (object type ACCTU; list ACCTG).
    On the first row, Select 'A' for FC, select the DIVISION Attribute, and enter ACCOUNTING as the value
    Click Change on the form
    On MX10.2, inquire on the new list (object type ACCTU; list ACCTG), and click the Preview button.
    Thanks for using the LawsonGuru.com forums!
    John
    You are not authorized to post a reply.