If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Inventory - Purhase Order product dilema.
Hi,
I have an inventory application with purchase order, I need help in the following: 1. just want to know if it's possible when i do a new purchase order, when I select the supplier, to show only products sell by that supplier in the purchase order details? 2. the product on hands work well but i have one question, i how can i keep one on hand balance of one product supplied by several suppliers (in other words i can buy the same product from different supplier, but to keep only one running balance of the product. thank you very much for your help. |
#2
|
|||
|
|||
Inventory - Purhase Order product dilema.
josros60,
Not sure what you mean by #2. Let me handle your first question... On my website (below), I have a 97 and 2003 sample file that demonstrates setting up the combo to select your particular CompanyID. The file is called Combo Populates Multiple Fields. (just refer to the combo selection part) Create a combobox on the main form. Populate it with 2 columns... UniqueKey Field CompanyID CompanyName 152 Smith & Co. Setup the combo... Control Source = CompanyID No of Columns = 2 ColumnWidths = 0"; 2" Bound Column = 1 List Width = 2" OK... this will allow you to select a ComapnyID, by selecting a CompanyName from the Combo. Your PODetails (subform I would guess) can now use that combo value to filter it's PartNos to only those realted to the CompanyID. The criteria... = Forms!frmMainForm!cboYourComboName -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "josros60" u56159@uwe wrote in message news:9f0692c9dac1f@uwe... Hi, I have an inventory application with purchase order, I need help in the following: 1. just want to know if it's possible when i do a new purchase order, when I select the supplier, to show only products sell by that supplier in the purchase order details? 2. the product on hands work well but i have one question, i how can i keep one on hand balance of one product supplied by several suppliers (in other words i can buy the same product from different supplier, but to keep only one running balance of the product. thank you very much for your help. |
#3
|
|||
|
|||
Inventory - Purhase Order product dilema.
Al Campagna wrote:
josros60, Not sure what you mean by #2. Let me handle your first question... On my website (below), I have a 97 and 2003 sample file that demonstrates setting up the combo to select your particular CompanyID. The file is called Combo Populates Multiple Fields. (just refer to the combo selection part) Create a combobox on the main form. Populate it with 2 columns... UniqueKey Field CompanyID CompanyName 152 Smith & Co. Setup the combo... Control Source = CompanyID No of Columns = 2 ColumnWidths = 0"; 2" Bound Column = 1 List Width = 2" OK... this will allow you to select a ComapnyID, by selecting a CompanyName from the Combo. Your PODetails (subform I would guess) can now use that combo value to filter it's PartNos to only those realted to the CompanyID. The criteria... = Forms!frmMainForm!cboYourComboName Hi, [quoted text clipped - 14 lines] thank you very much for your help. Hi Al Campagna, Thank you very much for your quick response to my question. by #2 i meant question number 2, here it's again, What I am trying to say, i have products table/supplier, so the some of my products are provided by two or more suppliers, so my question is, base on above, how can i keep qty on hand of the same product bought from different supplier, for example, my is a hotel, we buy shampoo in a month let's say 4 or 5 boxes from 2 different suppliers when i record the transaction receiving how can access know is the same product to show qty on hand being bought from 2 different supplier. thank you |
#4
|
|||
|
|||
Inventory - Purhase Order product dilema.
Try to create a query based on the item and group the item in one column and
count it in the other. This will give you the quantity on hand regardless of the supplier. "josros60" u56159@uwe wrote in message news:9f07f8fd4a571@uwe... Al Campagna wrote: josros60, Not sure what you mean by #2. Let me handle your first question... On my website (below), I have a 97 and 2003 sample file that demonstrates setting up the combo to select your particular CompanyID. The file is called Combo Populates Multiple Fields. (just refer to the combo selection part) Create a combobox on the main form. Populate it with 2 columns... UniqueKey Field CompanyID CompanyName 152 Smith & Co. Setup the combo... Control Source = CompanyID No of Columns = 2 ColumnWidths = 0"; 2" Bound Column = 1 List Width = 2" OK... this will allow you to select a ComapnyID, by selecting a CompanyName from the Combo. Your PODetails (subform I would guess) can now use that combo value to filter it's PartNos to only those realted to the CompanyID. The criteria... = Forms!frmMainForm!cboYourComboName Hi, [quoted text clipped - 14 lines] thank you very much for your help. Hi Al Campagna, Thank you very much for your quick response to my question. by #2 i meant question number 2, here it's again, What I am trying to say, i have products table/supplier, so the some of my products are provided by two or more suppliers, so my question is, base on above, how can i keep qty on hand of the same product bought from different supplier, for example, my is a hotel, we buy shampoo in a month let's say 4 or 5 boxes from 2 different suppliers when i record the transaction receiving how can access know is the same product to show qty on hand being bought from 2 different supplier. thank you |
#5
|
|||
|
|||
Inventory - Purhase Order product dilema.
Hi Rockn,
thank you, But i don't get what you meant, when i enter the in and out (purchase in and use out) is in a form product inventory and there's a field that calculate the on hand accordingly. the formula that i have in the form is: =Sum(nz([UnitsReceived])-nz( [UnitsShrinkage])-nz([UnitsSold])) how can i run a query? thank you again Rockn wrote: Try to create a query based on the item and group the item in one column and count it in the other. This will give you the quantity on hand regardless of the supplier. josros60, Not sure what you mean by #2. Let me handle your first question... [quoted text clipped - 49 lines] thank you -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 |
Thread Tools | |
Display Modes | |
|
|