Friday, May 25, 2018

Dynamics NAV - Modify Sales Quote

R204 - Sales Quote

Field calculations used

Enter all calculations under Integer group under Sales Line. Do not use the actual Sales Line group.
Use max for all values in the report.

Unit Price NoVat, no Discount = "Sales Line".Amount / "Sales Line".Quantity
Gross Total (UnitPriceNoVat, no discount x qty) = "Sales Line".Amount
NetAmount (line total no vat no discount):= "Sales Line".Amount-"Sales Line"."Line Discount Amount"-VATAmount;

No comments:

Post a Comment