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

    • Error: Modification of Extended Description for this Commodity Code marked as inventory requires an override. (A8590)

      I received Error "A8590 - Modification of Extended Description for this Commodity Code marked as inventory requires an override" even though I have not modified the "Extended Description" This particular error has been reported by multiple agencies ...

    • 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 ...