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 11 days ago
    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
    ------------------------------


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

    TOP CONTRIBUTOR
    Posted 11 days ago
    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
    ------------------------------



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

    Posted 10 days ago
    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
    ------------------------------



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

    TOP CONTRIBUTOR
    Posted 10 days ago
    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
    ------------------------------



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