Anuviel Posted June 28, 2007 Posted June 28, 2007 I apologize for the brick of a question but here it is. If it is not clear enough please let me know and I will try to clarify. Thank you., What would be the best way to set up same inventory item that can be purchased from different vendors? If I have item X and that item is carried by vendor A and vendor B, the difference being that vendor A charges $1.00 and vendor B charges $1.25. I have attached a gif of my relationships. When creating an invoice, I have a portal in which I type item code in and it creates a new record in line items and pulls all of the item information related to that item such as cost and vendor code. I know how to make it so that instead of typing in a code I get the list with item codes. Right now I get a list of all the items in the file which makes it increasingly difficult to choose the right one due to a large number of the items. I believe that can be fixed by doing a conditional value list so that the only items that will appear will be the items of the vendor that I am ordering to. Is there a way to get that list to include the items as stated above plus the same item from the other vendor (reason being: due to a large volume of items when ordering sometimes we order to a bit more expensive vendor as we are not able to remember and easily check from how many vendors we get the item from, sometimes it can be up to 6 different vendors) The list could look something like: Order to vendor A List would show: Item X $1.00 Item Y $1.00 ------------ Item X $1.25 Vendor B Provided that item X can be obtained from both vendors To have it set up that way should I add item fields in vendor tables or how would I do that? More importantly what I am trying to achieve is: I do not want to duplicate item codes so do I set vendor A, Vendor B... fields in the item table where I can manually assign vendors from which the item is available or is it better to set them in the vendor table? thanks.,
Vaughan Posted June 28, 2007 Posted June 28, 2007 Offt the top of my head, I'd suggest that Products and Vendors should be related to a third table (ProductVendor) so for a product that is available from four vendors, there will be four ProductVendor records.
TKnTexas Posted June 29, 2007 Posted June 29, 2007 One question I have is .. what do you do when you buy from vendor A at $1.00 and then the next week you buy from vendor A and it is $1.25. I do Filemaker on the side, but in my daytime job I work with an inventory/AP system. The item is there once. We typically buy from the same vendor. However, on occasion we will use the alternate vendor. Sometime for pricing, sometimes for expediency in getting the item to the customer.
Anuviel Posted June 29, 2007 Author Posted June 29, 2007 We usually have a set price., the price cannot go higher. If we get something at $1.00 it is always 1.00 - we are distributors and deal in large quantities usually around 500+ pieces of single item per order. If they want to raise their prices we go somewhere else so to speak. In any case we go to different vendors if the original vendor is out of stock. Which happens often due to large quantities we deal with. Therefore this list will make it possible for us to see when placing an order where from the item can be ordered if it is not available with original vendor. I will check the table that Vaughan suggested. Will post later on if I was able to do it that way. Thanks.,
Recommended Posts
This topic is 6417 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now