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 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=InventoryItemVariance 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/ > > > Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJSreerP3NbaWWqE4RAtcuAJ9AGbSDn/8SATWN55NTMAUOacrtlQCeM7MA FvfJ0ut1CHxb2uuefqrJREI= =whcy -----END PGP SIGNATURE----- |
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:[hidden email]] Sent: Thursday, December 18, 2008 3:51 PM To: [hidden email] 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/ > > > 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/ |
In reply to this post by wperng
If you don't care about your inventory history then it's fine. The reason a new InventoryItem is created each time inventory is received, even for non-serialized inventory, is to keep a history of stock movement, cost, freshness, etc. -David On Dec 18, 2008, at 12:59 PM, William Perng wrote: > 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/ > > |
In reply to this post by wperng
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1 there may be a problem with inventory levels and should be looked into. I will check to see why my clients don't run into this. I also provide my clients a xls worksheet to import. have you looked at the https://demo.hotwaxmedia.com/hhfacility/control/main I just noticed it throws and error that I will mention in another post. it purpose was to use handhelds. William Perng sent the following on 12/18/2008 1:13 PM: > 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:[hidden email]] > Sent: Thursday, December 18, 2008 3:51 PM > To: [hidden email] > Subject: Re: Year End Inventory Reconciliation > > 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/ > > > 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/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJSsMfrP3NbaWWqE4RAiWgAJ0droevLOQ23UmxEWwqL1Y0ohFnugCgvInB sIKxP0PhXDIo71XV5hW0/us= =wbRp -----END PGP SIGNATURE----- |
Free forum by Nabble | Edit this page |