ICRON – Non-stock and Direct inventory Report
This report will list all nonstock and direct order inventory movement per branch or the whole company. Each nonstock and direct line item that is received will create a set of information. Once the item is either: Invoiced, Received on a Return PO or written off the set should become inactivate. There are occasions where a received cost or quantity do not align with the Shipped value(s). Investigation must be completed to determine the next course of action. The ICRON report will provide details to help in any investigation necessary for Nonstock or Direct Order items that are still open.
This guide will provide instruction on how to run this report and then how to read the report.
Address: ICRON – IC Non-stock/Direct Order Report
Menu: Product > Report > IC Reports
Click <New> <One Time>
Select the appropriate Printer type: Email is suggested but not required.
If email is used, verify that the email address is correct, Update email address if necessary and then click <NEXT>
If another Print Type, Enter the details necessary for proper output method then Click <Next>
Enter the Range(s) to limit the resulting report.
Often times the Whse range is the only value entered.
Click <NEXT>
Option 2 can be used to limit the report results to just (N)on-Stock or (D)rop/Direct Inventory or (B)oth.
Option 3: Yes
Option 4: X = All
Click <NEXT>
Click <SAVE> to run the report
The resulting report will show all active Nonstock items for the warehouse in one section and Drop/Direct Inventory in another section of the report. All values listed are considered as active inventory in the warehouse for which the report was processed. These items should be accounted for in the warehouse. If the items are at the customer’s site, investigation should happen regarding the reasoning for the delay in billing. Not all listings are related to a quantity. If there was a discrepancy in cost, there will be a cost only record to be investigated and action taken.
The following is the first page with all Drop/Direct Items.
Summary:
Item 81878APB
A qty of 576 @ a cost of 5.17/each was received on 8/17/22 on PO 4504275-00
A qty of 576 @ a cost of 5.17/each was shipped out on 8/17/22 on OE 4573660-00
A qty of 504 @ a cost of 5.15/each was received on 8/17/22 on PO 4504275-01
A Qty of 504 @ a cost of 5.15 was shipped out on 8/17/22 on OE 4573660-01
The transactions appear to be all good. However, the dollar value of -$11.52 remains as we were invoiced and AP paid less than the PO was entered and received.
Result: The cost in ICEAN should be adjusted by Head Office to close out the set.
Branch does the research and provide guidance for, Inventory to do the adjustment.
The next page is Nonstock items with balances.
The following are a couple of examples:
Item: 345200
Item was received qty 1 @ .00 on PO 4504270-00. Date: 7/15/22
Item was shipped qty 1 @ .01 on OE 4573375-00. Date 7/20/22
There is a .01 cost difference. Had the cost on the PO been entered at .01 this would not be here.
Result: an adjustment for .01 should happen to close this set.
Item: 350-679
Item was returned in on Order 4553528-00. Qty 6 @ 10.71 Date: 7/17/18
No Return PO was issued and received. Inventory remains in inventory and should be out in the warehouse.
Result:
- Contact the vendor to coordinate a Return to Vendor
Sometimes an item can be in the warehouse waiting for the customer to authorize delivery. Anything more than a couple of weeks is an issue and needs to be acted upon.
The following is an example where there is NO corresponding order for the nonstock. If there was a corresponding order, it would show the order below with no journal number or post date. This example is a situation where the customer order was cancelled and the product remains in inventory. This needs to be RETURNED to the vendor or BILLED to the customer.
