Forums
Lawson S3 Financials
mx10 interface
Author
Messages
Matt
New Member
Posts: 3
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
Senior Member
Posts: 3348
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.
Matt
New Member
Posts: 3
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
Senior Member
Posts: 3348
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...
Matt
New Member
Posts: 3
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
Senior Member
Posts: 3348
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.