1. Correcting Receivables/bank transactions after bank reconciliation

Complicated scenario, Region #1 Customer A is invoiced for widgets, $10k. Customer A pays Us $10k but check is brought in as a bank transaction for services under Customer B in Region #2. Bank ​​reconciliations completed in GP. Next month the error was found. I need to void the original bank transaction and apply it to the invoice for Customer A, , however since it has been reconciled it will not let me do so. I want to make sure the revenue and receivable reports as well as the transactions are correct for customer A and B.

1. If you followed the above, you get a silver star2. If you have a workable solution you get a Gold star (in my book at least!)

What error message are you receiving when voiding? You're confident that it's a message that stops you from proceeding versus just prompting you to tell you it's already been reconciled? In other sitjai, I'm fairly confident that it's just a prompt and it'll still let you ultimately void. It ends up just creating a weird looking transaction in bank rec...

Last bit and it may not apply to your situation depending on answers above but... If this is all in sales module, what's to stop you from just booking credit/debit memos to correct this issue? Cash is done, now we'd just have to move the balance from one customer to the other. Just a thought...

Complicated scenario, Region #1 Customer A is invoiced for widgets, $10k. Customer A pays Us $10k but check is brought in as a bank transaction for services under Customer B in Region #2. Bank ​​reconciliations completed in GP. Next month the error was found. I need to void the original bank transaction and apply it to the invoice for Customer A, , however since it has been reconciled it will not let me do so. I want to make sure the revenue and receivable reports as well as the transactions are correct for customer A and B.

1. If you followed the above, you get a silver star2. If you have a workable solution you get a Gold star (in my book at least!)

Mark,This is a fun question (sounds like something off an SAT exam). It ends up being more of an accounting question and less of a question about GP. I would suggest creating a reversing entry in bank management to back out the original entry. Then you can re enter the receipt to the correct customer. By doing it this way, you will accomplish all of your goals. Your bank reconciliation will remain in tact and not need to be modified. Your customer accounts will be corrected. And, most importantly, you will have a paper trail show what happened and why.

What error message are you receiving when voiding? You're confident that it's a message that stops you from proceeding versus just prompting you to tell you it's already been reconciled? In other sitjai, I'm fairly confident that it's just a prompt and it'll still let you ultimately void. It ends up just creating a weird looking transaction in bank rec...

Last bit and it may not apply to your situation depending on answers above but... If this is all in sales module, what's to stop you from just booking credit/debit memos to correct this issue? Cash is done, now we'd just have to move the balance from one customer to the other. Just a thought...

Complicated scenario, Region #1 Customer A is invoiced for widgets, $10k. Customer A pays Us $10k but check is brought in as a bank transaction for services under Customer B in Region #2. Bank ​​reconciliations completed in GP. Next month the error was found. I need to void the original bank transaction and apply it to the invoice for Customer A, , however since it has been reconciled it will not let me do so. I want to make sure the revenue and receivable reports as well as the transactions are correct for customer A and B.

1. If you followed the above, you get a silver star2. If you have a workable solution you get a Gold star (in my book at least!)

Hi @Mark Common,Not sure if that would help, but the PSTL for GP has a function to return RM transactions, even if it was posted to history.. The PSTL library is free if you haven't already installed it..

What error message are you receiving when voiding? You're confident that it's a message that stops you from proceeding versus just prompting you to tell you it's already been reconciled? In other sitjai, I'm fairly confident that it's just a prompt and it'll still let you ultimately void. It ends up just creating a weird looking transaction in bank rec...

Last bit and it may not apply to your situation depending on answers above but... If this is all in sales module, what's to stop you from just booking credit/debit memos to correct this issue? Cash is done, now we'd just have to move the balance from one customer to the other. Just a thought...

Complicated scenario, Region #1 Customer A is invoiced for widgets, $10k. Customer A pays Us $10k but check is brought in as a bank transaction for services under Customer B in Region #2. Bank ​​reconciliations completed in GP. Next month the error was found. I need to void the original bank transaction and apply it to the invoice for Customer A, , however since it has been reconciled it will not let me do so. I want to make sure the revenue and receivable reports as well as the transactions are correct for customer A and B.

1. If you followed the above, you get a silver star2. If you have a workable solution you get a Gold star (in my book at least!)

If the transaction has been entered as a Cash Receipt and you didn't ran the "Paid transaction removal" routine, you can just void the transaction by going into Sales >> Transactions >> Posted Transactions. That will result as a negative cheque amount in the deposits for the checkbook. Just redo the cash receipt transaction with the correct customer, go do the deposit with those two cheques (deposit at zero) just make sure to select that deposit in the next bank reconciliation and you will have fixed the problem without affecting your bank reconciliation.

If the transaction has been entered has Bank transaction see Brett Albrecht answer

Complicated scenario, Region #1 Customer A is invoiced for widgets, $10k. Customer A pays Us $10k but check is brought in as a bank transaction for services under Customer B in Region #2. Bank ​​reconciliations completed in GP. Next month the error was found. I need to void the original bank transaction and apply it to the invoice for Customer A, , however since it has been reconciled it will not let me do so. I want to make sure the revenue and receivable reports as well as the transactions are correct for customer A and B.

1. If you followed the above, you get a silver star2. If you have a workable solution you get a Gold star (in my book at least!)

Our customers have deposits that have to be deposited however same scenario we catch it the next day or two days wrong customer... what PaymentReapply does it allows you to reapply... check out our website www.iscorp.biz for demos...

Complicated scenario, Region #1 Customer A is invoiced for widgets, $10k. Customer A pays Us $10k but check is brought in as a bank transaction for services under Customer B in Region #2. Bank ​​reconciliations completed in GP. Next month the error was found. I need to void the original bank transaction and apply it to the invoice for Customer A, , however since it has been reconciled it will not let me do so. I want to make sure the revenue and receivable reports as well as the transactions are correct for customer A and B.

1. If you followed the above, you get a silver star2. If you have a workable solution you get a Gold star (in my book at least!)