RE: How can I fix bad records in the Historical Inventory Trial Balance?
This issue is a critical one, and the solution is not limited to a certain step that you just apply and get it done. The symptoms of this case is shown when you print the HITB report and find one of the following;
- Zero Quantity with negative cost
- Zero Quantity with Positive Cost
- Quantity available with negative cost
My fist assumption is the (Cost Adjustment) document is caused the problem. In order to get this issue corrected, you need to go through the following steps;
Internal Inventory Reconciliation:
- Run an Inventory Reconciliation as a prerequisite
- Check IV10200 versus IV10201. Find the post on GP Essentials - Inventory Reconciliation - Purchase Receipt Work and Details
- Check IV10200 versus SEE30303. Find the post on GP Essentials - HITB Essentials Series – Zero Quantity and Negative/Positive Cost
Once the steps above are fully applied, with no inventory corrupted documents among IV Tables. We could move to the step below;
IV10200 and SEE30303 must have the same value (Extended Cost) for remaining item quantities. Manual entries might be needed to be recorded on SEE30303, with a preceise justification.
- IV10200 has the correct cost always (after every cost adjustment, the old cost is recorded in ADJUNTCOST, and the UNITCOST field is updated. Which will give you a correct value for the remaining IV Quantities for each item.
- As for HITB (SEE30303), cost adjustment documents are not always recorded successfuly for several reasons. For instance, the layer has been consumed out. Of course, when the cost adjustment is posted, the COST Adjustmnet Report states that there are entires that could not be made, and therefore manual entires should be made.
I have seen some customers who prefer to delete all SEE tables, and re implement the HITB reset tool which rebuilds SEE30303 based on the values remaining in IV10200. This could be a relevant and easy fix, although, you will lose your cost adjustment history as all cost adjustment documents will be deleted.
Unfortunately, there is no easy one step fix for this issue. This is a complete correction process which, above all, should have all corrupted issues resolved before being started.
Therefore, I am trying to complete my HITB Essentials Series, which should hopefully provide a precise and easy road map on the correction criteria along with the required steps. Untill the series is completed, I hope my brief explanation above would provide an added value to your task.
Share
Report
225
All responses (
Answers (
