Quantity on Hand

[Kivairu]

Iam running Accpac 5.4 with all the latest service packs.
Our financial year ends in June.We had items that were in the wrong Account set so come end of June we corrected the account sets as we took the stock balances.
The problem is that all the items which we changed the account sets are all reading -ve Quantity on Hand in the Item Valuation Report yet if you check the Location details they are correct.This is hindering our Shipments since the system is giving a message cannot Issue Negative Inventory.


Any help here will be so greatly appreciated.Am in a fix on how to correct this.

 

[ettienne]

Print the item valuation report using Location Detail Costs.

 

[Kivairu]

When I print that report the quantity is ok. but the costs are displayed as -ve.But When I try to ship The quantity available is -ve .The crazy part of it is that in the table ICILOC the quantity on hand is displaying as -ve.

 

[ettienne]

Changing the IC account set will not affect the quantity.
Did you do a physical inventory and enter your counted quantities?

 

[Kivairu]

Yes I did and the physical Inventory reconciliation report is having correct physical count.

 

[Jay Converse]

How did you make your changes? With export/import, or editing the tables directly?

 

[Kivairu]

Imported the physical counts into the Physical Inventory Quantities.Then where there were anomalies we edited from the system directly.

 

[Jay Converse]

Just like I thought. When you edited directly, you screwed up, because the problem you're describing doesn't happen when you follow the rules. Since I'm sure it's too late to restore from backup, you need to call in a professional, or send your data out for repair.

 

[Kivairu]

Ok am not sure where I screwed up because,when I say I edited from the system we edited from physical Inventory counts.We didn't touch the database tables.I thought that was in order.

 

[DjangMan]

Importing into the physical inventory worksheet can be dangerous. The worksheet holds a value that represents the quantity on hand at the time the worksheet was generated. The difference between that value and the value that you enter is what becomes your adjustment. If you inadvertently adjust that field value then posting your count can mess up your inventory values.

Ideally you do the following:
Day End
Generate Count Worksheet
Count Inventory
Fill in and post worksheet
Day End

 

[Kivairu]

I'll give it a try at close of work today since I cannot stop the system at this point.Thanks Hope it works.