Report Post Commission To G/L
The Commission Setup can be configured in a way that the system will post entries to the General Ledger at the time a Commission Ledger Entry is created. This will create liabilities for your commissions to be paid and will expense those at the proper time. If you have this setup turned on, you do not have to do anything with this at month's end.
However, if you do not want General Ledger Entries created at the time of posting, but want to do that at the end of the month, you can do that as well. The report can be executed by choosing the icon, enter Post Commission To G/L, and follow the related link.
The request page for the report allows you to define two options. You can define, if you want to Post the transactions or just view them. If you do not check the flag Post, you can run this report as a test report to preview the transactions that will be posted when the flag Post is checked. The second option allows you to Print Zero Commission Lines in the report. By default, only lines that have commissions will be printed to show the General Ledger impact.
You can filter the Commission Ledger Entries to only post the cost for commissions for certain documents or salespeople. You also can define a filter for the Effective Date for the commissions. You should always filter to stop at the month end that you are processing at this time. You can go past the month end or post all transactions for multiple months, but to be able to have a clean separation between the different months, you want to only post transactions to the General Ledger for a particular month.
The posting respects the Allow Posting From and Allow Posting To dates configured in Business Central. If the transaction would be posted in a date range that is not allowed, it will post the transaction in the first date that is allowed.
The report will not post any transactions in preview mode, so to post the actual transactions to the G/L, you have to select Print. You can print it to a PDF, if you want to save a tree.
Automating the posting
If you do not want to post transactions any time you post a commission transaction, but also do not want to perform this step manually every month end, you can schedule this report on the Job Queue. You can setup the report to be run automatically at specific dates. Learn more on how to Use Job Queues to Schedule Tasks