Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

1.  Inventory Adjustment Transactions

Posted 05-18-2017 04:46 PM
We would like to change the GL accounts on our Inventory Adjustment transactions.  I have searched the Forum posts and almost find my answer on the setup.  The GL account might be setup in Inventory Offset.  I found that in Item Class Setup.  Is this the best place to make the change?  That make the change, then I need to go through my 50 Item Classes.  Is that correct?  or is there one place that will change the GL account for all Inventory Offsets?  Thanks for your help.

Bob Lash
General Manager
Ti-SALES, Inc.
Sudbury MA

2.  RE: Inventory Adjustment Transactions

Posted 05-19-2017 03:16 AM
The offset account on the class/item is indeed the default offset used in an adjustment, but, from GP 2015, a reason code was introduced that has an offset account linked to it and this will override the default from the item/class. It is actually a great change that we had to in the past write custom code to do.


David Joosten
Enterprise Architect
Premier (Pty) Ltd
Waterfall City

3.  RE: Inventory Adjustment Transactions

Posted 05-19-2017 09:39 AM
To clarify, we need to change the default GL account distribution for our inventory adjustment transactions.
Is there a way to accomplish this so it affects all inventory classes and items, which out having to do each one on its own?

Jeff Zammett
Ti-SALES, Inc.
Sudbury MA

4.  RE: Inventory Adjustment Transactions

Posted 05-19-2017 09:46 AM
Assuming you don't have any default accounts setup on your items (check Inventory > item >Accounts). Then you could just change the account that is setup in your posting accounts (GP > Tools > Setup > Posting > Posting Accounts). Do you have a lot of different item classes? You also simply change the account on the item class and it will allow you roll the change down to all of your items.

Matthew Arp
Business Systems Developer
Hunton Group
Houston TX

5.  RE: Inventory Adjustment Transactions

Posted 05-19-2017 04:03 PM
 If you only have a single account for your Inventory Adjustment offsets, then put it in the Posting Accounts setup window. You should never have the same account number on your Item's Accounts window as you do in the Posting Accounts Setup. The system is going to look to the item first (it never looks to the class), if there is no account at the item, it looks at the posting setup accounts. So, if you have one account, don't put it at the item number. If you have multiple accounts, then only fill out the inventory cards for the exceptions.
Kind regards,

Leslie Vail
Accounting Systems Consulting, Inc.
Dallas TX

6.  RE: Inventory Adjustment Transactions

Posted 05-19-2017 01:17 PM
If you are using GP2016 or GP2015 there are reason codes for the inventory adjustment transaction window.  GL accounts can be assigned to reason codes.

Also, if you want to make a mass change for all inventory items offset account you could do it in SQL

Select * from GL00105 where actnumst = 'your new GL account'
----  note the actindx number,

Then you can make an update in the IV00101 table for IVIVOFIX

update IV00101 set IVIVOFIX = 'actindx'

If you want to update the item class table do the same thing on IV40400

Mark Spain
Senior Dynamics GP Consultant
Huntsville AL