Looking for ideas...
I need a simple App or a Table that I can input component part numbers into in which I need quotes for.
I would then grant access to this table or app to our suppliers. They need to only be able to see the request for quotes that are directed to
their company since the same list of parts may be sent to multiple suppliers. I do not want them to see each others quotes.
example:I have a customer drawing for an assembly that consists of 5 components (some connectors and some wires). I need to enter the MFG name and Part numbers of these 5 components into a table each with their own Line Item #.
Line 1 Sent to ABC, Inc
Line 2 Sent to ABC, Inc
Line 3 Sent to Wire, Co
Line 4 Sent to Wire, Co
Line 5 Sent to Wire, Co
Somehow notify my suppliers there is a Request for Quote ready for them. They can then log in and see the parts needed to be quoted. Enter their pricing, hit submit and be done. I am okay with them being able to view their past quoted entries, but do not want them to have access to other suppliers entries. So ABC, Inc cannot see Wire, Co pricing.Bonus points if all the parts that need to be quoted show up on a grid edit form as opposed to having to open each line and add pricing one at a time. This way if their system generates quotes in a spreadsheet form, they can simply copy and paste the data into QB and submit.What is the easiest way to do this? I was looking for an already created app but could not find anything that would work for our company.
Please no third party add-on recommendations. This option has already been vetoed.
Thanks in advance!!!