Commissions Are Not Calculated for AR Invoices

Issue

Commissions are not calculated for AR invoices if it has been paid immediately after creation.

Steps to Recreate

The following was reproduce in sample company 99.

  1. Open the Order Entry (SO) application module.
  2. Enable the following options in SO setup:
    • Calculate Sales Commissions
    • Rate Source for Sales People
    • Commission Calculation Basis for Sale
    • Pay at Shipment.
  3. Open the Accounts Receivable (AR) application module.
  4. Create an invoice using line item A2EW and assign a commissioned salesperson.(example salesperson AM.)
  5. Save the invoice and do not create a receipt.
  6. Click Proceed.
  7. Create a second invoice identical to the first invoice and click Receipt.
  8. Pay the second  invoice in the receipt screen.
  9. Open the SOSCMT table.
  10. Locate the record created by the first invoice, the status field is populated with “S” indicated the order has been shipped. This invoice will display on the commission due report.
  11. Locate the record created by the second invoice, the tdate field is blank and the status field is populated with “receipt” indicating the order has not been shipped. As a result the commission due report will not find this invoice.

© Copyright Sage Software

Leave A Comment?