hel me please how to doit ??? MS acces POS system Packed Item

[eki einstein]

help me please how to doit ??? MS acces POS system Packed Item

I asked help and suggestions to doing this from you all
how to make things like this in ms acces

I have a table like this stuff, I gave him the name of the table "item master":
----------------------------------
ID | Product Name | Price | stock |
------------------------------------
01 | Item1 | 100 | 5 |
02 | item2 | 200 | 5 |
03 | item3 | 100 | 5 |
04 | item4 | 200 | 5 |
05 | gold package | 275 | |
-----------------------------------


I want to put item2, item3 into one package, in this case as an example I call it "Gold package"
and when the casshier done do sales on the "gold package", the amount of stock item2 and item3 will be reduced
I want to create a sales system using a mixture of goods and items package unit

example in sales
-------------------------------------------
code | item name | price | Qty | Total |
-------------------------------------------
*01 | item 1 | 100 | 2 | 200 |
04 | item 4 | 200 | 1 | 200 |
05 | gold package | 275 | 1 | 275 |
--------------------------------------------
total sales 675
--------------------------------------------

after the transaction is done then the stock will look like:

----------------------------------
ID | Product Name | Price | stock |
----------------------------------
01 | Item1 | 100 | 3 |
02 | item2 | 200 | 4 |
03 | item3 | 100 | 4 |
04 | item4 | 200 | 4 |
05 | gold package | 275 | |
-----------------------------------


at this point, I use VBA and the combobox in associate with the data in the table: the master item, and use the after_update event to get the value for "item name" and "price"

example
-------------------------------------------
private sub ID_after_update()
me.name_goods = id.column (2)
me.price = id.column (3)

end sub
--------------------------------------------
I can reduce the stock if the sale is done using a unit item, the question is, how best do it to reduce the stock if the sales package system as above

please help

thank you
"sorry if i had bad english.. thanks for google translate help to wrote this in this thread

 

[Uncle Gizmo]

Re: help me please how to doit ??? MS acces POS system Packed Item

how best do it to reduce the stock if the sales package system as above

You should start by reading this:-
"How do I update the Quantity On Hand each time an item is sold/used?" The simple answer is: You don't! You calculate the value when you need it.

 

[eki einstein]

Uncle Gizmo Thanks for the links and your fast response ,but i think what allen brown do is calculated the stok per item(stand alone product), not for calculated the stok by mixture per item(stand alone product)and per packaged(multiple product in one) item.

 

[Uncle Gizmo]

If I understand correctly you are saying that Allen Browne's system will not work because some of your products are made from a combination of the other products?

You may well be right i haven't thought it through in any great detail.

However I still believe it would be worth considering Allen Browne's approach because it solves a lot of problems that I'm sure you will encounter.

Could you, instead of listing a new product which is a combination of existing products, just add the individual products that make the combination product as line items in your invoice?

 

[eki einstein]

yes exactly that what I mean, some of my product are made by combination of other product .... in older day I make some simple POS application,and add individual product thats make combination product in Invoice are what i do, and i just wondering its will be great if i could make a product combination and name it, and put the name in invoices as one price, its will be preetier for my customer, but when i start to doing this i realizes its will be dificult to make knowing my on hand stock, so i decide ask others opinion a bout how the best approach to make this things happen