Hi,
I used to work in a Strategic Sourcing Advisory firm. We used to manage our quotations on Ariba. They have a lot of types of quotations and auctions…
I understand that the ERPNext doesn’t pretend to be the best purchase platform, but it wants to provide the best ERP. And, for it, I suggest we improve a little the purchase module.
The concept is:
1 material request > many RFQs
1 RFQ > many Suppliers
Once the RFQs are answered:
RFQ > Supplier Quotation > View:
Material Request xpto | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4 | Supplier 5 | |
---|---|---|---|---|---|---|
Item 0001 | $ 1,00 | $ 3,50 | $ 3,50 | $ 1,00 | $ 35,00 | |
Item 0002 | $ 2,00 | $ 2,00 | $ 4,50 | $ 2,00 | $ 27,00 | |
Item 0005 | $ 1,50 | $ 3,00 | $ 3,00 | $ 1,00 | $ 26,00 | |
Item 2921 | $ 2,50 | $ 2,50 | $ 4,00 | $ 3,00 | $ 25,50 |
Then, the system could analyse the quotations and permit the user to choose what purpose it wants:
Material Request xpto | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4 | Supplier 5 | Best Offer | Supplier | ||
---|---|---|---|---|---|---|---|---|---|
Item 0001 | $ 1,00 | $ 3,50 | $ 3,50 | $ 1,00 | $ 35,00 | $ 1,00 | Supplier 1 | ||
Item 0002 | $ 2,00 | $ 2,00 | $ 4,50 | $ 2,00 | $ 27,00 | $ 2,00 | Supplier 1 or Supplier 2 | ||
Item 0005 | $ 1,50 | $ 3,00 | $ 3,00 | $ 1,00 | $ 26,00 | $ 1,00 | Supplier 4 | ||
Item 2921 | $ 2,50 | $ 2,50 | $ 4,00 | $ 3,00 | $ 25,50 | $ 2,50 | Supplier 1 or Supplier 2 |
We could mark the unchosen offers as loser offer, and the chosen as winner offer. (in this particular example, We can chose the supplier 1, even the supplier 2 have the same quotation, aiming to use the minimum suppliers amount - we used to call this strategy as “cherry picking”).
The RFQ could change the status to completed, using the winner offers.
Then, the purchase orders could be initialized, in RFQ > Create > Purchase Orders (creating drafts per Supplier).
I believe it could solve the 1 RFQ > many supplier offers “issue”.