Linking a Commodity Code to a Warehouse

Linking a Commodity Code to a Warehouse

This is the process to add a commodity to a warehouse.


Step by Step Instructions:
1.)  Go to INVN (Inventory Maintenance) Table
2.)  Select the appropriate warehouse
3.)  Select Insert
4.)  Select the commodity code you are looking to tie in


    • Related Articles

    • QRG - Using Excel to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1CzcUic3qykVURnFS1yrkN-roU5YvQzJv/view ) Introduction To access State Data Warehouse using excel or other tools, create a DTS helpdesk ticket, they need to install ...

    • Data Warehouse - Data Dictionary

      Information Data Warehouse has published a Data Dictionary, sharing all of the State Datawarehouse Tables and Fields. Some tables have details and joins to use, where other less commonly used tables simply share the field names. This should be ...

    • QRG - Using Access to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1jcxI35q1Rpz_gLCbOonQaWSgO51duFq7/view ) Introduction Open Database Connectivity (ODBC) database. Similar to the state data warehouse, you’ll need to install an ...

    • Searching by Commodity Line number

      This enhancement is applicable to sites that use the Shopper (SHOP) table and would like the ability to search transactions on the SHOP page by the Commodity Line Number from the source of Master Agreements. Previously, the Shopper (SHOP) page ...

    • Adding an activity code

      Usually someone in your department should be able to add the Activity. Here are the steps: 1. Go to the Activity table by entering ACTV in the FINET search field at top of screen. 2. Do a search for any code - enter the Fiscal Year and Department for ...