Resetting Inventory for HITB

(0) Share

Report

Posted on by spena

1,501

Hi,

I'm going through the HITB pdf which includes instructions on resetting the inventory balances in GL. There is a bullet point that states "You must post all transactions that can affect your purchase receipts before using the HITB Inventory Reset Tool." My client has several open orders and purchase orders which allocate inventory (sales orders) and increase on order amounts (purchase orders).

What, if anything, needs to happen to the sales orders and purchase orders? They don't affect receipt layers, as only invoices and p.o. receipts would. Do we just need to post unposted sales invoices and unposted p.o. receipts, as well as post any unposted inventory transactions?

I imagine the goal is to get an inventory balance at a point in time. If so, I would assume the sales orders and purchase orders can remain in the system, but some clarification would be much appreciated.

Thanks,

Steve

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

soma 24,410 on at

Like (0)

Report

Steve,

You are correct. The HITB reset tool is used to get an inventory balance at a point in time. I won't affect any sales and purchase orders. Everything will remains in GP. But, the inventory balances won't tally if you have any unposted Sales Invoices and Purchasing Receipts. Please post the unposted transaction and run the HITB reset tools to get the correct Inventory Balance.

Hope this helps!!!

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Deploying the HITB reset tool is quite straight forward, although, it is not recommended to be run by clients themselves as deep and thorough analysis is required at further steps of the processes.

The main essence of the process is to recalculate item balances based on Dynamics GP cost layers (IV10200 and IV10201) (Purchase receipt work and details), these tables are not affected neither by the purchase orders (originating from POP) nor the sales orders (originating from SOP). Therefore, follow the following steps precisely:

Back up

Restore on a test company to check the results (primarily the staging report showing the variances among your inventory and GL)

Post all inventory-related transactions which mainly affect inventory balances

My recommendation is never to run through this process in case you don't have sufficient knowledge enough. In case you do have the knowledge, you might need to go through the following references:

HITB Essentials Series - HITB Reset Tool Deployment

HITB Essentials Series - HITB Reset and SEE Tables

Never hesitate to share any further inquiries,

Was this reply helpful? Yes No
spena 1,501 on at

Like (0)

Report

What if there are invoices that can't be deleted? For example, if a sales order has been transferred to an invoice, but can't actually be posted for some reason, would leaving the invoices unposted cause issues?

I looked at the IV10200 and the IV10201 for an item before an invoice was created and after an invoice was entered the same and none of the fields changed, leaving me to believe there wouldn't be issues with leaving the unposted invoices in a batch.

What are your thoughts?

Thanks,

Steve

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Sales orders affect inventory allocations only, never create any record in IV10200 nor IV10201. Only the allocation quantity in IV00102 is affected. Additionally, when the sales invoice is posted, it withdraws quantity from IV10200 cost layers, and create an associated "out" record in IV10201.

The least thing you would need to get a headache of is the unposted transactions, just make sure all inventory related unposted transactions are posted.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

I ran this tool last weekend. I had unposted SOP transactions and released PO's and it was not an issue. I did have an unposted POP Return transaction and the wizard stopped until I addressed that (by deleting it).

I do recommend running in test first, as you may be surprised at the variances. In one case I discovered inventory in the "damaged" status which used a strange GL code. I put it back into on hand and re-ran the wizard and had cleaner results. YMMV. -Trevor

Was this reply helpful? Yes No
spena 1,501 on at

Like (0)

Report

I ran the process, which was actually quite simple, yet I have another question.

All my items are assigned to just one inventory account in item maintenance (1300). However, I have some items received into an "In Transit" warehouse when received in the PO module. The gl distribution is changed to the In Transit account (1310) during the receiving process.

So before running the tool, I had $2,300 worth in my inventory subledger - $2,000 in my Main warehouse and $300 in my In Transit warehouse.

In GL, I had $2,000 in my main inventory account (1300) and $300 in my In Transit account (1310). Running the tool cleared all the value ($2,000) out of 1300 and did not take anything out of 1310. Similarly, all the value ($2,300) was put back in to 1300. The HITB reset essentially ignored my in transit account 1310.

So now, my combined inventory (main GL account 1300 plus my in transit account 1310) is over stated by $300.

How do I fix this without affecting the beginning balances? Taking everything out of in transit prior to running the tool is not an option. Normally, a simple journal entry would take care of this, but I'm not sure how this will affect the beginning balances for the HITB.

Thanks,

Steve

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

HI Steve,

Can you clarify your setup a bit? In your example, 1300 and 1310 appear to be natural/main accounts. Do you have a single segment on your GL string, or do you also have a company/location segment? What do you have listed as the "Segment ID for Sites" in the inventory setup?

When you receive into In Transit, are you manually flipping the GL code to 1310, or is it automatic?

-Trevor

Was this reply helpful? Yes No
spena 1,501 on at

Like (0)

Report

Hi Trevor,

We just have a single natural segment and the natural segment is the Segment ID for Sites in inventory setup.

We are manually flipping the account code to 1310 when we receive inventory. FYI, this is not In Transit Transfers. We receive into an In Transit Site, then do a regular inventory transfer to move to the Main site.

Thanks,

Steve

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Hello Spena,

One final check to be done after deploying the HITB reset tool in order to ensure that everything has been deployed properly. After posting an inventory-related transaction, check either the HITB report or the SEE30303 table for this specific transaction, if it has been there, you are just fine. In certain cases, after the deployment, something goes wrong and prevents the HITB records from being recorded in SEE30303 table.

Please never hesitate to share any further inquiries,

Was this reply helpful? Yes No