Dynamics Community Forum Thread Details

Payroll: Net Pay posted twice to Cash Account

I had an interruption while printing payroll checks where the Net Pay portion posted twice to the Cash Account. What are the steps to clear/void the extra Payroll Checks that were printed and showed up on the Payroll Check Posting Register?

The payroll entries DO NOT post directly to the GL, so I have to go through the Series Posting process on the Financial Tab, but there is an error when I attempted to post the Batch but the error showing is "Transaction Error - Edit Required". It will not post as the Batch does not balance due to the additional payroll check that was generated.

Hello adam,

Thank you for using Community Forums.

The following information was taken from KB's on voiding a check in Payroll.

Void Check not working in Payroll

support.microsoft.com/.../864992

Several conditions must exist for the Void Check feature to work in Payroll. Please go through the following steps to determine why your client is unable to successfully void the problem check:

1. 1 The check you are trying to void must exist in both check and transaction history.

2. It cannot have a duplicate check number, determined from check history table UPR30100. To determine if there is a duplicate check number, run the following statement against the company database for each problem check:

SELECT * FROM UPR30100 WHERE CHEKNMBR = 'XXX'

Note: XXX = the checknumber for the check that will not void.

If leading zeroes are not used in the check number (Cards | Financial | Checkbook), the system may see the following check numbers as duplicate as it reads the check number from left to right.

101

1011

If leading zeroes were used, the checks would look like the following and therefore would not be a duplicate.

00101

01011

3. The check must be available for reconcile in Bank Reconciliation.

4. The check must fall within the current year.

5. View the CM20200 table in Query Analyzer

SELECT * FROM CM20200 WHERE SRCDOCNUM ='XXXX'

SRCDOCNUM is the check number used in payroll. For the check you are trying to void, the below columns need to have this type of status for the check to appear in the payroll void window. For example, if the RECONUM column is 1.00000, then it will not appear in the void window.

RECONUM = 0

Recond = 0

VOIDED =0

6. Use the following statement in Query Analyzer to view the CM20200 table:

SELECT * FROM CM20200 WHERE CMTrxNum ='XXXX'

Search on the check number that you cannot void. Duplicate check numbers cannot exist. If there is a duplicate number, even if it is from another module, the check cannot be voided.

If you need further assistance, my suggestion would be to open a support incident with the GP help desk.

Quick Links