Announcements
845
Hi,
During the activity of Year-End closing there is an optional task of HITB report , I was confused about that running HITB reports first time requires the resetting of the Inventory module, is this resetting required every time we run the HITB report ?
Secondly if i have done the inventory reset every time i ran HITB, what effects does it causes ?
Thanks
Mahwish
*This post is locked for comments
When cost is changed; for several reasons, a cost adjustment record is thrown in SEE30303 to modify the cost of an existing cost layer. These documents could be;
Let me give you an example,
You receive an item through the "receiving transaction entry" with an initial cost (50) per item, although, when you invoiced the shipment, the vendor increased the initial price from 50 to 52. When you enter/match the receiving above, a cost adjustment document from POP invoice will be thrown in SEE30303 [Historical Inventory Trial Balance], to adjust the shipment cost. On the other hand, this document will be linked to a Journal Entry to adjust cost in General Ledger.
There are other reasons in which cost adjustment records are thrown in Inventory HITB, such as "Adjust Cost Utility".
In order to check your Inventory Versus GL, please check the following post on my Blog;
Please be noted that matching Inventory to GL shall be only done after the following inventory tables are reconciled internally;
I will be glad to provide any further help if required. Please e-mail me on mahmoodsaadi@live.com regarding any explanation on the issues above.
Thank you very much for your reply. Can you please guide me further for the following concerns :
1. How can we find out the date on which we ran the HITB rest tool?
2. The Cost adjustment that you are talking about- do you mean the highlighted transaction below? This is an excerpt of out HITB report as you can see the highlighted transaction has no general entry and no corresponding contra transaction. Hence this transaction is effecting module balance but not the GL. How do we address this situation and how does these transaction arise?
3. Can you please give me the script you mentioned in your email as we have not yet updated to 2013.
I am really great full for all the help.
Best regards
Mahwish
As for (2) a, b and c,
The HITB reset tool is run for one time only, once implemented the HITB report and tables are created to be used later on.
As for (3), regarding the mismatch between Inventory and General Ledger, there are several reasons which causes variances, such as;
Although, the above are usual reasons that are almost has been known and quite common for businesses. In addition, one of the most important reasons that cause such variances is Cost Adjustment documents.
If you have already upgraded to GP 2013, you could make use of the Reconcile utility in inventory, which provides you with a detailed report on the variances in your GL-IV per journal entry. Though, if you don't have this utility implemented, I could provide you with a script that that prints out the same report.
You could review my blog as there are few posts on the Inventory versus General Ledger issues.
Thanks Mahmoud :) , my apologise for not defining my problem sufficiently let me rephrase my problem please see below
1. We have already installed the HITB report using the proper procedure i.e. running the rest tool etc. This was installed before last year’s (FY 2011-12) closing of inventory. After installation of the HITB tool we closed inventory last year.
2. Do we again have to run HITB reset tool before this year’s (FY 2012-13) closing or was it a onetime activity that we have already performed last year.
a. Can we run the reset tool again? Is it advisable or not ?
b. If we run the reset tool again, what will be the effects.
c. If we have started running the tool again and have reached step 4 can we stop at this step or do we now need to complete the activity.
3. Even though we are taking extreme care but still we are continuously running in to mismatch between ledger and inventory module? Any reasons that you can think of as to why are we getting in to this trouble. We are quite sure that this is not a setup mistake but some procedural mistake.
Best regards
Mahwish
I guess you are talking about the HITB reset tool, when this tools is run for the first time, there are several steps that should be considered as prerequisites, those configuration steps will be run once only at the first time.
For reference, I will include the following details,
You should ensure to run the HITB reset procedures on Database company in order. Then, the cnk file will be thrown in C:\Program Files (x86)\Microsoft Dynamics\GP2013. Now, when you run Dynamics GP as "administrator", a new message will prompt to include the code.
Now, GO to Tools > Utilities > Inventory > HITB Reset Tool. The wizard will go through the following steps;
In case you want to skip the "reconcile" steps during the first run, you could include the following in your Dex.ini file;
HITB_SkipReconciles=TRUE
HITB_SkipErrorChecking=TRUE
HITB_SkipClearingTransactions=TRUE
HITB_SkipVersionChecks=TRUE
HITB_DebugFile=c:\somefile.txt
The Historical Inventory Trial Balance Report is an essential report to be included when reconciling Inventory versus General Ledger. In this essence, when reconciling your IV-GL, don't consider the Historical Stock Status report, use the HITB report instead.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
