POS inventory selection

[sarappa]

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

[Paul Foxworthy]

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

[Jacques Le Roux]

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" <[hidden email]>

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

[sarappa]

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

Sarappa