Inventory Valuation Issues

[michelletencate]

Hi there

I am having issues with Accountright, particularly with inventory.  I get these errors when I close a period (refer Close Period Error).

I have random values of qty on hand but can't fix with Adjust Inventory as the qty is zero (refer Items on Hand).

I am trying to adjust an inventory item to zero and am getting an error about inventory cannot be less than zero (refer Adj Inv) however when I look at the Inventory, the amount I am adjusting out is correct (refer Inv Detail).

Please help thanks,

Michelle

[Steven_M]

Hi @michelletencate 

We do have a script (tool) that we can run over the company file that can help with those length numbers. So we can arrange for that to be run can you confirm the following information:

• Where the company file is stored i.e. online or local
• What the LAST FOUR DIGITS of the serial number is - Setup>>Company Information
• What is the company file ID - Help>>About AccountRight

While it's likely not related but do you have two items with the name "C/Bond 0.55X251"? According to the first screenshot you have the number 04000111 and in a later screenshot you have the same item name but with item number 04000098. Just trying to make sure I don't have to get my eyes tested.

[michelletencate]

Hi Steven

Thanks for this.  Hopefully it fixes all the issues.  Please

File is stored online.

Last four digits are 9171

File ID: 1

We have multiple items with the same description - they are actually the same profile of steel coil but different colours.  The colours are maintained under the Item Details "Description" as this is what is pulled when we process sales and purchases.

Regards

Michelle

[Steven_M · Accepted solution]

Hi @michelletencate 

Thanks for confirming that information.

That tool has been run over the company file for you. As such you should be good to go - although, would recommend closing the company file and reopening it before recording that inventory adjustment.

Do let us know how you get on and if you require further assistance.

Thanks for that clarification of your items, steel makes sense now.

[michelletencate]

Hi Steven

Thanks for this.

I have checked everything and processed the adjustment and no more warnings or issues

Cheers

Michelle