I expected Dynamics GP transactions to be created for my salespeople, but none were generated. How do I fix this?

EthoTech Admin -

Article ID: KB0048

Review Your Commission Transaction Configuration Setup

There are 2 places to look: 

  1. On the Commission Plan Setup window in the Commission Processing section, make sure the appropriate checkboxes are marked for creating transactions. 
  2. On the Salesperson Commission Plan Info window in the Commission Processing section, review each Salesperson ID to make sure the Create Transaction option is set to a value other than None. If you have configured Commission Plan to create Commission Accrual transactions, the Create Accrual Trx checkbox will also need to be marked for all Salesperson IDs who are included in your commission accrual amount.

Creating Payables Transactions

Here are some reasons why a Payables transaction may not have been created when commissions were processed:

  1. On the Process Commissions window in the Dynamics GP Trx Info section, the Do not create Dynamics GP transactions checkbox was marked. [WIndow: Process Commissions]
  2. NO Vendor was assigned to the Salesperson. [WIndow: Salesperson Maintenance]
  3. The Vendor assigned to the Salesperson was Inactive. [WIndow: Vendor Maintenance]
  4. The Vendor assigned to the Salesperson was on Hold. [WIndow: Vendor Maintenance]
  5. A commission payable or expense account was not assigned to the Salesperson. [WIndow: Salesperson Commission Plan info]
  6. The commission payable or expense account assigned to the Salesperson was not a Posting Account. [WIndow: Account Maintenance]
  7. The commission payable or expense account assigned to the Salesperson was Inactive. [WIndow: Account Maintenance]
  8. The commission payable or expense account assigned to the Salesperson did not allow account entry. [WIndow: Account Maintenance]

Creating GL Transactions

Here are some reasons why a GL transaction may not have been created when commissions were processed:

  1. On the Process Commissions window in the Dynamics GP Trx Info section, the Do not create Dynamics GP transactions checkbox was marked. [WIndow: Process Commissions]
  2. A commission payable or expense account was not assigned to the Salesperson. [WIndow: Salesperson Commission Plan info]
  3. The commission payable or expense account assigned to the Salesperson was not a Posting Account. [WIndow: Account Maintenance]
  4. The commission payable or expense account assigned to the Salesperson was Inactive. [WIndow: Account Maintenance]
  5. The commission payable or expense account assigned to the Salesperson did not allow account entry. [WIndow: Account Maintenance]

Creating Payroll Transactions

Here are some reasons why a Payroll transaction may not have been created when commissions were processed:

  1. On the Process Commissions window in the Dynamics GP Trx Info section, the Do not create Dynamics GP transactions checkbox was marked. [WIndow: Process Commissions]
  2. NO Employee was assigned to the Salesperson. [WIndow: Salesperson Maintenance]
  3. The Employee assigned to the Salesperson was Inactive. [WIndow: Employee Maintenance]
  4. NO Pay Code was assigned to the Salesperson. [WIndow: Salesperson Commission Plan info]
  5. The Pay Code assigned to the Salesperson/Employee was Inactive. [WIndow: Pay Code Setup]
  6. Dynamics GP 2018 R2 and earlier: The commission Pay Code assigned to the Salesperson was not assigned to the Employee. [WIndow: Employee Pay Code Maintenance]
  7. Dynamics GP 18.2 and later: the commission Pay Code assigned to the Salesperson was not assigned to the Employee with a Start Date - End Date range that included the Payroll Transaction Date entered in the Process Commissions window. [WIndow: Employee Pay Code Maintenance]
  8. The commission Pay Code assigned to the Salesperson/Employee was not a Pay Type = Commission. [WIndow: Pay Code Setup]
  9. A commission payable or expense account was not assigned to the Salesperson. [WIndow: Salesperson Commission Plan info]
  10. The commission payable or expense account assigned to the Salesperson was not a Posting Account. [WIndow: Account Maintenance]
  11. The commission payable or expense account assigned to the Salesperson was Inactive. [WIndow: Account Maintenance]
  12. The commission payable or expense account assigned to the Salesperson did not allow account entry. [WIndow: Account Maintenance]

Comments