Payroll Cost Center Override on Taxes

Question

Client is running Sage 300 version 2020, but apparently this problem has been haunting them for years, in prior versions. A cost center override comes into play on employer tax expense, and we can’t figure out why. This happens only on earnings codes where no cost center override is specified at the pay line level (because we don't want to override, or we're OK with using the default override).

Example: Employee has default Cost Center Override 20.

Distribution Code MC, in use on his USMED tax line, goes to Account 7710.00.10.

Taxes have no Cost Center Override feature.

And yet, you can see in this snipped from RVSPY, it is applying an override of “00”.

UP0009: UPDIST [16:45:14.87].Put(view=0x0AF4579C, field=1, size=6, verify=0, buffer='\55\53\4d\45\44\20' -> 'USMED ')

0 <==[16:45:14.87;t=0;ovh=0] {}

UP0009: UPDIST [16:45:14.87].Put(view=0x0AF4579C, field=2, size=6, verify=0, buffer='\4d\43\20\20\20\20' -> 'MC ')

0 <==[16:45:14.87;t=0;ovh=0] {}

UP0009: UPDIST [16:45:14.87].Read(view=0x0AF4579C)

0 <==[16:45:14.87;t=0;ovh=0] {}

UP0009: UPDIST [16:45:14.87].BlkGet(view=0x0AF4579C, count=9, fields/sizes=1/6$2/6$3/15$4/45$5/45$6/45$7/45$8/45$9/45$)

0 <==[16:45:14.87;t=0;ovh=0] BlkGet return

* field=1, size=6, buffer='\55\53\4d\45\44\20' -> 'USMED '

* field=2, size=6, buffer='\4d\43\20\20\20\20' -> 'MC '

* field=3, size=15, buffer='\4d\65\64\69\63\61\72\65\2d\45\45\20\20\20\20' -> 'Medicare-EE '

* field=4, size=45, buffer='\37\37\31\30\2e\30\30\2e\31\30\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> '7710.00.10 [*note- this is the account we want] '

* field=5, size=45, buffer='\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> ' '

* field=6, size=45, buffer='\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> ' '

* field=7, size=45, buffer='\32\32\31\37\2e\30\30\2e\30\30\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> '2217.00.00 '

* field=8, size=45, buffer='\32\32\31\37\2e\30\30\2e\30\30\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> '2217.00.00 '

* field=9, size=45, buffer='\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> ' '

GL0100: GLAMF [16:45:14.87].Put(view=0x0AF189BC, field=1, size=45, verify=0, buffer='\32\32\31\37\2e\30\30\2e\30\30\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> '2217.00.00 ')

0 <==[16:45:14.87;t=0;ovh=0] {}

GL0100: GLAMF [16:45:14.87].Read(view=0x0AF189BC)

0 <==[16:45:14.87;t=0;ovh=0] {}

GL0100: GLAMF [16:45:14.87].Get(view=0x0AF189BC, field=6, size=2)

0 <==[16:45:14.87;t=0;ovh=0] {buffer='\01\00'}

GP0800: GPGLFMT [16:45:14.87].Init(view=0x0B3E8284)

0 <==[16:45:14.87;t=0;ovh=0] {}

GP0800: GPGLFMT [16:45:14.87].Put(view=0x0B3E8284, field=1, size=45, verify=0, buffer='\37\37\31\30\2e\30\30\2e\31\30\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> '7710.00.10 ')

0 <==[16:45:14.87;t=0;ovh=0] {}

GP0800: GPGLFMT [16:45:14.87].Put(view=0x0B3E8284, field=3, size=15, verify=0, buffer='\30\30\20\20\20\20\20\20\20\20\20\20\20\20\20' -> '00 ') [*What is causing the 00 to override here?]

0 <==[16:45:14.87;t=0;ovh=0] {}

GP0800: GPGLFMT [16:45:14.87].Put(view=0x0B3E8284, field=2, size=6, verify=0, buffer='\30\30\30\30\30\33' -> '000003')

0 <==[16:45:14.87;t=0;ovh=0] {}

GP0800: GPGLFMT [16:45:14.87].Process(view=0x0B3E8284)

0 <==[16:45:14.87;t=0;ovh=0] {}

GP0800: GPGLFMT [16:45:14.87].Get(view=0x0B3E8284, field=21, size=45)

0 <==[16:45:14.87;t=0;ovh=0] {buffer='\37\37\31\30\2e\30\30\2e\30\30\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> '7710.00.00 '}

GL0100: GLAMF [16:45:14.87].Put(view=0x0AF189BC, field=1, size=45, verify=0, buffer='\37\37\31\30\2e\30\30\2e\30\30\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> '7710.00.00 ') [* here we see the newly constructed account, which happens to be inactive]

How can we prevent this?

wheumann · Accepted Answer

UPDATE: I spoke with Thomas in Tech Support, who found that online help says that if you have enabled cost center overrides at all, "when you calculate payroll, the tax amounts are distributed to the cost centers in which the taxable wages were earned." In this case, job postings go through a clearing account that ends in 00, so all tax expenses will go to 00. I don't necessarily agree with the logic, but at least it is behaving as Sage intended.

Sage 300

Payroll Cost Center Override on Taxes

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING