The last price determined is a standard price list in SAP Business One that is managed by the system and cannot be changed manually. Inventory valuation reports is dynamically updated and serves as a calculation basis for various cost calculations.
The last determined price is only calculated for the inventory unit of measure (Inventory UoM) of an item and only in the primary currency. The update takes place as soon as the Inventory Audit Report or the Inventory valuation simulation reportt (Inventory Valuation Simulation Report). With the Moving Average Price valuation method, the last price determined corresponds to the cumulative value divided by the cumulative quantity, whereas with the FIFO (First-In, First-Out) method, the item costs of the next open shift are used. This price can also serve as the base price origin for the gross profit calculation in sales documents, provided that the „Last determined price“ option is selected in the document settings. It can also be used as the basis for determining the return costs of an item. It is also available in the Stock entry is available as a price source for valuing inventory differences, but only if an inventory valuation report has been created beforehand. If the company does not use continuous inventory management, the price for gross profit and return costs is taken from the most recently created inventory valuation report.
Demarcation:
The last determined price differs from other price lists in that it cannot be maintained manually, but is only updated by the system on the basis of the stock valuation reports. In addition, it is only calculated in the inventory unit of measure and in the main currency, which is why it primarily serves as a technical calculation basis for inventory and cost valuations. In contrast to freely definable sales prices, its use is therefore primarily focussed on gross profit calculation, return costs and inventory postings.
New in SAP B1 10.0 FP2602: Inventory & Logistics, Production, Banking
Mobile warehouse 2025 with Versino Warehouse Pro
Moving average price in SAP Business One
Units of measure in SAP Business One
Warehouse management with SAP Business One
Consignment warehouse in SAP Business One
MRP - Material Requirements Planning in SAP Business One
