Hi
@Selena Breedlove
Can you post screenshots.
In essence it sounds like Company B's Checkbook was used but perhaps someone manually updated the distributions to Company A's GL Account for the Cash Amount (but without shots it's hard to say).
When you cut a check a few tables get hit... the transactions in the CM (Cash Management or Bank Rec Module) get hit based on the Checkbook ID, the GL gets hit with the GL Accounts on the distribution screen.
This mixup is likely what caused this. You would need to do a cash transaction (using a suspense or wash account) to move the transaction amount from Company Bs Checkbook to Company As checkbook.
You may have seen a different account (bank account) if you'd printed the check but because it was manual this sort of mistake was easy to overlook.
Let us know if you cannot figure out how to do the cash transaction to move it over to the right checkbook.
------------------------------

------------------------------
Original Message:
Sent: May 18, 2020 11:44 AM
From: Selena Breedlove
Subject: checkbook trx posted to another DB's checkbook
We have a checkbook entry posted to Company A, but the entry is on Company B's checkbook. Entry is still posted on Company A's general ledger. Here's details I can provide:
- We are on GP 2019.
- Payment was posted from the Purchasing Manual Payments window
- When drilldown on the payment -
- Apply To information is accurate
- the "CASH" account is empty
- Checkbook ID shows Company B's checkbook ID
- The checkbook ID names are different on Company A and Company B
The issue caused a problem on the bank reconciliation of both Company A & B. The transaction was on Company A's bank statement and g/l, but not listed on the reconciliation screen. Company B shows the entry on the reconciliation transactions, but not on the g/l. Each company had an out of balance on the reconciliation.
Any ideas how this happened?
Other than creating transactions to reverse or record the actual checkbook transactions, is there a way to correct the tables?
Thank you.
------------------------------
Selena Breedlove
SVP of Finance/Controller
US Assure Inc
Jacksonville FL
------------------------------