HB
Full Member
 

I love DBA
Posts: 216
Gender:
|
Hi Lynn, I am a little puzzled by your response. as you can see from the following, there is a relationship set up between the DISC% and the Comm% when running the Commission Detail Report. It is this relationship i need to work with. (I truncated the report to show only a few lines) Cust Name Cust PO Item Number Date Invc# Quantity Price Disc% Comm% Sale Amt Commission HYATT'S GRAPHIC B156430 205M-BP 04/01/13 413951 24.00 5.9900 62.50 5.0000 53.91 2.70 ESSEX CARD SHOP, ESSEX327 25 04/02/13 413964 6.00 9.4900 50.00 12.0000 28.47 3.42 ESSEX CARD SHOP, ESSEX327 700-12A 04/02/13 413964 6.00 11.5900 50.00 12.0000 34.77 4.17 ESSEX CARD SHOP, ESSEX327 957ABP 04/02/13 413964 6.00 3.9900 50.00 12.0000 11.97 1.44 ESSEX CARD SHOP, ESSEX327 944BP 04/02/13 413964 6.00 3.9900 50.00 12.0000 11.97 1.44 ESSEX CARD SHOP, ESSEX327 9405ABP 04/02/13 413964 6.00 3.9900 50.00 12.0000 11.97 1.44 ESSEX CARD SHOP, ESSEX327 525BP 04/02/13 413964 6.00 3.3900 50.00 12.0000 10.17 1.22 RAINBOW ACE HARD 4813 10 04/16/13 414100 6.00 10.9889 55.00 10.0000 29.67 2.97
|