FrontAccounting forum — Changing Inventory Adjustment Account

Re: Changing Inventory Adjustment Account

2019-09-10T20:14:08Z

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.

Re: Changing Inventory Adjustment Account

2019-09-10T19:22:22Z

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.

Re: Changing Inventory Adjustment Account

2019-09-10T19:16:53Z

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.

Re: Changing Inventory Adjustment Account

2019-09-10T18:35:23Z

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

Re: Changing Inventory Adjustment Account

2019-09-09T11:57:42Z

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?

Re: Changing Inventory Adjustment Account

2019-09-09T10:17:25Z

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

Re: Changing Inventory Adjustment Account

2019-09-09T05:54:29Z

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.

Changing Inventory Adjustment Account

2019-09-09T00:53:17Z

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.