Question

Calculation value of Price List in Project Deliverables Navigator

  • 2 October 2020
  • 1 reply
  • 140 views

Userlevel 2
Badge +4

We use the Project Deliverables Navigator to calculate the total cost of all the deliverables in a project. Based on the total cost, we determine our sales price for the project. The impact of a Price List discount can be significant on the total cost and thus the sales price of a project. We found out that the data of the Price List on a Supplier for Purchase Part is not always included when preforming the Gross Requirements Calculation in the Project Deliverables Navigator.

 

Scenario 1: Price List on one Item with Purchase Part

When you connect a Purchase Part with an Item in the Project Deliverables Navigator, IFS calculates with the discount in the Price List on the Supplier for Purchase Part. This is as desired. See the example below:

 

Scenario 2: Price List on multiple Items with Purchase Parts

When you connect the same Purchase Part with multiple Items, IFS does not take the Price List discount on the Supplier for Purchase Part into account. Conclusion: Price List discount is calculated individually for each Item and not on multiple Items. See example:

 

Part connected with two Items, Quantity of 5 per Item, total Quantity is 10:

 

Result after GRC, no Price List discount because the Quantity for each Item is 5. 

 

Scenario 3: Price List on one Item with Manufactured Part

When you connect a Manufactured Part with an Item, IFS does not take the price list discount into account with the GRC.

 

 

Product Structure of Manufactured Part SIMON002. This scenario is again about Purchase Part S21127. There are 10 pieces in the assembly.

 

 

Result after GRC, no Price List discount calculated. IFS calculates with the ‘standard’ purchase price of 10 euros each instead of the price list discount of 5 euro each.

 

Scenario 4: Price List on multiple Items with Manufactured Parts

When you connect the same Manufactured Part with multiple Items, IFS does not take the Price List discount on the Supplier for Purchase Part into account. Conclusion: Price List discount is not calculated for Manufactured Parts. See example:

 

Product Structure of Manufactured Part SIMON002. This scenario is again about Purchase Part S21127. There are 10 pieces in the assembly.

 

 

Price List on Supplier for Purchase Part S21127:

 

 

 

Part connected with two Items, total Quantity of part S21127 is 20:

Result after GRC, no Price List discount calculated. IFS calculates with the ‘standard’ purchase price of 10 euros each instead of the price list discount of 2,50 euro each

 

Please let me know if this a bug or not


1 reply

Userlevel 2
Badge +4

Please see attachments for case with detailed screen shots

Reply