Inventory - Purhase Order product dilema.

[josros60]

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.

 

[Al Campagna]

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]

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

 

[Rockn]

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

 

[josros60 via AccessMonster.com]

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

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.
[quoted text clipped - 49 lines]

thank you