You’re offline. This is a read only version of the page.
5
Hi All,
Please help me to find who processed checks for a voucher in Microsoft Dynamics SL 2011.
Thanks,
DM
*This post is locked for comments
Hello Divakar
I hope you find this thread helpful. I'm checking up to see if you were able to find your information regarding the last user that updated/created a check batch
Best Regards,
Jana MacDonald
Hello Divakar,
Two methods below can get the data you need.
Normally in our process tables the crtd_user and lupd_user fields contain that information.
In Sql Server...In query analyzer on your application db type in Select * from BATCH where batnbr = 'xxxxxxx'
the x's are the batch number of the check batch. The user that created the batch should be present on the record and the last user that updated the batch -of course further processing like POSTING
will update that field for the last updated user.
You can also look at the APADJUST table for adjbatnbr which should be the same as the batnber of rthe check batch.
Another method would be Quick Query of the batch and use the same fields as you would in SQL
Open the AP Transactions Quick Query , right click on any column and a column picker box should come up and you can choose the created user and last updated user
Then you can query by batch which should be the default in the upper RH corner
Good luck!
Jana MacDonald
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
