Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6417 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Relations.gif

Posted

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.

Posted

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.

Posted

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.