Share
Report
10Dynamics GP 2010 R2.
Hello, long time reader, first time poster.
I currently have an issue whereby I have the same transaction reflecting in the correct GL account, but the wrong checkbook.
I am wondering if anyone has had success with reassociating receipts with a different checkbook via SQL. I consider myself a semi-advanced SQL user with deep knowledge of the GP DB structure.
We are an omnichannel business with a mix of wholesale and retail, which equates to a massive amount of transactions monthly. 20K+
Due to an acquisition, we recently had to change banks. While the swap was carefully planned out, with a path for CC refunds to old bank, and an appropriate update of the default banks at different levels to accomodate new incoming deposits, something was still overlooked.
We have a partner developed customization that performs a voiding routine on a deposit attached to a sales order in the event of a need to fully cancel the entire sales order (consumers are so fickle).
It seems that this routine has split logic; where it pointed to the GL account of the original deposit for the void entry, but followed the default RM or SOP bank for the checkbook. Now I have a split transaction.
Any ideas?
*This post is locked for comments
All responses (
Answers (
