Yes, I tried the "Physical Inventory" tool. Based on my test, if I put a big negative number in one of the inventory item entries in "Physical Inventory" tool for GZ-1000, user can still place order for GZ-1000 without back order problem. Because the new order will use different inventory item from the one I just set, I thought I need go through each order inventory item for GZ-1000 to change it. Unless the big negative number I input triggers a balance inventory process, this is a problem for us, since we may have hundred of inventory items need to be manually adjusted.
Thanks William -----Original Message----- From: BJ Freeman [mailto:[email protected]] Sent: Thursday, December 18, 2008 3:51 PM To: [email protected] Subject: Re: Year End Inventory Reconciliation -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 william ofbiz has the ability to adjust inventory. you can note by type of adjustment that would facilitate reconcilation. plus you have an audit trail. https://demo.hotwaxmedia.com/facility/control/FindFacilityPhysicalInventory? facilityId=WebStoreWarehouse notice the Variance Reason Id https://demo.hotwaxmedia.com/webtools/control/ViewRelations?entityName=Inven toryItemVariance William Perng sent the following on 12/18/2008 11:59 AM: > Hi, > > > > We are looking for a way to do year end inventory reconciliation in ofbiz? > Since we have many entries for each product in the inventory item table, it > is difficult for us to adjust the inventory item line by line. We are > thinking to create a procedure to zero out all inventory items then create a > new inventory item for each product. > > > > If this is not the right way to do it, please correct me. > > > > > > Thanks > > > > William > > No virus found in this outgoing message > Checked by PC Tools AntiVirus (5.0.0.22 - 10.100.070). > http://www.pctools.com/free-antivirus/ > > > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJSreerP3NbaWWqE4RAtcuAJ9AGbSDn/8SATWN55NTMAUOacrtlQCeM7MA FvfJ0ut1CHxb2uuefqrJREI= =whcy -----END PGP SIGNATURE----- No virus found in this incoming message Checked by PC Tools AntiVirus (5.0.0.22 - 10.100.070). http://www.pctools.com/free-antivirus/ No virus found in this outgoing message Checked by PC Tools AntiVirus (5.0.0.22 - 10.100.070). http://www.pctools.com/free-antivirus/
