Inventory Balance

josros60

Well-known Member
Joined
Jun 27, 2010
Messages
521
I have a product inventory database same product provided from 2 or 3 suppliers, so i create in a product table a vendor product number and company product number, the idea is to bring one balance in a form or report for a product from 3 different vendor but being same product.

I cannot figure out how to do a query to calculate that.
for example:
These are the fields name:

Product VendorProductNumber CompanyProductnumber Supplier


thank you
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Oeldere

Well-known Member
Joined
Dec 29, 2011
Messages
2,213
I don't undertand what you trying to calculate.

Maybe with an example?
 

josros60

Well-known Member
Joined
Jun 27, 2010
Messages
521
ok,

for example i bought 5 boxes of shampoo 2 boxes from 1 supplier and 3 boxes from other supplier, when run the on hand report to see in stock of shampoo, how can get one balance instead showing 2 from one company and 3 from the other, what i want is to show balance in this case would be 5.

another word how can i create a record of same product from different suppliers.
when ship out it update balance of that product regardless of supplier.
thank you
 

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,793
Office Version
  1. 2019
Platform
  1. Windows
In general, your inventory should be maintained by "your" part number, regardless of where it is purchased from. So you would just query for the inventory of the part. It is only on the purchasing side that they need to worry about which vendor, which means that on the purchasing side they make use of a table of suppliers of the part.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,315
Members
414,053
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top