SUBSITUTE PRODUCT

TAGORTI
Occasional Contributor

SUBSITUTE PRODUCT

Dear Community,

 

Hope you can help me with this requirement;

1- In fact for a substitution of products, I want to display the first product on each line.

TAGORTI_0-1627402298944.png


2- I want to display error message on this specific case (but not on the others).

TAGORTI_1-1627402427529.png

 

Thank you for your help

4 REPLIES 4
ChrisHeathcote
Community Boss

Re: SUBSITUTE PRODUCT

@TAGORTI 

1. Create a systems module dimensioned only by product. Add a list formatted line item set to the product list. In the formula bar select the first item from the product list. This will result in Product A being allocated against all products. Reference this in your target module. 

 

2. Add a new line item to your product system module. Format this as the product list too and call it 'New Product'. Populate each entry with the correct product for the corresponding list item. In your target module use the following =IF TargetModule.New Product = ProductSystemModule.New Product then "OK" ELSE "NOK"

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
TAGORTI
Occasional Contributor

Re: SUBSITUTE PRODUCT

Hello @ChrisHeathcote,

 

Thank you for response.

In fact, the module will be like this:

TAGORTI_0-1627469376977.png

- New Product : enterable by User
- First Product of the chain : calculated by formula and displayed

- Warning : calculated by formula and displayed

 

I don't think that your solution respond to the requirement.

 

Best Regards

MarkWarren
Expert

Re: SUBSITUTE PRODUCT

Could you explain the logic a bit, its not clear how either "First Product of the chain" or "Warning" are decided.
Also I recommend using either a boolean or a list formatted line item for "Warning", avoid using text.

TAGORTI
Occasional Contributor

Re: SUBSITUTE PRODUCT

@MarkWarren 

 

In fact, we have a list of products and we want to replace it for example:
We have : A replaced by B then B replaced by C and C replaced by D what makes a chain of substitution A-B-C-D.
What I want to display on each line is the first product of the chain in our case "A".For the warning, we cannot replace the same product twice, for example we cannot have A replaced by B and G replaced by A. 

Thanks