Inventory utilities
Use Inventory utilities to troubleshoot inventory valuations, General Ledger balances, and landed cost amounts. On each tab, choose a report and select Download to generate a CSV file.
| Subscription |
Inventory Control |
|---|---|
| User type |
Business, Employee, Warehouse |
| Permissions |
Inventory utilities: Edit
|
Transaction definitions
Use the Transaction definitions tab to view how your transaction definitions are set up.
Transaction workflows
The Transaction workflows report shows all the ways that transactions can be converted into other transactions based on your transaction definitions. It also shows how each transaction affects inventory values and quantities so you can identify why balances may not match.
For example, you process an invoice and you end up with a value that does not match the quantity. You download the Transaction workflows report, and it shows the following transaction definition:
Purchase Requisition ----> Purchase Order (ONORDER:+Q) ----> Supplier Invoice (ONHAND:+Q) ----> PO Return (ONHAND:-QV)
In this transaction flow example, the Purchase Order and the Supplier Invoice transactions increase only the quantity and not the value. The return transaction reduces both the quantity and the value, which compounds the problem because the value never increased.
Download the report.
| Column heading | Description |
|---|---|
| Document | Identifies the original transaction and subsequent convert-to transaction flow |
| Notes | Identifies any discrepancies between quantity or value transactions |
General Ledger groups and accounts
The Transaction definitions by General Ledger group report makes it easy to see which accounts are debited or credited as a result of transactions.
Download the report.
| Column heading | Description |
|---|---|
| GL group | Identifies the GL group set up for the transaction, if one is assigned |
| Customer GL group | Identifies the customer GL group set up for the transaction, if one is assigned |
| Doc ID | Transaction definition name |
| Debit account | GL debit account |
| Credit account | GL credit account |
The Transaction definitions by accounts report and the Accounts by transaction definition report both show the same information as the Transactions by GL Group report, but it's organized differently.
GL subledger reconciliation
The reports on the GL subledger reconciliation tab are helpful when you need to determine why the valuation report does not match the General Ledger.
Use the filters at the top of the page to generate specific report output, then select Download.
Transactions posting to the GL
The Transactions posting to the GL report lists all inventory transactions posted to General Ledger. This is the most detailed report on this tab.
Some transactions that do not post to a General Ledger account do affect the valuation report. These account fields are blank, and "No GL" appears in the Notes column. However, some of these transactions do affect the inventory valuation, and they might be a reason why your inventory account does not match the Valuation report.
Download the report.
| Column heading | Description |
|---|---|
| Document date | Date the transaction was completed in GL |
| Creation date | Date the user entered for the transaction |
| Document name | Transaction definition name and unique transaction number |
| Item | Item name |
| Cost method |
F = FIFO, A = Average, S = Standard, L = LIFO |
| Warehouse | Warehouse name |
| Quantity | Quantity entered on the transaction, purchased or sold |
| Currency | Transaction currency |
| Base currency | Location currency |
| Location | Company location |
| Debit account | Inventory account the transaction debited (value increase) |
| Credit account | Inventory account the transaction credited (value decrease) |
| Debit | Debit value |
| Credit | Credit value |
| Batch title | Name of container batch |
| GL group | Name of assigned GL group |
| Valuation rpt dr | Inventory subledger debits (increases) to ONHAND quantities or value |
| Valuation rpt cr | Inventory subledger credits (decreases) to ONHAND quantities |
| Valuation dr diff |
The difference between the inventory subledger debits and the GL posting debits |
| Valuation cr diff |
The difference between the inventory subledger debits and the GL posting debits |
| Notes |
If there are valuation debit or credit differences, Sage Intacct will recommend that you run the Maintain Inventory Valuation tool. This can help you identify and resolve potential rounding differences. |
Valuation by item, GL group, or GL account
These reports show your inventory valuation changes as a result of transactions occurring in a specific time period. You can view by item, GL group, or GL account.
Download this report.
| Column heading | Description |
|---|---|
| GL group | Name of assigned GL group |
| Account | Name of GL account impacted by the transaction |
| Currency | Transaction currency |
| Debit | Debit value |
| Credit | Credit value |
| Valuation rpt dr | Inventory subledger debits (increases) to ONHAND quantities |
| Valuation rpt cr | Inventory subledger credits (decreases) to ONHAND quantities |
| Valuation dr diff |
The difference between the inventory subledger debits and the GL posting debits. |
| Valuation cr diff |
The difference between the inventory subledger debits and the GL posting debits. |
| Notes |
If there are valuation debit or credit differences, Sage Intacct will recommend that you run the Maintain Inventory Valuation tool. This can help you identify and resolve potential rounding differences. |
Posts to inventory GL accounts not made by inventory
You may have posted to General Ledger inventory accounts that did not originate in the inventory subledger; therefore, none of these transactions are reflected in your Valuation report. Use this report to track and reconcile accounts that do not match the Valuation report.
Download the report
| Column heading | Description |
|---|---|
| Account | GL inventory account |
| Location | Company location |
| Currency | Transaction currency |
| Module key | Originating subledger |
| Symbol | Application abbreviation |
| Debit | Debit amount |
| Credit | Credit amount |
| Batch date | Date of the batch containing the transaction |
| Batch title | Title of the batch containing the transaction |
This report is also available to download as a summary report.
Running average cost
This report shows the average running cost for each item and warehouse. It’s the same value that appears in the Summary column on the Valuation report. All costs at a given warehouse are in the warehouse currency.
Download the report.
| Column Heading | Description |
|---|---|
| Item | Item name |
| Warehouse | Location where item originated |
| Debit or Credit | Indicates a debit or credit transaction |
| Document date | Date the transaction was posted |
| Creation date | Date the transaction was created |
| Document | Transaction document name |
| Cost method |
F = FIFO, A = Average, S = Standard, L = LIFO |
| Quantity | Received or shipped quantity |
| Quantity with value | Value of the quantity after payment (to a supplier or received from a customer) |
| Unit cost | Current item cost per unit |
| Cost | Total cost (Quantity*unit cost) |
| Quantity remaining | Quantity available for sale (Qty ONHAND-ONORDER) |
| Unmatched |
Indicates any transactions without a corresponding matching transaction. For example, the Unmatched column displays Yes if an incoming transaction to increase quantity does not have a corresponding transaction to increase value. If you use the Maintain Inventory Control tool, Sage Intacct automatically identifies and tries to correct any unmatched transactions. |
| On hand | Q = Quantity, V = Value, QV = Quantity and Value |
| Qty with value | Running total of on-hand quantities |
| Extended cost | Running total of all previous transactions |
| Average cost |
Running average cost of an item's extended cost |
Open periods, by location report
This report lists all locations with open periods and includes the date that the periods were opened.
Download the report.
| Column Heading | Description |
|---|---|
| Location | Entity location name |
| Open books | Open period date |
| Parent | Parent entity name |
Component Item Usage Report
Generate this report to help you locate all kits which include a specific item. With the kits identified, you can edit kit components.
To look for a specific item, first enter the Item ID in the filters section.
| Column Heading | Description |
|---|---|
| Level |
1 = The item is used as a primary component in a kit. 2 = The item is used as a component in a kit and, as a combined kit, is also used to create another kit. For example, you may have a Bike kit made up of a frame kit and wheels. The frame kit is made of pedals and handlebars. The pedals are used in the frame kit (level 1), and also used in the Bike kit (level 2). |
| Parent | Parent name |
| Parent item type | Type of parent: Kit or Stockable |
Landed costs
This report lists all of your landed costs transactions and shows the landed cost bill, the adjustment transactions, and the target transaction ID.
Choose a date range and review landed cost and adjustment amounts for a specific location.
-
If the landed cost transaction applies to multiple items, the landed cost transaction and amount is repeated in multiple rows.
-
Each item is in a separate row. When you add the total adjustments for all items, it equals the total landed cost amount.
-
For standard cost items, the adjustment amount is zero. However, the portion of the landed cost allocated to that item is posted to the General Ledger variance account—not the Inventory account.
| Column Heading | Description |
|---|---|
|
Document date |
The effective date of the landed cost transaction. This can be different than the date of the purchase or transfer. |
|
Landed cost transaction |
The landed cost bill from the freight company, or other originating landed cost document |
|
Adjustment transaction |
The adjustment created by the landed cost transaction |
|
Target transaction ID |
The purchase or transfer you're applying the cost to |
|
Landed cost amount |
The cost on the line item of the landed cost for the given item/warehouse |
|
Adjustment |
The amount of the adjustment for the given item/warehouse |
|
Target |
The transfer to location |
| Item | Name of the item |
| Warehouse | Warehouse location name |
| Quantity | Adjustment quantity |
| Location | Location where the landed costs are assigned |
