Step-by-Step Instructions

CR-29 (Cash Receipt - Commission Report)


1. How are commissions calculated?:
  • Customer Commissions are calculated on Net Sales.
  • Commissions are paid after Customer Pays.
  • Customer may take Discount according to Terms.
  • Invoices are entered ASSUMING Customer will NOT take discount.
  • Therefore, All Invoices are entered with no Discount.
2. The problem:
  • If we give the Discount at the time of the original Invoice, then some Customers may not pay in time and the Discount would then be invalid.
  • Since Customers take their discounts (after the fact), we could not lower the Invoice Amount, and therefore would be paying commissions on the Gross Amount.
  • It would be best to NOT enter Discounts immediately, but wait until we receive the Customer Check, and then decide whether or not to apply the Discount at that time.
3. The solution:
  • We needed a way to enter the Customer Discount at the time of entering the Cash Receipt.
  • So, it is now possible to "go to" the Invoice(s) and "apply" the Discount as if it was done on the original Invoice.
4. To Apply Discount to Original Sales Order(s):
  • Enter CR-14 Screen.
  • Enter Customer Number
  • Locate the Invoice Number
  • Go to the field you want to change (/18.n) n = line #.
  • Input /EC to go to OE-1 Screen
  • Inside OE-1, Input /Disc
  • Input /36   (go to discount type field)
  • Input /Apply DD * (applies discount code DD to all lines)   NOTE: You need to enter your correct code.
  • Input /F to file.
  • Press Escape Key to go back to CR-14 Screen (You will see the Invoice Amount decrease by the discounted amount)
  • Repeat the above for each Invoice that requires a discount