• paul
  • Senior Member
  • Offline
  • From: USA, Columbia
  • Registered: 07/22/2019
  • Posts: 106

Topic: Changing Inventory Adjustment Account

I just added a new GL account for Inventory Adjustments. I then went into Setup -> System and General GL Setup and changed Items Defaults, Inventory Adjustments Account to my new account. I logout, login again and go to Items and Inventory, Item Adjustments Note and make a change. But the change is still recorded to the default account: Purchase price Variance.

  Why did my change not affect an inventory adjustment reporting?

Thanks.

2 Reply by rafat (edited by rafat 09/09/2019 10:27:54 am)

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: Changing Inventory Adjustment Account

You also need to change the Item Adjustment Account in Maintenance-> Items.

One thing I noticed that seems to me as a bug is the changes in Item Defaults in System and General GL setup are not reflected in
Items and Inventory->Maintenance -> Items... as defaults.

Unless there is an explanation for this behavior.

rafat's Website

  • paul
  • Senior Member
  • Offline
  • From: USA, Columbia
  • Registered: 07/22/2019
  • Posts: 106

Re: Changing Inventory Adjustment Account

Ahh, thanks. I see Item Categories also holds this info, too. Thank you.

  • paul
  • Senior Member
  • Offline
  • From: USA, Columbia
  • Registered: 07/22/2019
  • Posts: 106

Re: Changing Inventory Adjustment Account

It also appears that when changing an items Item Adjustment Account in Maintenance-> Items, that only stock_master table is updated with the account number and not any other table. Is this observation accurate?

  • From: USA
  • Registered: 03/05/2018
  • Posts: 123

Re: Changing Inventory Adjustment Account

That is correct. Were you expecting it to update previous transactions?

oakstreet1's Website

  • paul
  • Senior Member
  • Offline
  • From: USA, Columbia
  • Registered: 07/22/2019
  • Posts: 106

Re: Changing Inventory Adjustment Account

Thanks for the confirmation. No - I'm only testing, but I wanted to make sure of the changes made in the database. It was easier for me to change all the item's adjustment_account column value via phpmyadmin instead of pulling up each item in FA and making the changes. At first I wasn't sure if another table was involved with relative info.

  • From: USA
  • Registered: 03/05/2018
  • Posts: 123

Re: Changing Inventory Adjustment Account

The way I check to be sure on those things is I make a database backup, change something, make another backup, and diff the two backups to be sure there is nothing I missed.

In this case, you're not generating transactions that have all sorts of side effects, like stock-moves, GL entries, etc.

oakstreet1's Website

  • paul
  • Senior Member
  • Offline
  • From: USA, Columbia
  • Registered: 07/22/2019
  • Posts: 106

Re: Changing Inventory Adjustment Account

Great idea. I'll have to keep that tip in mind. The way I attempted to check was to turn on FA's logging to screen and looked for the update lines - I thought I may have missed one or more the way I did it.