Inventory Balance

josros60

Well-known Member
Joined
Jun 27, 2010
Messages
777
Office Version
  1. 365
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
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,211,772
Messages
6,103,877
Members
447,882
Latest member
LORENA

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
Back
Top