I love that on the quote there is a separate table for the sales reps and their rates. Why can’t we have that on the order and on the invoice? It would make queries and reports much simpler when having to deal with sales reps.
Add an OSalesRP and an InvcSalesRp Table - Add a table for related sales reps for Sales Order & Invoice
utaylor (Utah Taylor) #1
Mark_Wonsil (Mark Wonsil) #2
+1 for database normalization. (Big change…but worth it)
utaylor (Utah Taylor) #3
Boyce and Codd would vote yes. QuoteHed already has the table (QSalesRp) so I don’t know why the others are handled differently.