Understanding the calculations on the Stock Valuation Report.
Explaining the Stock Valuation Report
Check if the Stock On-Hand Quantities and Accounting Stock Quantities differ
Explaining the Stock Valuation Report
The Stock Valuation Report records Stock in Branch Average Cost Accounting Value, and Rebate Adjusted Accounting Value.
What does Rebate Adjusted Accounting Value mean?
The Rebate Adjusted Accounting Value is calculated as follows:
The (Accounting Quantity*) x (Average Cost**) x (1 - (Other rebate percent*** / 100)).
Definitions
Accounting Quantity* is defined as:
(Total of the purchased quantity) + (Transferred in quantity) + (Transfer out confirmed quantity) + (Sold quantity) + (Adjustment quantity).
Average Cost** is defined as:
Month end Average Cost (if not null or zero), or current average cost (if not null or zero), or 0.
Other rebate percent*** is defined as:
(Unqualified rebate percent) + (Qualified rebate percent) + (Marketing rebate percent) + (Points rebate percent).
All these values are taken from the Stock record unless that value is null, in which case it falls back to the Payable Account.
Check if the Stock On-Hand Quantities and Accounting Stock Quantities differ
When you run your Stock Valuation report, you have an option to check whether the stock on hand and accounting quantities are different.
On-Hand Stock Quantity is updated from Delivery Notes (inwards stock), and Packing Slips, (outwards stock).
Accounting Stock Quantity is updated from Invoices and Credits.
If these documents are not showing the correct branch details, or have not been processed, differences can occur.
- From the Stock > Stock Valuation menu option:
- Select the Month end date and any other criteria you want.
- Shelf and accounting quantities differ: Select Yes to report only stock items where these values differ.
|
Need more help? We’re here! We hope our article was helpful! If you need more info or want to connect, drop us an email at support@lentune.com. Thank you. We love to hear from you! |