Inventory
Inventory Reports - Accounting
Overview#
Inventory – Accounting provides the same information as the Ledger. This view is limited to those accounts that are used in inventory transactions.
Info- The Account list shows the accounts in the item setting Items & Inventory > Filter – Accounts that update Inventory (see Inventory Reports Settings).
- If the setting is blank, the list is empty and the report shows no entries.
Navigation ExampleMain Menu > Procurement > Inventory > Menu (button) > Accounting
| Button | Description |
|---|
| View | Generates an extract from the ledger based on the selected filters. |
| Output | Available upon request. |
| Menu | See the Menu button described under Inventory Reports Settings. |
Filters Explained#
| Filter | Description |
|---|
| Date | Select a date option. The options are:- No Date
- User Date
- Today
- Yesterday
- This week
- Last week
- This month
- Last month
- This year
- Last year
- Fin Year
With User Date, enter the start and end dates in the boxes next to it. |
| ⬅ ➡ | Adjusts the date field depending on the option chosen next to Date. |
| Account | Select the inventory account to report on. The report needs an account: it shows no entries until one is selected. |
Fields Explained#
| Field | Description |
|---|
| Field Chooser (*) | Add or remove columns. |
| Trans | A description of the transaction (e.g. SI-Inv). |
| No. | The transaction's system-generated number. |
| Item No. | The system-generated item number of the transaction. |
| Status | The Status of the transaction. |
| Date | The Date of the original transaction. |
| Code | The inventory item's Code. |
| Description | A Description of the inventory item. |
| Category | The inventory item's Category. |
| Dr Acc | The account that was Debited. |
| Cr Acc | The account that was Credited. |
| Type | The type of item (e.g. ITM for item or CTM for custom item) |
| Qty | The item's Quantity. |
| Unit | A description of the item's Unit. |
| Trans Price | The transaction's value. |
| Currency | The transaction's Currency. |
| Stock Price | The item's Stock Price. |
| Variance | The difference between the Transaction and Stock Prices. |
| Debit | The amount that was Debited. |
| Credit | The amount that was Credited. |
| Balance | The Ledger Account's balance. |
| Menu (...) | A submenu that can also be accessed by right-clicking an item:- Open Transaction: Opens the original transaction.
- Open Item: Opens the item's setup page.
- Open Item Dashboard: Displays a Summary of the item's activity.
|
