Override Commissions Reporting in SedonaOffice
The SedonaOffice commission reports display commissions when they are added to jobs, and then mark them as paid when manual journal entries are added to record the payment. Some customers record these payments in their payroll software rather than SedonaOffice. For these customers we have created an override that will force a job’s commissions to show as paid.
The following script will activate the Job Commissions Paid checkbox in the job custom fields screen. Checking this box will cause all commissions on the job to no longer show in any of our commission reports.
Script:
//IF EXISTS(SELECT Setting_Value FROM dbo.RM_Global_Setting WHERE Setting_Code = 'OE_COMMISSION_FILTER')
BEGIN
UPDATE dbo.RM_Global_Setting
SET Setting_Value = N'Check1'
WHERE Setting_Code = 'OE_COMMISSION_FILTER'
END
ELSE
BEGIN
INSERT dbo.RM_Global_Setting(Setting_Code, Setting_Value)
VALUES('OE_COMMISSION_FILTER', N'Check1')
END
