Pos5/FNB: Unable to delete commission from commission maintenance

From AutoCount Resource Center

Question :

I cannot delete the promoter's commission, system prompts an error “The value of column CommissionID in table PosPromoter does not exist in its master file.


I’m sure that I didn’t create any transaction for this commission plan.

Possible Reason :

The error is due to the commission id is used in POS Promoter setting.

Solution :

To remove the setting, you need to;

1. Go to Point of Sale > Promoter > Promoter Maintenance


2. To know which promoter is tied to this commission, right click on detail pane to select Column Chooser. Drag the Commission ID to detail panel.


3. Select Promoter and click on Edit.


4. Press Ctrl + 0 on your keyboard to remove the value in the field of Commission:


5. You will be able to delete the Commission ID now.


By: Kee 20200318, Jacky 20200319 [000013]

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations