Line items and item properties

MaheshKosuri
Occasional Contributor

Line items and item properties

Hi I have a question here

can line item fields be populated with item property values by selecting item member in a module?

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Line items and item properties

@MaheshKosuri 

yes, you can use SELECT but you would have to hard code the formula. I would suggest a different approach, one that uses the DISCO methodology. For me, I almost always create a SYSTEM module for every list I create, especially if know that list will have properties that I need to lookup. To create a SYSTEM module, create a new module using only the list in the "applies to". Time should be removed. In your planning module that may contain a variety of lists, you can use the LOOKUP function to obtain the property you want. So in your planning module it might look like this: Salary = SYS08 Employees.Salary[LOOKUP: SYS08.EMPLOYEE], where EMPLOYEE is a list formatted line item and SYS08 and your planning module both use the same list in the "applies to". Hope that helps.

Also, if you have a specific example you want to explore, post it here. Happy to create an example for you! 

You got this!


Jared Dolich

View solution in original post

1 REPLY 1
JaredDolich
Moderator

Re: Line items and item properties

@MaheshKosuri 

yes, you can use SELECT but you would have to hard code the formula. I would suggest a different approach, one that uses the DISCO methodology. For me, I almost always create a SYSTEM module for every list I create, especially if know that list will have properties that I need to lookup. To create a SYSTEM module, create a new module using only the list in the "applies to". Time should be removed. In your planning module that may contain a variety of lists, you can use the LOOKUP function to obtain the property you want. So in your planning module it might look like this: Salary = SYS08 Employees.Salary[LOOKUP: SYS08.EMPLOYEE], where EMPLOYEE is a list formatted line item and SYS08 and your planning module both use the same list in the "applies to". Hope that helps.

Also, if you have a specific example you want to explore, post it here. Happy to create an example for you! 

You got this!


Jared Dolich

View solution in original post