HITB for GP 2018- Inventory

(0) Share

Report

Posted on by Cscott72

In MAY I performed an inventory reconciliation-- there were several changes resulted in adj transactions to be made. The reconciliation added quantity and we removed it using and INVADJ transaction.

Unfortunately, since that time, we are unable to get an accurate Historical TB for inventory. It shows negative quantities that are not applicable. How can we identify and correct these transcations:

When we try to clear the item we get the error below:

the Help so far is to "remove the records from the SQL tables, but that seems pretty rash.

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Becky Berginski on at

Like (0)

Report

RE: HITB for GP 2018- Inventory

If your HITB is incorrect and no longer matches the GL, you can update quantities in the SEE30303 table to get the two values to match again. If you GL and HITB match currently, I would not make any changes to the debits or credit amounts in the SEE30303. Only update the quantities. If you need help determining what needs to be done to get them to match again, I would suggest opening a case with the support desk.