Article ID: KB0043
ISSUE
On my Sales Edit List or during the Dynamics GP posting process, I get the error message:
"**ERROR: The commission sale total does not equal the commission sale amounts."
WHAT WE KNOW ABOUT THIS ERROR
- This is a Dynamics GP error and is not caused by EthoTech and it does not affect commissions created by EthoTech.
- If Dynamics GP commissions were created, commission distributions could exist in the Sales Distribution Entry window that will need to get removed.
- This error message occurs when the 'Commission Applied To' total does not match the 'Total Commission Sales' total on the Dynamics GP Sales Commission Entry window. Typically, this occurs when the commission amount = $0 for the Salesperson ID.
PLEASE NOTE: Commission Plan does not use the Dynamics GP commission functionality or tables. EthoTech uses its own functionality and tables for tracking commission data. With Commission Plan installed and configured and Dynamics GP commissions turned OFF, NO commission distributions are created on Dynamics GP sales invoices.
SOLUTIONS THAT HAVE CORRECTED THIS ERROR
There are several possible solutions we have seen correct this issue. Here is a list of these solutions in order of success rate based on our experience with this error. If the first one does not resolve this issue, then please move to the second one, and so forth.
SOLUTION #1
Delete the sales line item on the sales document and re-enter it.
Using the Dynamics GP Sales Transaction Entry window, pull up the sales document(s) causing this error, delete ALL sales line items, and re-enter them. This corrects the data and removes this error, allowing posting to occur successfully.
Print your Edit List to verify this error has been resolved.
SOLUTION #2
Delete the Dynamics GP commission record from the Sales Commission Entry window.
When using Commission Plan, you will need to uncheck the Disable Dynamics GP Commissions checkbox on the Commission Plan Setup window and click Apply. [Sales Area Page >> Setup >> Commission Plan >> Commission Plan Setup]
From the Dynamics GP Sales Transaction Entry window, open the Dynamics GP Sales Commissions window to delete Dynamics GP commissions. [Sales Area Page >> Transactions >> Sales Tranaction Entry - GO TO > Commissions]
In the Sales Commission Entry window, you will see one or more Salesperson ID(s) which may show a commission amount OR $0. Click DELETE. This will remove the Dynamics GP commissions that were created and in turn, reset the commission subtotals in the SOP transaction tables.
Close the Sales Commission Entry window. IF commission distributions were created, then you will need to recreate your distributions on the invoice.
Open the Sales Distribution Entry window and click DEFAULT.
Doing this should reset your distribution totals and remove the commission related distributions IF ANY EXIST, which will allow you to post this invoice.
Close the Sales Distribution Entry window by clicking OK.
Save the sales documents by clicking SAVE on the Sales Transaction Entry window.
After you have corrected ALL of the sales documents causing this error, then you can mark the Disable Dynamics GP Commissions checkbox again on the Commission Plan Setup window.
Print your Edit List to verify this error has been resolved.
SOLUTION #3
Remove Dynamics GP sales commission data from table SOP10101.
***MAKE A BACKUP OF YOUR DYNAMICS AND COMPANY DBs FIRST***
The loss of your company's accounting information can be prevented by having backup copies of data. If your tables become damaged, you can return them to their original, undamaged state, minimizing data reentry.
The SOP10101 table contains the commission data entered in the Dynamics GP Sales Commission Entry window. When using EthoTech Commission Plan, this table is not populated. Since there is no need to use Dynamics GP commissions functionality in conjunction with EthoTech Commission Plan functionality, this table should not contain any records from when you started using EthoTech Commission Plan.
Delete the contents of this table for the relevant period using SQL Management Studio* and then, run Dynamics GP Sales Utilities to resolve the subtotal issue.
Open the Reconcile-Remove Sales Documents window. [Sales Area Page >> Utilities >> Reconcile - Remove Sales Documents]
Select a Documents range for the affected sales documents or choose All.
Select Option: Reconcile Sales Documents.
NOTE: Before you reconcile, you can print the Reconcile-Remove Sales Document Report to verify information about the document ranges you’ve entered by marking the Print Report Only option. If you mark this option, the report will be printed but the documents won’t be reconciled.
Click Process. The Reconcile-Remove Sales Document Report will be printed automatically and will list the sales documents that were reconciled.
Print your Edit List to verify this error has been resolved.
SOLUTION #4
Manually update the commission amounts in table SOP10100.
***MAKE A BACKUP OF YOUR DYNAMICS AND COMPANY DBs FIRST***
The loss of your company's accounting information can be prevented by having backup copies of data. If your tables become damaged, you can return them to their original, undamaged state, minimizing data reentry.
Using SQL Management Studio*, change the amounts in the following fields to $0: COMMAMNT, CMMSLAMT, ORCOSAMT.
Print your Edit List to verify this error has been resolved.
*For assistance with SQL Management Studio, please contact Microsoft or your Microsoft Partner.
Comments