Dynamics GP - Stock Count Distributions

The distribution accounts for stock count come directly from the IV00101 table.

IVIVINDX - Inventory Account
IVVARIDX - Variance Account


Example of how to find the correct account and update all item distributions with the correct account index

select * from iv00101

select * from gl00105 where ACTNUMST = '1-00-00-1-00-6170'

select * from iv00101 where IVVARIDX > 0

update IV00101 set IVVARIDX = 10