HITB Reset Tool - Data Validation - Account does not exist

CAUSE
The item may have quantities in one of the quantity type columns, and has no associated account with that quantity type.

select QTYTYPE, * from SEE99998 where qtytype <> 1

Review the Quantity Type field to see which "bucket" this item has receipt layers in. Here are the possibilities:
1 – On Hand
2 – Returned
3 – In Use
4 – In Service
5 – Damaged

Each of these quantity types maps to a different account type that would need to be populated.
1 – On Hand -- Inventory
2 – Returned -- Inventory Returns
3 – In Use -- In Use
4 – In Service -- In Service
5 – Damaged -- Damaged

Verify that you have accounts entered for the quantity types that exist for this item(and the others as needed) to resolve this warning message.


RESOLUTION
To Resolve this, set default posting accounts for the different quantity types in your posting setup, or on each item.

On the item card for each item, set a value for the account required for "Inventory Returns"

--This script can be used to update items with an account number
update iv00101 set IVRETIDX = x where ITEMNMBR = 'y'

--Where x is your account index, and y is your item number.

Scripts
--Copy Inventory Account to Return Account for item classes
select * from iv40400 where ivretidx = 0

update iv40400 set ivretidx = ivivindx where ivretidx = 0