Profit % can't exceed 9.999999

olwin · 2009-05-01

Hi there,

If I change the Profit Calculation on the Item Card (Invoicing Tab) to Price=Cost+Profit. I can't enter the profit % exceed 9.99. Any idea?
And the second concern is if I choose Profit=Price-Cost. Say if I set the price 4000 and the cost is 351. The Profit % become 91.225. Where this amount come?

Thanks.

mohana_cse06 · 2009-05-01

in item table "Price/Profit Calculation - OnValidate()"

CASE "Price/Profit Calculation" OF
"Price/Profit Calculation"::"Profit=Price-Cost":
IF "Unit Price" <> 0 THEN
"Profit %" :=
ROUND(
100 * (1 - "Unit Cost" / ("Unit Price" /
(1 + VATPostingSetup."VAT %" / 100))),0.00001)
ELSE
"Profit %" := 0;
"Price/Profit Calculation"::"Price=Cost+Profit":
IF "Profit %" < 100 THEN BEGIN
GetGLSetup;
"Unit Price" :=
ROUND(
("Unit Cost" / (1 - "Profit %" / 100)) *
(1 + VATPostingSetup."VAT %" / 100),GLSetup."Unit-Amount Rounding Precision");
END;
END;

olwin · 2009-05-01

Can you tell me step by step how where to paste your code?

Thanks

mohana_cse06 · 2009-05-01

its already in item table Price/Profit Calculation - OnValidate() Trigger

from here profit % is calculated.

Profit % can't exceed 9.999999

Comments

Categories