ICRTD – Direct Inventory Trial Balance Report
Use the ICRTD report to compare the balance of the General Ledger Inventory account to the subsidiary valuation of the Direct Order Inventory. The subsidiary value is determined by comparing the sum of the active drop ship lines in internal direct order line-item records to the General Ledger balance for Direct Order Inventory.
Note: Close all open journals before you run this report. If a journal is open, the journal number, operator, function name, date and time are included at the beginning of the report. Close the journal, and then rerun the report.
The ICRON - Non-stock/Direct Order Report is a complementary report to the ICRTD Trial Balance of Non-Stock Inventory Report. The ICRON includes all the active direct order inventory lines.
Any balance in the account should represent a direct order product that has been received on a purchase order but has not been invoiced. After researching the purchase order, research the associated order to determine why it was not invoiced. Additionally, check if the tie between the purchase order and sales order was broken.
How to Run the ICRTD Report:
Address: ICRTD
Menu: Product > Reports > IC Reports
Click <NEW> <One Time>
Select the Print Type that best suits. If email, make sure the appropriate email address is entered.
If <Print> is selected instead of email, enter or look up the proper printer.
Click <NEXT> after the email address or printer has been entered
Enter the Ranges of data to narrow the report results.
Typically the report would be processed for 1 warehouse at a time. Leaving Warehouse blank will run this report for the whole company that you are currently logged into.
Click <NEXT>
The option page defaults are fine as displayed…
Click <NEXT>
Click <SAVE> to run the report
The following is an example of two warehouses’ Direct Inventory balances.
Warehouse 19 appears to have a total value of $37,300.04 in Drop Ship/Direct Order Inventory. This is concerning since we should never have Direct Inventory. The workflow is: The direct PO is received and the tied sales order should invoice later the same day. There are only 2 PO’s listed so most likely there are only 2 sales orders being held. Contact the branch to find out what is going on with these orders. Investigation can happen starting in POIP.
POIP – PO Inquiry
Enter the Purchase Order #
Click <SEARCH>
Under the Header, the Tied Sales Order # is listed and note that the Stage of the PO is past the Received Stage (Closed). Click on the order Number for more details
OEIO – Order Inquiry
The tied order has been cancelled. This reads like it has landed on the jobsite but hasn’t yet been billed.
The Customer needs to be billed for that material, if further investigation warrants this assessment.
