Open Forum

Expand all | Collapse all

Who posted an inventory transaction without a batch ID

  • 1.  Who posted an inventory transaction without a batch ID

    TOP CONTRIBUTOR
    Posted Jul 10, 2019 08:20 AM
    I am trying to find a way to view who posted an inventory transaction, when a batch ID was not used. I can see all inventory transactions on the IV30200 and IV30300 tables. I am not sure of any other tables that will let me know who posted the transactions. Is there a way to see who posted the inventory transactions, looking at any other tables?

    ------------------------------
    Chase Landorf
    Director of I.T.
    Ideal Deals, LLC dba Ideal Aluminum Products
    Saint Augustine FL
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Who posted an inventory transaction without a batch ID

    TOP CONTRIBUTOR
    Posted Jul 10, 2019 09:31 AM
    If you are using bins, IV30004 has the user id. Also, there is a view called InventoryTransactions that may or may not be useful.

    ------------------------------
    Mark LeRette
    Application System Analyst II
    Muscatine Power and Water
    Muscatine IA
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Who posted an inventory transaction without a batch ID

    Posted Jul 11, 2019 09:31 AM
    Have you tried looking at the GL transaction that is generated when the IV transaction is posted. The transaction should have stopped at the GL in an unposted batch and I think the user that 'created' that transaction would be the user that posted the inventory transaction without a batch.

    ------------------------------
    Rebecca Redman
    Business Systems Administrator
    PANDORA Jewelry
    Columbia MD
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Who posted an inventory transaction without a batch ID

    GPUG ALL STAR
    Posted Jul 11, 2019 09:58 AM
    Second @Rebecca Redman with checking the GL.
    If it is in series post or anything, you should see the created user and/or the transaction ID may reference the user in the naming.
    If it was related to manufacturing, it should pull in a reference back to an MO# which you could review the activity on as well to find user history.
    ​​

    ------------------------------
    Aleiha Hanson
    Royal Basket Trucks, Inc - IT Manager
    GPUG Milwaukee WI Chapter Leader
    ahanson@royal-basket.com
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role