Here are a few articles that may help from the accounting side;
- KB 950020 - Info about posting transactions for a stock count that has been started in Inventory in Microsoft Dynamics GP
- KB 862352 - Error message when you enter an amount in the Variance Qty field in the Inventory Stock Count Entry window in Microsoft Dynamics GP: "The quantity entered is greater than the quantity available"
- KB 929210 - Error message when you perform a stock count on a serialized item in Microsoft Dynamics GP: "The variance or counted quantity for this serial number does not equal the variance or counted quantity for this item"
If you have just gone through a stock count and you are "good" with your inventory, then now is a perfect time to implement HITB as you are confident in your item quantities!
If you are not already printing the Historical Inventory Trial Balance (HITB) report and using it to reconcile to the GL, how come? The HITB report was designed with reconciling to General Ledger in mind. It provides you a point in time value of your inventory items as well as their quantity information. This way you can go ‘back in time’ and see what the value of your inventory was on a certain day.
To print this report from the Reports menu point to Inventory and then choose Activity reports. “Historical IV Trial Balance” should be the last one listed. If you do not see it, then you have been using GP for a while (say pre-R10 SP2 days) and you must go through an IV Reset process in order to “activate” HITB so that you can start capturing this data.
What does the IV Reset process does and how to do it? CLICK HERE
Once HITB has been activated any new transactions that affect your item’s cost will be captured in the SEE30303 table for reporting. The sooner you do the IV Reset the sooner you can start using the report!
