Original Unit Price/Cost & Line Discount
Two fields are added to the Sales Line table and Purchase Line table:
- "Orig. Unit Price" (Sales Line),
- "Orig. Unit Cost" (Purchase Line), and
- "Orig. Line Discount %" (both Sales Line and Purchase Line).
These fields will contain the original "Unit Price Excl. VAT" (Sales), "Direct Unit Cost Excl. VAT" (Purchase) and "Line Discount %", which were suggested by Microsoft Dynamics 365 Business Central based on the best price principle, when the line was entered. When a user decides to overrule the "Unit Price Excl. VAT" (Sales), "Direct Unit Cost Excl. VAT" (Purchase) or "Line Discount %" these fields will not be changed.
The fields "Orig. Unit Price" and "Orig. Line Discount %" are also added to all other tables associated to the sales and purchase process, i.e., "Sales Quote Line", "Sales Order Archive line", "Posted Sales Shipment Line", "Posted Sales Invoice Line", "Purchase Quote Line", "Purchase Order Archive line", "Posted Purchase Receipt Line" and "Posted Purchase Invoice Line" as well as in the return order process tables and pages.