Physical Inventory Not Posting

After uploading all count sheets and then trying to Post the Physical Inventory Count you get an error similar to this.

Check all Product Code accounts have been populated, the likely accounts that will need populating will be cycle_adj_acct and inv_adj_acct

Run the following query on the site db the stock take is taking place eg. BEL, EPI

select * from prodcode_mst

where inv_adj_acct is null

or cycle_adj_acct is null

This should then display any product codes that do not have these acct assigned. Finance will be able to advise which account should be assigned to these fields