PRICE LIST CALCULATIONS
Just in case you don't know what a PAD is, it's a % or $ that's add on to the incoming product that is calculated for funding of facility and operations expenses. I've created my purchase price list and defined that PAD % per category that I need, based on supplier form. Then I add the sales price list as a Tier level per category, based on "other price list" PAD %. However, when you look at cost on quote or invoice, it shows the cost your entered with no PAD, then the system calculate correctly the percentage. My problem, I would like to hide the original cost and only allow the salesmen to see the cost after the pad is calculated.
With Purchase List (PAD) and Sales List (Tier)
Product 1 cost $68.76 x 12.5% PAD = $77.355 x 25% Tier = 19.33875 + 77.355 = $96.69 (it's calculates correctly)
Just Sales List at total sum %
If I skip the PAD break down % and just for 37.5% it's 68.76 x 37.5% = $25.785 + 68.76 = $94.545. (it calculates incorrectly)
Moving forward, I need the salesman in quote/ invoice to only see the figure once the system has calculated the supplier cost + PAD ($77.36). Is this possible?