Add an OSalesRP and an InvcSalesRp Table - Add a table for related sales reps for Sales Order & Invoice

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.

+1 for database normalization. (Big change…but worth it)

1 Like

Boyce and Codd would vote yes. QuoteHed already has the table (QSalesRp) so I don’t know why the others are handled differently.

1 Like