Not sure how it happened, but under "Payment Application", I have an unapplied document balance that shouldn't be there. If I apply the amount, the Customer AR balance will be incorrect. Using the normal processes, I've tried to apply the document balance insuring the customer AR balance is correct along with the general ledger balances for the accounts involved, and haven't been successful. At this point, I need to use some SQL to fix the transaction in the ARDOC table to get rid of the unapplied document balance, and fix any related tables. Any suggestions?
Thanks,
Mark
*This post is locked for comments