Costing

Hi All,

Can anyone tell that how does Navision calculates the Unit Price & Profit% … I think there has to be a formula deep in NAV somewhere …what it shows on Invoicing tab on the Item card .Kindly explain .

Cheers,

Navitech

Depending on the “Price/Profit Calculation” the calulation is:
“Unit Price” := “Unit Cost” / (1 - (“Profit %” / 100))
or
“Profit %” := 100 - ((“Unit Cost” / "Unit Price) * 100)

  • add some rounding

Btw - that formula is not that deep in NAV…

Shown on the Item Card in all versions and explained in on-line help.

Check out codeunit 5804 - ItemCostManagement.

Do you mean the Unit Price on the Sales Line?