Product price (SAP Business One)

E-invoicing in Germany: How to implement the obligation with SAP Business One

Of the Product price in SAP Business One refers to the price lists stored sales or purchase price of an item.

To manage the product price in SAP Business One, various methods and sources are available for both setting and adjusting the price:

1. manual input and automatic calculation:

The product price can be entered manually
In Parts lists (BOMs), the unit price of the parent item can be calculated automatically. This is done by dividing the total price of all subordinate items by the product quantity when the "Set price" option is selected

2. price sources and base price methods: Prices can be obtained from various sources or determined on the basis of different methods

Price lists: Selection of a specific price list (e.g. retail price list, retail price list, discount price list).
Last determined price: The price that was calculated in the last simulation run for the Stock assessment (with continuous inventory management) or in the reporting run (without continuous inventory management).
Item costs: The calculated cost price of the item.
Last purchase price: The last price paid for the item.
Standard production costs: Standard costs that originate from production, relevant for production items.
Manual: A freely definable base price.

These base price methods can also be used for gross profit calculation in sales offers and other simulation documents. If the gross profit is negative, the result is shown in red.

3. treatment of acquisition costs (landed costs): For articles that require import or high Freight costs If the goods do not cause any damage, acquisition costs (customs, freight, insurance) can be allocated to the delivered items. This increases the stock value of the items and is crucial for a correct margin calculation with continuous inventory management. The allocation of ancillary costs can be based on the value of goods, weight or volume and directly influences the new item price (stock valuation). OINM) .

4. multi-level parts lists and cost roll-up: For multi-level BOMs (semi-finished products), the system breaks down the entire structure. The costs of the subordinate assemblies are calculated first and then added to the costs of the higher levels. This ensures that price changes for raw materials or resources are passed through the entire chain to the end product. .

5. subsequent price correction without stock movement: In order to subsequently correct a price (e.g. discount granted or incorrect price) without physically returning the goods and distorting the stock level, a credit note can be created with the option „Without Qty Posting“. In this case, only the price difference is specified, which enables a purely financial adjustment without affecting the inventory quantities and correctly reflects the sales correction in the „Sales Analysis Report“

Price types

List price: Standard price from the price list
Last purchase price: Price of the last procurement
Moving average price: Automatically calculated average

Use in SAP Business One

SAP Business One manages up to ten price lists in parallel. The price is automatically taken from the price list assigned to the customer.

SAP B1 blog