OFBiz › OFBiz - User

Year End Inventory Reconciliation

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

5 messages Options

wperng

Year End Inventory Reconciliation

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/

BJ Freeman

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=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/
>
>
>

wperng

RE: Year End Inventory Reconciliation

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/
>
>
>

-----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/

David E Jones-3

Re: Year End Inventory Reconciliation

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/
>
>

BJ Freeman

Re: Year End Inventory Reconciliation

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-----