...
- Select Company and click Submit
- Select ALL Location under 1 Company and click Submit → controlled under permission
- Select Date → key in end of financial year
- Key in Item Code Description → leave it blank to view all
- Key in Item Code Range → leave it blank to view all
- Select Item Category → leave it untick to view all
- Select Item Status →select ALL
- Select Item Type → deselect will generate All Type (If you wish to Compare Balance Sheet to Inventory, please select Inventory type only)
- Tick Group By → leave it untick
- Select Order by → item name or item code
- Tick Options → tick ALL
- Select Transaction Type → deselect will generate All Type
Sample of Report
NOTES:
UOM → Unit of Measurement
- QTY (A) → Stock Quantity on the selected date
- Min Purchase Price → Minimum GRN Price
- Max Purchase Price → Maximum GRN Price
- Curr MA (B) → Item Moving Average on current date which can be compared with Stock Movement
- Inv Value base on Curr MA (A*B) → Curr MA * Qty on the selected locations under 1 company
- Historical MA (C) → Balance Sheet "Inventory" Value (for all locations under 1 company) / Stock Quantity (for all locations under 1 company)
- Inv Value based on Historical MA (A*C) → Historical MA * Qty on the selected locations under 1 company
- Last Purchase → latest GRN Date
- Total of Column Inv Value based on Historical MA (A*C) need to be the same with Balance Sheet "Inventory" Value (the breakdown of the Item Code inventory value can be seen under Stock Movement)
Example:
Example item Test_Item has the following transactions:
...