Journals and Reporting Review

1. Pending Commissions – Drills down to the Commission Journal which contains all open commission lines from open Sales Orders. This will only show you pending commissions that have not been posted yet. 

• Override in the top ribbon allows for the user to change values and quantities for an individual commission line. 

2. Commission Payment Journal – Opens up the Commission Payment Journal so the user can Generate Payment Journals to bring in all commission lines. After posting the payment journal, it will generate an Employee Ledger if Pay-to is an employee and Vendor Invoice if Pay-to is a vendor.

• If Pay-to Type is Vendor, users will need to post the purchase invoice. 

• Vendor Invoice No. (External Document No.) can be updated line-by-line in this journal before posting. 

3. Commission Ledger – Drills down to the Commission Ledger which contains all posted commission lines from Sales Orders. All commission lines will appear here after the Sales Order has been shipped and invoiced or after the Sales Invoice has been posted. After payment has been posted, the payment will be applied to the commission line in the Commission Ledger.

• Edit Ledger 

  • Allows the user to edit the selected ledger entry 

• Approve Ledger 

  • Allows the users with approval access to approve individual or multiple entries 

• Add Misc Ledger 

  • Allows for random commissions to be added to the ledger 

• Add Comm. Credit 

  • Allows for commissions to be offset by an amount 

    • Example: A company wants to credit the commission amount by the fixed salary for an employee. If salary is $75,000 and commission is $150,000, the user can Add Comm. Credit for $75,000. 

• Commission History Report 

  • Shows all posted commissions for each employee 

    • Includes Document No., Customer No.,  and Customer Name for easy filtering 

• Delete Ledger 

  • Allows users to delete individual or multiple entries from the Commission Ledger

• Commission Ledger Columns 

  • Invoice Paid 

    • Specifies if the Invoice has been Paid 

  • Invoice Paid Date 

    • Specific when the Invoice was Paid 

  • Cr. Memo Paid 

    • Specifies if the Credit Memo has been Paid 

  • Cr. Memo Paid Date 

    • Specifies when the Credit Memo was Paid

4. Commission Dashboard – Opens up the dashboard to display commissions by Employee or Vendor. The Pay-to No. can be filtered for Pending and Posted commissions for easy visibility and sorting. 

• Settings – Commission Dashboard Settings 

• Refresh – Refreshes the data in the dashboard 

• Pending  

  • Shows all open commissions by Employee or Vendor 

• Posted 

  • Shows all posted commissions by Employee or Vendor 

• Paid Only

  • Enables users to filter records to show only Paid Posted Invoices

• Date Filters 

  • Shows all posted commissions Today, Week to Date, Month to Date, etc. 

• Commissions by Pay-to/Date – Shows all Posted Commissions by the Pay-to No. and the Date.

• Top Pay-to Commissions – Shows the Top Commissions by Pay-to No. 

• Posted Sales with Commissions – Shows all Posted Sales Documents with Commissions attached.

  
  

  

commission management journals and reporting review.pdf

Download PDF • 461KB