Share
ReportIs there a way to show the username of the person who posts an inventory batch? When we run the smartlist, the posted user ID is blank.
*This post is locked for comments
You’re offline. This is a read only version of the page.
Is there a way to show the username of the person who posts an inventory batch? When we run the smartlist, the posted user ID is blank.
*This post is locked for comments
I was able to take the second query you posted and add some more columns to make it useful.
Thanks for your help
That's totally strange ! Can you please replace the WHERE condition as follows;
WHERE ORDOCNUM = '#IVDocumentNumber'
The first query you posted returns nothing even if I remove the where statement.
Nope, that didn't work either...blank
Haha, no I never looked at the query that close. Let me try with the number in there
Carl,
are you typing a specific inventory document number in the ORCTRNUM ?
For instance, ( WHERE ORCTRNUM = '00000000000000118' ) ?
That is also empty
Okay then, run the following statement;
SELECT JRNENTRY AS JournalEntry,
DEBITAMT AS DebitAmount,
CRDTAMNT AS CreditAmount,
LASTUSER AS LastUser,
LSTDTEDT AS LastEditDate,
USWHPSTD AS UserWhoPosted,
ORPSTDDT AS PostingDate,
SOURCDOC AS SourceDocument,
ORGNTSRC AS IVDocumentSource,
ORCTRNUM AS IVDocumentNumber
FROM GL20000
WHERE ORCTRNUM = '#IVDocumentNumber'
No, the SEE30303 table is empty
In your Dynamics GP, do you have SEE30303 table populated ? If you run the SELECT * FROM SEE30303, would it return any result at all ?
If it is populated, have you filled out the required parameter in the script, your IV Document Number ?
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
