I created one return and posted it. In my posting Journal that Its Credited 10300 but Debit "nothing" it says Account not Found. It should have debited my 42280 account. I went into the Item Maintenance and saw that under Return there was not Account entered. So I know what happened there, but why did the batch post, and not go into Batch Recovery??? How can I fix it?
*This post is locked for comments
I think possibly the sales batch posted, but not the GL batch. When you are looking at the distribution, are you drilling into the distributions from the document inquiry, or are you drilling into the actual journal entry from the Detail Inquiry window (Inquiry >> Financial >> Detail)?
The third Distrubution line posted with a Blank Account
10300 Recv CR $693.69
10055 Sales DB $692.19
"Blank" Sales DB $1.50
and yes the batch is posted.
Lynn has provided essential details which you can consider to troubleshoot your issue.
Although, I may have a simple question. The standard case is that the system will not allow such behavior. Could you please check whether this document is posted on the inquiry window, please reach out the distribution, is it empty ?
The standard behavior for the system is to print out the report with an error message stating that accounts was not found, and prevent the posting.
Another scenario that I have in mind, if you have account level security, the message "account was not found" will show for the user who doesn't have access to this account. Supposing that another user (with an access) posted the document, it will post normally with no errors at all.
Your feedback is highly appreciated,
You may need your GP consultant to help clear up some data in SQL for you.
First, though, see if the system will let you void the transaction. Also confirm that the GL batch was, indeed, posted all the way through by looking at Inquiry>>Financial>>Detail for account #10300. Be sure you actually see the credit to this account in your GL. It would be extremely unusual for GP to allow an unbalanced entry to post into the GL.
If it is not in the GL, see if there are any unposted batches the financial series. You might be able to edit the entry prior to posting, so that you can enter the correct offsetting account number. If it isn't in the GL, you might be tempted to just manually create the corresponding journal entry that should have been created automatically, but I have a feeling that this transaction will come back to haunt you.
You can also try running Check Links on all series: Microsoft Dynamics GP>>Maintenance>>Check Links. Click the "ALL>>" button to insert all financial tables, then change to the next series in the dropdown list and click ALL>> again. Repeat that for all series. Have all users exit GP and run the process.
If none of that helps, I recommend reaching out to your GP consultant so they can take a look at your data and make a more precise recommendation.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
