Menu

Supplier Price History in Laravel: Effective Dates and Variance Alerts for RFQ Quotes
📰

Supplier Price History in Laravel: Effective Dates and Variance Alerts for RFQ Quotes

DEV Community: php·Tuğrul Yıldırım·3 days ago
#LRfQdDVn
#devto#dev#price#table#quote
Reading 0:00
15s threshold

A buyer approves a supplier quote. Two weeks later, finance asks a simple question: "We paid 14.20 per unit last spring. Why are we paying 16.80 now, and who noticed?"

Nobody noticed, because the system could not tell them. The product had a last_price column on the supplier pivot table, and every new purchase order overwrote it. The old price was gone. So was the date it changed, the document that changed it, and any chance of comparing a new quote against what the company actually paid before.

Price history is one of those features that looks optional until the first audit or the first awkward meeting with a supplier.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.