You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ofbiz.apache.org by sarappa <sa...@yahoo.com> on 2013/05/07 21:18:24 UTC

POS inventory selection

Hi
I have question regarding how to assign inventory item when sales happens
from POS terminal, for our scenario, I need to keep track of which inventory
item it picked as we have expiry date for a product, and lets say there are
two batch, then applicable inventory item needs to be updated, else we have
problem with expiry date for the batch, how to handle this scenario in POS
and/or via order entry.

Looked at similar post, as far as I see, its not available OOTB, please let
me if its already implemented or any idea how this can be done.

Thanks 
Saravanan



--
View this message in context: http://ofbiz.135035.n4.nabble.com/POS-inventory-selection-tp4641061.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.

Re: POS inventory selection

Posted by sarappa <sa...@yahoo.com>.

Hi
Thanks for the information, I will look at the strategy more in detail

Sarappa



--
View this message in context: http://ofbiz.135035.n4.nabble.com/POS-inventory-selection-tp4641061p4641107.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.

Re: POS inventory selection

Posted by Jacques Le Roux <ja...@les7arts.com>.

Also remember that, by default, the POS does not check/require an inventory (though it reserves) and is immediately fulfilled (the idea is you can't sell something you don't have available), but I guess you are ahead of that already

See catalog/control/EditProductStore?productStoreId=9100 for more...

Jacques

From: "Paul Foxworthy" <pa...@cohsoft.com.au>
> Hi Sarappa,
> 
> It *is* supported.
> 
> OFBiz offers several different strategies for allocating inventory to
> orders. Look at the Edit Product Store screen within the Catalog Manager. On
> the demo site, it's at
> 
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductStore?productStoreId=9000
> 
> The Reserve Order Enum Id field has values to allocate inventory based on: 
> 
> FIFO Expire - earliest expiry date
> FIFO Received - earliest received date
> Greater Unit Cost - most expensive cost price first, i.e. reduce inventory
> asset value as quickly as possible
> LIFO Expire - latest expiry date, i.e. "freshest" based on defined expiry
> date
> LIFO Received - latest received, i.e. "freshest" based on received date
> Less Unit Cost - least expensive cost price first, i.e. conserve inventory
> asset value, sell cheapest to acquire first, increase margin for this unit
> 
> For your strategy I think you want a reserveOrderEnumId of INVRO_FIFO_EXP.
> Grep for that in the OFBiz code. One place it's used is 
> 
> https://fisheye6.atlassian.com/browse/ofbiz/trunk/applications/product/script/org/ofbiz/product/inventory/InventoryReserveServices.xml?hb=true#to58
> 
> Hope that helps
> 
> Paul Foxworthy
> 
> 
> sarappa wrote
>> Hi
>> I have question regarding how to assign inventory item when sales happens
>> from POS terminal, for our scenario, I need to keep track of which
>> inventory item it picked as we have expiry date for a product, and lets
>> say there are two batch, then applicable inventory item needs to be
>> updated, else we have problem with expiry date for the batch, how to
>> handle this scenario in POS and/or via order entry.
>> 
>> Looked at similar post, as far as I see, its not available OOTB, please
>> let me if its already implemented or any idea how this can be done.
>> 
>> Thanks 
>> Saravanan
> 
> 
> 
> 
> 
> -----
> --
> Coherent Software Australia Pty Ltd
> http://www.coherentsoftware.com.au/
> 
> Bonsai ERP, the all-inclusive ERP system
> http://www.bonsaierp.com.au/
> 
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/POS-inventory-selection-tp4641061p4641085.html
> Sent from the OFBiz - Dev mailing list archive at Nabble.com.

Re: POS inventory selection

Posted by Paul Foxworthy <pa...@cohsoft.com.au>.

Hi Sarappa,

It *is* supported.

OFBiz offers several different strategies for allocating inventory to
orders. Look at the Edit Product Store screen within the Catalog Manager. On
the demo site, it's at

https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductStore?productStoreId=9000

The Reserve Order Enum Id field has values to allocate inventory based on: 

FIFO Expire - earliest expiry date
FIFO Received - earliest received date
Greater Unit Cost - most expensive cost price first, i.e. reduce inventory
asset value as quickly as possible
LIFO Expire - latest expiry date, i.e. "freshest" based on defined expiry
date
LIFO Received - latest received, i.e. "freshest" based on received date
Less Unit Cost - least expensive cost price first, i.e. conserve inventory
asset value, sell cheapest to acquire first, increase margin for this unit

For your strategy I think you want a reserveOrderEnumId of INVRO_FIFO_EXP.
Grep for that in the OFBiz code. One place it's used is 

https://fisheye6.atlassian.com/browse/ofbiz/trunk/applications/product/script/org/ofbiz/product/inventory/InventoryReserveServices.xml?hb=true#to58

Hope that helps

Paul Foxworthy


sarappa wrote
> Hi
> I have question regarding how to assign inventory item when sales happens
> from POS terminal, for our scenario, I need to keep track of which
> inventory item it picked as we have expiry date for a product, and lets
> say there are two batch, then applicable inventory item needs to be
> updated, else we have problem with expiry date for the batch, how to
> handle this scenario in POS and/or via order entry.
> 
> Looked at similar post, as far as I see, its not available OOTB, please
> let me if its already implemented or any idea how this can be done.
> 
> Thanks 
> Saravanan





-----
--
Coherent Software Australia Pty Ltd
http://www.coherentsoftware.com.au/

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/

--
View this message in context: http://ofbiz.135035.n4.nabble.com/POS-inventory-selection-tp4641061p4641085.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.