I'm using the Integration Manager to upload files to GP. When I get an error, (such as the document number is the same) I'll delete the created batch and start over. When I delete the batch, it is deleted from the General Ledger and Payables. But when I go double check, the transactions are still posted to Payables. Every time I run Inegration Manager and try to void a batch this happens. What am I doing wrong?
*This post is locked for comments
It sounds like you're hitting delete but in reality the system is posting the batch. I've never seen anything like that before.
I would turn on the Dex SQL log, to see what is going on when you click "delete."
To turn on the log, exit from GP and then browse to your installation folder, usually C:\Program Files (x86)\Microsoft Dynamics\GP\data. In the Data folder, locate the dex.ini folder and right-click, then choose Open with Notepad (or 'edit,' if available).
In Notepad, change the following three lines from =FALSE to =TRUE:
SQLLogSQLStmt=FALSE
SQLLogODBCMessages=FALSE
SQLLogAllODBCMessages=FALSE
Save & close the dex.ini, and then relaunch GP. Import a batch of payables and then pull up the batch in the Payables Batch Entry window. Prior to clicking "delete," browse back to that C:\Program Files (x86)\Microsoft Dynamics\GP\data folder, and delete the DEXSQL.log file you see there. Now click the delete button in the Batch Entry window, but do nothing else. Back in the same Program Files\MSD\GP\data folder, the DEXSQL.log should have been recreated.
Post the contents of that file here, and we'll see if we can figure out what is happening.
Once you've captured a log file, please be sure to turn the logging off by editing that file, to reset the =TRUE back to the original setting of =FALSE.
Finally, does this happen every time, on every workstation? Or is it sporadic, or limited to a particular user or to a particular workstation?
If I hit delete, the batch disappears but somehow the transactions are still posted to the vendor accounts. I then have to 'void open transactions'.
When you use Integration Manager to integrate some PM invoices a batch will be created in that module; hitting delete in Payables Batches should remove all entries from PM.
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
