ICRTT – Inventory Control Trial Balance Report
Use this report to compare the balance of the General Ledger Inventory account to the subsidiary valuation of the stock inventory.
The subsidiary value is determined by adding the On Hand, Unavailable, and Received quantities for each stocked product from Product Setup. This total is then multiplied by each product's respective cost from Product Setup.
Close all open journals before you run this report. If a journal is open, the journal number, operator, function name, date and time is printed at the top of the report. Find the journal, close it, and then rerun the report.
Address: ICRTT
Menu: Product > Reports > IC Reports
Click the <Right Arrow> next to ICRTT
Click <NEW> <One Time>
Select the output type for this report.
Email is the advised Print Type
CAUTION!! Do not print this report until tested as an email!
The output could be 1,000’s of pages, depending on the ranges and options selected.
When Print Options is checked, the Options and Ranges are the first page of the resulting report. This is handy as a reference on how the results came to be on the rest of the report.
Email Address: Verify this is your email address.
Comments: Enter reference details. Comments will appear in the body on the resulting email.
Click <NEXT>
Enter any Range limitations necessary for the situation.
Typically values are left blank, all branches for the company logged into will be included on the report. Running this report wide open will compare the Full GL.
Do not be alarmed - Use of any of these ranges/segments will display an out of balance situation. The use of any of these ranges would not be for balancing purposes.
Click <NEXT>
Options: #5 typically would default to <G> for General Ledger.
USE CAUTION if D(etail) is needed. The report length will be astronomical.
Changing this to <D> will add additional options to be used: #6, #7 and #8.
Option #11 = Yes. No Journals should be open when this report is processed.
Click <NEXT>
When Print Options is checked, the Options and Ranges are the first page of the resulting report. This is handy as a reference on how the results came to be on the rest of the report.
If #8 is set to No, the report will have 1 line per item, easier to read but without item’s description
CAUTION should be used if you choose to print this report out in full.
Below is part of the report for only 1 warehouse. The report was 234 pages.
The bottom of the report reads as followed...
