Open Forum

Expand all | Collapse all

Inventory Reason Codes

  • 1.  Inventory Reason Codes

    Posted 17 days ago
    We are deciding if we should use the inventory reason codes for our inventory adjustments / transfers.

    I would like to be able to use Smartlist to pull by a date range and by reason code.  I cannot seem to find the reason code used in the inventory adjustment / transfer - only the set up reason code table IV40300.  What am I missing?

    ------------------------------
    Debbie Janssen
    Accounting (AR and AP) and GP Maint
    Sure Controls Inc.
    Greenville WI
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Inventory Reason Codes

    TOP CONTRIBUTOR
    Posted 17 days ago

    Hi @Debbie Janssen,

    What tables are you looking at or what default SmartLists are you using?

    The field itself is contained in the IV10001 (work ​transaction line detail) and the IV30300 (transaction amount history line detail).  It is called Reason_Code in each.

    Based on a quick review of the InventoryTransactions view (which is used in the default inventory transactions smartlist), I do not see reason code included.  You may need to create a SmartList that combines the necessary tables (IV10001, IV30300, etc.) based on what you need in order to be able to reference the Reason Code.

    Thanks,


    Samantha



    ------------------------------
    Samantha Higdon ,CPA,CGMA
    Consultant
    Lagom, LLC
    Carmel IN
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Inventory Reason Codes

    Posted 17 days ago
    Thank you!  I looked and did not find table IV10001.

    Thank you again.


    ------------------------------
    Debbie Janssen
    Accounting (AR and AP) and GP Maint
    Sure Controls Inc.
    Greenville WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


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