Automatic Production in POS Order

[Edwin Liauw]

Dear Community,

We are implementing POS for restaurants, and we are using Openbravo pda mobile+SmartPOS 2.0+RabbitMQ+SmartERP (IDempiere 1.0.c)

Each food/beverages menu has their own BOM. POS order sent to ERP and create automatic transaction for sales order,shipment,invoice and payment. It works well.

We are facing an issue about automatic production. Lack of our technical skill, for now, we can only use single production feature to produce them after sales transaction. Until the production, there are negative inventories for the sold items.

This simple solution may not enough. For a restaurant that has many food/beverages, say more than 100 items, it must be difficult to produce one by one, daily. In our client perspective, POS order should create an automatic production before shipment.

Any suggestion for technical or work around solution?

Thank you very much.

[Michal Zilincar]

Hi Edwin,

Just my 2 cents, but what about not using production.
Teory :
If you define "meal/cocktail"  as non stocked item with BOM. Then material used will be shipped and no need for production.

Reality :
I tried it on test.idempiere.com but failed . Fastly checking explodeBOM() in MOrder.java showing some issue. As it  uses boms from libero extension, and not one used in iDempiere(default) .

[redhuan d. oon]

I hope to complete the Multi BOM Drop Configurator in Libero soon. Will report that in the related thread.
About POS issuing Production Orders, yes the non stock idea is good workaround or even Replenishment process. But in case a POS really integrates to Manufacturing, then its better to just pass it to the Sales Order level as POS is just a Sales Order. In the case of OB POS/SmartPOS they should integrate into the Sales Orders and then you can run the Libero Material Calculation Plan or MakeToOrder to issue Production Orders.

[Edwin Liauw]

@Michal: We have tested with a non stocked item and doesn't create negative inventory, well its a good point. But the process didn't reduce the materials (BOM) automatically, as purchasing department need to be informed about current stock level for materials.

@Redhuan: Yes, for temporary solution, user manually run Replenish Report incl. Production. It works fine and create production.

We tried to set it on Scheduler so it will automatically create production every 10 minutes, but failed (MScheduler[1000000-Replenish Report incl. Production] - Fill mandatory fields:  Document Type Logs deleted=0). How can we make it automatically ?

[armenrz]

Hi Edwin,

Looks like it requires Document Type to be supplied in Scheduler's parameter, set its default parameter value.

Armen

[Michal Zilincar]

Hi Edwin,

yes there is a bug , to make it work you have to apply patch I have submitted here https://idempiere.atlassian.net/browse/IDEMPIERE-2575

[Edwin Liauw]

yes i think so... it need a parameter but, when we start the Replenish report (incl.Production), we can just run it without fill Document Type parameter. because there is no document type for production 

[Edwin Liauw]

Hi Michal,

thanks for your quick response and your patch. I have applied your patch, now it doesn't give me any previous error log but still it cannot execute "Replenish report (Incl.Production)" automatically.

perhaps I missing something ? 

[Edwin Liauw]

Hi Michal,

Sorry I misunderstood your explanation.

So, I see there are two alternative solutions.

1. Using Scheduler, I try to make an automatic production using Replenish report (Incl.Production) process every 10 minutes.

But I found these error message: (MScheduler[1000000-Replenish Report incl. Production] - Fill mandatory fields:  Document Type Logs deleted=0.

I still cannot find how to configure this since single production in Idempiere 1.0.C doesn't have document type.

2. Using non stocked items as you suggested, I've applied the patch that given by you. but, still it cannot reduce BOM.

any other suggest ?

On Friday, April 10, 2015 at 6:39:10 PM UTC+7, Michal Zilincar wrote:

[Michal Zilincar]

Hi Edwin,

conditions are that product has :   IsBOM='Y'  , IsVerified='Y'  , IsStocked='N'

It worked than for me.  I see Carlos already solved it in branch 2.1.
I would test it on demo.idempiere.com but I am not sure when it is build and what branch  is used.

[Edwin Liauw]

Hi Michal,

it's been long time that i have not tested this issue again. now i have upgraded idempiere to 2.1.

- i already apply the patch and run idempiere-server

- the conditions that i made,is just same like you did :  IsBOM='Y'  , IsVerified='Y'  , IsStocked='N'

then i made a Sales Order, completed. as result it create 2 Order Line; 1 with zero price and only fill description field, 1 with product field filled and qty is multiply with BOM qty.

after complete the document, result are different than i thought.  i was think it will follow the price that are defined in Product parent, and BOM qty is used for reduce stock. this make my Sales Order have price doubled because the price are multiply with bom qty.

do i have something procedure that i missed ? 

other tested, i tried in test.idempiere.org (using idempiere ver.3 ) you can see at my sales Order doc number = 80007 

i made same conditions, after complete the document, result are different than i made in my local (idempiere 2.1). this one, it is only take and accumulate the BOM price.

Please help me to figure it out and solve it

thanks

[Jose Orlando]

Hi Edwin

i use idempiere 3.1 and have the same problem, in a restaurant implementation

Finally, how did you solve the problem?

Thanks

José Orlando