Sage 50 Canada

Welcome to the Sage 50 Canada Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Data inconsistencies in vac pay balance vs vac pay owed

Posted By Jee_dee over 6 years ago

I was completing a data integrity check prior to flipping our fiscal year, and discovered that there is a data inconsistency (please see below)

Vac Pay Balance $233,644.06 Vac. Pay Owed $235,072.96

This means that there is a difference of $1,428.90. How can I figure out what this difference is, and more importantly, how can I fix this difference?

Thank you for any help!

0 Jason. over 6 years ago

Vac Pay Balance is general ledger (GL) link account balance (setup, settings, payroll, link account, income, vacation owed)

Vac. Pay Owed is Sub ledger (SL) value from paycheque you post that have vacation earned.

You can generate a GL report VS employee detail report compare with vacation earned column and see which does not match

in the end , you might have to unlink vacation payable account , post a general journal of the 1428.90 then re-link it, so GL match SL

(it also depends on if GL is correct or SL is correct, if GL is correct then after general journal fix to match, you have to check outstanding vacation see which is wrong fix it in paycheque)

Related knowledge-base article 10222
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 50 Canada

Data inconsistencies in vac pay balance vs vac pay owed

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING