Author Topic: How can i tag salable Products with particular warehouse?  (Read 13857 times)

TawhidAnik

  • Newbie
  • *
  • Posts: 23
How can i tag salable Products with particular warehouse?
« on: May 09, 2013, 09:02:26 am »
Scenario is :
In my restaurant there are two types of salable products which are tagged to different warehouse. I have got a bar and dine-in.
Liquors are issued from bar and dine in products are issued from kitchen.
But Order is captured from single terminal. So i make recipe of all products using inventory items.Now my requirement is, when an order is issued or settled,
i want inventory/stock effect from corresponding warehouse.
lets give an example
liquor 1 is issued from bar and kitchenitem1 is issued from kitchen

liquor1 recipe
===========
item                                  Qty
=========================================================

inventoryitem1                        .5{bar inventory}
inventoryitem2                        .9{bar inventory}

kitchenitem1 recipe
===========
item                                  Qty
=========================================================

inventoryitem3                        .2{kitchen inventory}
inventoryitem4                        .5{kitchen inventory}

Order1                                 Qty
=========================================================
liquor1               4      
kitchenitem1            9                  


my requirement is, i want inventory effect corresponding to warehouse after issuing Order1.

Bar Inventory                          Stock/Inventory Impact
==============================================================
inventoryitem1                        -4X.5{bar inventory}
inventoryitem2                        -4X.9{bar inventory}

kitchen Inventory             Stock/Inventory Impact
==============================================================
inventoryitem3                        -9X.2{kitchen inventory}
inventoryitem4                        -9X.5{kitchen inventory}

Hope my requirement is clear.Is it possible in SambaPOS.
please let me know whether it is possible or not? If yes then how?

thanx in advance

Tawhid Anik
« Last Edit: May 09, 2013, 09:05:09 am by TawhidAnik »

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: How can i tag salable Products with particular warehouse?
« Reply #1 on: May 09, 2013, 01:20:57 pm »
What I've noticed is inventory 1&2 decreases bar inventory and 3&4 decreases kitchen inventory. If they always consumed from a single inventory why do you need that separation? It might be useful if inventroy items consumed from multiple warehouses and if it is your case it is possible with V3 version. V2 assumes you have a single inventory and it works fine for most cases.

TawhidAnik

  • Newbie
  • *
  • Posts: 23
Re: How can i tag salable Products with particular warehouse?
« Reply #2 on: May 09, 2013, 02:13:19 pm »
Emre, thanx for your quick reply, they are sold from one counter/outlet but is stored in different Inventory.liquors stored in bar and kitchen inventory is different. In the morning bar receives stock from main warehouse and kitchen receives its stock as well. In my system there are three warehouse. Main warehouse, bar, kitchen. Order is captured centrally. But salable products come from Bar and Kitchen. Is there any way to stock transfer from one inventory to other. In Samba POS i defined transaction type and tried the process but STOCK IN column does not populate instead Purchase column is populated. hope i have described what i need. Special thanx again for your cooperation Emre :-)

TawhidAnik

  • Newbie
  • *
  • Posts: 23
Re: How can i tag salable Products with particular warehouse?
« Reply #3 on: May 09, 2013, 02:14:48 pm »
If it is possible in V3 please let me know the process. Eagerly waiting for your reply :-)

Regards

Tawhid Anik

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: How can i tag salable Products with particular warehouse?
« Reply #4 on: May 10, 2013, 04:48:57 am »
Hello Tawhid. I'm trying to understand why you need different warehouses for kitchen and bar. You may have two warehouses for "Main Warehouse" and "Restaurant Warehouse". You'll sell from "Restaurant Warehouse" and move new items from "Main Warehouse" when liquior or meat decreases. I don't get the idea behind two different warehouses for kitchen and bar since items always decreases inventory from a specific warehouse.

We thought if there are two different warehouses you'll have two different terminals for sale. For example Bar1, Bar2 and track their individual inventories. We do not support decreasing from multiple warehouses from a single terminal. To be able to do this we have to assign warehouses to menu items and we don't have this feature yet. If I can understand the need I can decide if we'll need this feature or not. I'll be happy if more people share their ideas.

TawhidAnik

  • Newbie
  • *
  • Posts: 23
Re: How can i tag salable Products with particular warehouse?
« Reply #5 on: May 10, 2013, 11:08:09 am »
#1.
Thanx Emre, Your point is absolutely right. But in my restaurant authorized people receive inventory/stock from main ware house. So transaction type and warehouse needs to be maintained differently.But however i can maintain it as per your suggestion,  "Main Warehouse" and "Restaurant-Bar Warehouse".

#2.
My another question was:
 Is there any way to transfer stock from one inventory to other. In Samba POS i defined transaction type and tried the process but STOCK IN column does not populate instead Purchase column is populated.

Thanx in advance for your cooperation so far.

#3.
P.S: i have submitted a query in V3 Development Forum. http://forum2.sambapos.org/index.php?topic=1426.msg6596#new

Is there any possibility to get answer of that query from any of the developers?

Hope to get answers of all the queries.

Thanx again

Tawhid Anik

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: How can i tag salable Products with particular warehouse?
« Reply #6 on: May 10, 2013, 04:27:59 pm »
There might be a naming issue there. You'll see purchased & transferred totals under "Purchase" column. "In Stock" column displays the beginning inventory on workperiod start. Maybe it will be better for you if we display purchase and transfer totals under different columns.

Basically you'll have two different transactions types for "Transfer" and "Purchase". You'll select transaction type and choose warehouses on transaction document. But this transaction document is not in final state. We'll implement easier data entry screens on "Warehouse" module. You'll see buttons for each transaction types and when clicked we'll generate a transaction entry screen like we did on Account Module.

TawhidAnik

  • Newbie
  • *
  • Posts: 23
Re: How can i tag salable Products with particular warehouse?
« Reply #7 on: May 21, 2013, 01:44:25 am »
thanx emre for ur cooperation,
It seems that Samba POS has accommodated with my requirement. But You mentioned that STOCK IN column shows  any stock at Work start. But when I end work period all the inventory is initialized with 0 quantity. How can i  get day end stock value on next day?

As an example

20 may 2013 inventory Local Stock, Before Work Period End
===================================

Product      Stock In      Purchase
======================================
x1             5            7
x2             6            73
x3             7            75
x4             8            76
x5             9            5

After executing Work Period End Process Warehouse is like

21 may 2013 inventory Local Stock
===================================

Product      Stock In      Purchase
======================================
x1             0            0
x2             0            0
x3             0            0
x4             0            0
x5             0            0

Necessity is Users want Day End Stock in the morning on the terminal and which is quite a necessity. Hope i've described the problem i'm facing


regards

Tawhid Anik