You’re offline. This is a read only version of the page.
3,795
There is a GL batch appear in SY00500, but the batch do not appear in Dynamics GP (Transactions>Financial>Batch). Even after Checklink for all tables for Financial and Sales. I have also clear the ACTIVITY, SY00800, SY00801, DEX_LOCK, DEX_SESSION. The missing batch is highlight in yellow in the below screenshot.
http://img18.imageshack.us/img18/6175/20100603071251.png
This batch is from a posted Sales Return and this transaction appear in RM but not in GL. The SOP setup is Post Through GL.
Please advice and many thanks in advance.
This issue is from the post in http://community.dynamics.com/forums/t/35575.aspx
*This post is locked for comments
Thank you so much Sagi88,
After executed your suggested first SQL query, the batch is now appear in the Master Posting and i can post this batch, even though it is not appear in Transaction>Financial>Batch.
Many Thanks again to Sagi88.
Hi again.
The series is corrupt on the batch header:
If upou are comfortable with SQL execute the query UPDATE SY00500 SET SERIES = 2, BACHFREQ=1 where BACHNUMB = `SLSTE00000218` AND SERIES = 0
(The batch should come back to Financial and you should be able to post it)
If not do the following:
Gto Financial - Transactions - General and select the journal entry.
With the jouronal entry displaying change the batch id (add a -1 at the end).
You will be prompted to add this batch, - add it and the save the JE to the new batch id.
Since the journal entry was genetrated from sales you will not lose the link to the original entry and the originaal sales journal that generated it.
Post the new batch.
The following SQL statement will need to be executed at some time - Delete from SY00500 where BACHNUMB = `SLSTE00000218` AND SERIES = 0
to remove the bad record but your records should be fine.
Let me know if this corrects the problem (A backup first is sugested when you execut sql statements)
Hi, Sagi88, thank you for reply.
I have done the Reconcile (Utilities>Financial>Reconcile) but no error found.
There is nothing appear in the Batch Recovery.
Routine>Master Posting, the batch is also not listed there.
I can find this batch in Smartlist>Financial>Account Transaction, and this batch is still not yet post. But if i post it, I need to delete the batch ID, but then, if it is posted without Batch ID, then it may lost the information about this Journal transaction is coming from Sales module.
Please advise. Thank you.
Hi William.
Tha batch definetly seems to be at the GL posting phase and not at the Sales phase.
Have you tried Financial - Utilities - Reconcile and reconciling the batch?
Verify that the batch is not in batch recovery.
If you go to Administration - Routines - Master Posting is the batch available for posting?
Also - Using Smartlist - GL Transactions - do you see the transaction - displaying. If yes check the status of the journal entry - you may be able to switch the batch on it and post.
hope one of these helps
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (