6.4 Report
Inventory Reports
When to use: To check and reconcile inventory data: stock balance, receipt/issue details, stock cards, material ledgers, and inventory status by period. Reports serve inventory management, reconciliation with general ledger (Accounts 152/155/156), and financial statement preparation.
Example: View the inventory receipt/issue/balance report for Jun/2026 to reconcile Account 152 balance on the general ledger, preparing for semi-annual stock count.
Report types:
Stock Card / Material Detail Ledger: Track receipts, issues, and balance of each material in chronological order — equivalent to physical stock card per form S12-DN (Circular 200).
Receipt Detail / Issue Detail: Check receipt or issue vouchers for a time period, down to individual vouchers.
Receipt Summary / Issue Summary: View consolidated receipt or issue data by material, warehouse, or group — without voucher-level detail.
Receipt/Issue/Balance / Inventory Status: Reconcile opening balance, receipts, issues, and closing balance — equivalent to the consolidated NXT report per form S11-DN.
Inventory Transactions: Trace all inventory transactions when detailed journal-level verification is needed.
To view a report, the user proceeds as follows:
Select the report type from the list.
Enter the date range in the From Date / To Date fields.
Select Warehouse, Material Group, Item Code, or other filter conditions as required.
Click View Grid / Preview to display the report, or Print / Export Excel for archiving.
Note: Inventory report data is only accurate after completing the 5-step processing workflow at Processing → Production Cost & COGS Calculation. If the workflow has not been run, COGS and inventory balances may not be updated.
Last updated