Share
ReportI have a "batch" hanging out there that I can't open because it has no ID. Can someone help me please?
*This post is locked for comments
You’re offline. This is a read only version of the page.
155
I have a "batch" hanging out there that I can't open because it has no ID. Can someone help me please?
*This post is locked for comments
I'm going to second the vote for financial reconcile, but ONLY if it is a GL entry you're trying to find. Otherwise, run checklinks on the 'WORK' transactions of the subsidiary batch.
Kind regards,
Leslie
Richard is right - typically the Check Links maintenance routine will create a Check Links batch when run against the financial tables. Just click on series > financial on the left, choose insert all and then click process. Make sure you have a backup before running this process.
If you want to do this within GP I would suggest running Check Links(MS Dynamics GP->Maintenance->Check Links). Run this on all series. Hopefully you will see a line about batch header being recreated. Always do a backup of your company database prior to running check links.
Which module did it originate in, and which module are you trying to open it in?
Assuming you are familiar with SQL, I would recommend taking a look at this article and running the SELECT statements to see if it yields any results.
support.microsoft.com/.../en-us
Between this KB and Mahmoud's scripts you should be good to go.
You may want to manually update the empty batch-id record. For the financial series, here are the tables to check:
The following scripts will retrieve the records with the empty batch-id field;
SELECT * FROM dbo.GL10000 WHERE [BACHNUMB] = '' SELECT * FROM dbo.GL10001 WHERE [BACHNUMB] = '' SELECT * FROM dbo.SY00500 WHERE BACHNUMB = '']
Once the records are identified, you need to manually updated these records with a specific batch id. You can proceed with posting the batch from the application level.
If you don't have the proper knowledge to handle such update statement, consult your partner. Never forget that the "back up" is a must.
Your feedback is highly appreciated,
All responses (
Answers (
