Skip to main content

Best way to set up base for two way multi item inquiries/quotes/orders

  • December 9, 2024
  • 1 reply
  • 14 views

FPX
Forum|alt.badge.img+12

Hi all

@TheTimeSavingCo @kuovonne @ScottWorld 

Keen to hear how you would go about setting up the subject. Details below;

1) Buyers need to make single or multi item enquiries to their delivery location.

2) Sellers need to be able to make one or more quotes against selected enquiry items.

3) Upon approval from both sides the status moves to ordered. 

4) Currently I have the inquiry items table linked to a parent table which holds the buyers details. Likewise with the quote items linked to parent table.

5) The sellers needs to view the inquiries and choose the selected products to quote price and quantities against. This needs to create a record in the parent table aswell as the quote/order items table

Buyers then need to accept quotes.

Sellers then need to approve.

Order becomes final and awaits dispatch.

1 reply

VikasVimal
Forum|alt.badge.img+12
  • Inspiring
  • December 27, 2024

It's not too tricky.
You'd need a Contacts table (Buyer + Seller) (or have separate buyer and seller table)
A Products table
An Enquiry Table
An Enquiry Line Items table
A Quote Table
A Quote Line Items table with the workflows.

Enquiry would be linked to buyer. Quotes would be linked to Enquiries. Enquiry and quote line items will be linked to products and also to Enquiries and Quotes table respectively.