75
I have a client who is needs to make an entry to adjust the customer balance in AR without hitting the GL. A transaction errored out so the GL entry posted and did not hit AR customer balance. Is there a way to fix this, even in the back end through SQL?
A slight correction. Run check links against
Receivable Transaction History Files
Receivables Open Transaction Files
This will rebuild your RM Key Master table
It would be important to find out how far this posting went. It would be helpful if you used David Musgrave's SQL search tool to find which tables, if any, contain this document. You could also try rebuilding the RM Key Master table by doing this:
1) Perform a backup
2) DELETE RM00401
3) Run check links on sales open and historical logical tables
Now using sales inquiry see if the document was recovered. If not, turn off AR posting through the GL. Enter your transactions. If you receive a message about duplicate document number use the results of the SQL search to remove the duplicate records. Turn on posting through GL when completed. It would be best to do this while no one is in GP.
Have you run the GP RM Check Links and RM Reconcile utilities? If it doesn't fix the issue, it often provides clues to what is involved.
I'm new to GP especially AR module. Thank you for your options, I will work with my client.
They have a couple of options:
1. Create the AR entry, and change the distribution entries to use the same GL account on both DR and CR - so it is a wash when it arrives to GL, or
2. Reverse the GL entry using the Correct Entry in the GL, then. recreate the AR entry correctly and allow it to hit GL. (You may need to change a setting the GL setup window to allow voiding or correcting entry from the submodule).
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (