web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Adjustment- ...
Microsoft Dynamics GP (Archived)

Inventory Adjustment- Who made it?

(0) ShareShare
ReportReport
Posted on by dmacintosh 1,145

Hello Everyone,

I have had a user approach me in regards to inventory adjustment tracking. When an adjustment is made, we typically identify the batch with a user identifier. In this instance, the batch name was just 'Damage' and thus provides us with little insight on who completed the adjustment.

I have looked through all the reports and found no way to identify the user. I have also attempted to look into the inventory tables to perhaps find a field USERID but to no avail.

Does anyone know of a way that I can find what user made the adjustment if I have the Document Number, Audit Trail or Receipt?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Jeff LaPointe Profile Picture
    Jeff LaPointe 1,022 on at
    RE: Inventory Adjustment- Who made it?

    Tracking user activity is not an 'out-of-the-box' functionality of Dynamics GP.  There is a module called Audit Trails which allows you to assign audits to windows/tables and will track user access and changes to windows and information going forward, but this module would not be a able to audit any past activity posted prior to installation.  

    The IV10000 does have the column MDFUSRID used for the user who modified the entry and the PTDUSRID for user who posted the trx, but that would help if the trx is no longer in the work table.

    The USERID column is in the IV10004, IV30004, IV40100 and IV50200 but these tables would not assist you with this issue.

    Hope this helps.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Adjustment- Who made it?

    In addition to the essential information above, this is a link that may help you find the "user who posted".

    Inventory Transaction - User Who Posted !

  • dmacintosh Profile Picture
    dmacintosh 1,145 on at
    RE: Inventory Adjustment- Who made it?

    I attempted to follow that but unfortunately I do no have the SEE30303 table.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Adjustment- Who made it?

    I have included a helping note at the end of the article, which considers changing the WHERE condition if you don't have an HITB (SEE30303). Replace the '#IVDocumentNumber' with the inventory document number.

    Remember, it will give you the user who "posted", not the user who "created" the transaction.

    SELECT * FROM
    (
        SELECT  DISTINCT
                SOURCDOC AS SourceDocument,
                ORGNTSRC AS IVDocumentSource,
                ORCTRNUM AS IVDocumentNumber,
                JRNENTRY AS JournalEntry,
                OPENYEAR AS TransactionYear,
               'Opean Year' AS 'Open/Closed Year',
                LASTUSER AS LastUser,
                LSTDTEDT AS LastEditDate, 
                USWHPSTD AS UserWhoPosted,
                ORPSTDDT AS PostingDate
        FROM GL20000
        UNION ALL
        SELECT  DISTINCT
                SOURCDOC,
                ORGNTSRC,
                ORCTRNUM,
                JRNENTRY,
                HSTYEAR,
                'History Year',
                LASTUSER,
                LSTDTEDT, 
                USWHPSTD,
                ORPSTDDT           
        FROM GL30000
    )   AS A    

        WHERE A.IVDocumentNumber = '#IVDocumentNumber'


  • Jeff LaPointe Profile Picture
    Jeff LaPointe 1,022 on at
    RE: Inventory Adjustment- Who made it?

    That's a great script, thanks Mahmoud.  Just another thought to consider:  The LASTUSER field may have no user ID if it originated from another module and the posting was set to Post To and Through General Ledger.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Adjustment- Who made it?

    The last user id shall give the user id who last edited this Transaction. In the case you mentioned above, the user who posted the IV transaction is stored in User who posted. On the other hand, the user who last edited the transaction (if any) before posting, shall be stored in Last Edit User.

  • dmacintosh Profile Picture
    dmacintosh 1,145 on at
    RE: Inventory Adjustment- Who made it?

    I apologize for misreading your posting. However, I am unable to find this Inventory Adjustment using this script. I am able to find others, just not this particular one.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Adjustment- Who made it?

    It should be posted .. isn't it ?

  • dmacintosh Profile Picture
    dmacintosh 1,145 on at
    RE: Inventory Adjustment- Who made it?

    I am looking for ADJ0217824

    I have replaced the original where statement with 

    WHERE A.PostingDate = '2014-01-15 00:00:00.000' AND A.IVDocumentNumber like 'ADJ%%%%%%%'

    ORDER BY A.IVDocumentNumber

    I then look for the number manually, it would seem that the last ADJ on 2014-01-15 was ADJ0217823.

    The next ADJ on 2014-01-16 was ADJ0217825.

    Very odd behavior.     

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Adjustment- Who made it?

    Try looking for this adjustment specifically without including the posting date. Only the IV document number

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans