25 apr

moving average (SAP Business One)

Versino Financial Suite

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.

 

E-invoice check

E-Invoice check by Versino Financial Suite

An e-invoice is quickly generated. SAP Business One includes the XRechnung feature as standard, and those who use cks.eINVOICE or the ...
Versino Accounting Service

Versino accounting service

Bookkeeping should run quietly. Vouchers come in, are posted, the VAT return goes out, and the tax advisor also gets a ...
Cash flow forecasting SAP B1

Cash flow planning in SAP Business One: What the Versino Financial Suite does differently

Cash flow planning is considered a done deal in many medium-sized companies. After all, there are bank statements, there are open items, ...
Webinar Versino Financial Suite

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

In 90-minute sessions, we'll show you practical ways to harmonise, streamline and automate your accounting in SAP Business One….
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...
Wird geladen …