25 apr

moving average (SAP Business One)


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

Of the Moving average is a warehouse valuation method that dynamically recalculates the average price of an item after each purchase. Stock withdrawals until the next purchase are valued at this updated average price.

Important aspects of the moving average:

  1. Ongoing price update:
    • After each goods receipt, the average price of the item is calculated based on the purchase price and the Quantity recalculated.
    • This ensures that the stock value is continuously adjusted to current purchase prices.
  2. Bearing-dependent calculation:
    • If the option "Manage article costs per warehouse" is activated in the company details, the average price is calculated separately for each warehouse.
    • Without this option, a standardised average price is calculated for all warehouses.
  3. Stock revaluation:
    • Items with a moving average can be analysed with the help of a Stock revaluation document adjusted in order to adjust the inventory value to current market conditions.
  4. Display in the article master data:
    • The moving average price is displayed in the "Article master data" on the tab "Inventory data" displayed, either for each warehouse individually or for the entire item stock.

Advantages:

  • Realistic valuationThe moving average reflects fluctuations in purchase prices and thus provides a precise value of the inventory.
  • Simple implementationThis method is easy to use and is well suited to companies with frequently varying purchase prices.

The moving average is particularly useful for companies that value a dynamic and market-orientated inventory valuation. It enables realistic and flexible management of storage costs.

 

Webinar Versino Financial Suite

Two free webinars in July: Experience the Versino Financial Suite live

In 90-minute sessions, we will show you in a practical way how to automate your accounting in SAP Business One – on the 23rd...
E-Invoice-International

E-Invoicing 2026: What is changing now for SMEs and SAP B1 users

The e-invoice has moved beyond the theoretical IT project phase. Since January 2025, the obligation to receive e-invoices applies to all domestic companies — ...
SAP Business One Netting and Accounts Payable

Netting in SAP Business One: What makes the Versino Financial Suite different

When a business partner is both a customer and a supplier, that sounds like a comfortable situation. You know each other, you trust...
Susa-in-the-Versino-Financial-Suite

Trial Balance in SAP Business One: What the Versino Financial Suite does differently – and why tax advisors notice

The Trial Balance is one of the oldest reports in accounting. Every accounting program has it, and SAP Business One itself...
UPDATE Versino Financial Suite

Versino Financial Suite Version 05.2026: What's Changed

Version 05.2026 of the Versino Financial Suite brings two innovations that directly target time loss and system limitations in daily...
E-Invoice-International

E-Invoicing 2026: From Receipt to Mandatory Issuance — what SMEs must clarify now

From 1 January 2025, every B2B company in Germany must be able to receive electronic invoices — regardless of turnover. One and a half years...
Wird geladen …