jagomart
digital resources
picture1_Inventory Excel Sheet 32547 | Inventoryreporttoolkit


 208x       Filetype XLS       File size 0.06 MB       Source: oklahoma.gov


File: Inventory Excel Sheet 32547 | Inventoryreporttoolkit
report name report description information retrieved prompts execution category module server cycle type navigation material putaway plan by staging id this reports displays each item and item id inventory business ...

icon picture XLS Filetype Excel XLS | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
                                                 Report Name                                                     Report Description                                          Information Retrieved                                      Prompts                        Execution  Category Module                               Server
                                                                                                                                                                                                                                                                          Cycle                             Type                              Navigation
                            Material Putaway Plan by Staging ID                               This reports displays each Item and                                    * Item ID                                         * Inventory Business Unit  As needed                                                 Inventory          PSNT           Inventory>Putaway Stock>Review Plan>Click print button (top right hand corner)
                                                                                              putaway information for a given staging id                                                                              *                                           * 
                                                                                              that is waiting to be moved into inventory.                            Dmensions                                     Putaway Staging ID     
                                                                                                                                                                                                                 * Lot 
                                                                                                                                                                     ID                                                   
                                                                                                                                                                                                             * User 
                                                                                                                                                                     ID                                                   
                                                                                                                                                                                                          * Serial ID 
                                                                                                                                                                                                                           
                                                                                                                                                                                                     * Quantity       
                                                                                                                                                                                                                           
                                                                                                                                                                                                 * UOM                
                                                                                                                                                                                                                           
                            Replenishment Register                                            This report displays all replenishment                                 * Replenish ID                                * Business Unit                                   As needed                              Inventory          PSNT           Inventory>Replenish Inventory>Manage Replenishment Request>Click print button 
                                                                                              activies of a particular replenisment type by                                                    *                                                                                                                                              (top right hand corner)
                                                                                              replenishment ID.  Does not run for a                                  Replenish Type                              
                                                                                              certain replishment ID.                                                                                                * 
                                                                                                                                                                     Item ID                                           
                                                                                                                                                                                                                   * 
                                                                                                                                                                     Description                                    
                                                                                                                                                                                                                    * 
                                                                                                                                                                     Process Date                                 
                                                                                                                                                                                                                  * 
                                                                                                                                                                     Status                                            
                                                                                                                                                                                                                   * 
                                                                                                                                                                     Quantity                                         
                            Material Issue Document                                           This reports displays details about a                                  * Business Unit                               * Inventory Busines Unit   As needed                                                     Inventory          PSNT           Inventory>Fulfill Stock Orders>Stock Requests>Create/Update Stock 
                                                                                              material stock request.                                                                                                *                                         *                                                                              Request>Stock Request Summary
                                                                                                                                                                     Demand Source                             Order Number
                                                                                                                                                                                                                   * 
                                                                                                                                                                     Source BU                                     
                                                                                                                                                                                                                     * 
                                                                                                                                                                     Order Number                               
                                                                                                                                                                                                                    * 
                                                                                                                                                                     Order Line                                     
                                                                                                                                                                                                                     * 
                                                                                                                                                                     Schedule Line                                
                                                                                                                                                                                                                   * 
                                                 Report Name                                                     Report Description                                           Information Retrieved                                       Prompts                        Execution  Category Module                                Server
                                                                                                                                                                                                                                                                             Cycle                            Type                               Navigation
                            Shipping Document                                                  This report is a copy of the orders and                                * Origin                                           * Business Unit                 As needed                                            Inventory           PSNT           Inventory>Fulfill Stock Orders>Shipping Reports>Shipping Document
                                                                                               order lines shipped in a specific shipping                                                                                 *    * Shipping ID
                                                                                               ID.                                                                    Destination                                    
                                                                                                                                                                                                                       * 
                                                                                                                                                                      Business Unit                                
                                                                                                                                                                                                                    * 
                                                                                                                                                                      Shipping ID                                    
                                                                                                                                                                                                                      * 
                                                                                                                                                                      Ship Line No                                  
                                                                                                                                                                                                                      * 
                                                                                                                                                                      Order Number/InterUnit ID            
                                                                                                                                                                                                                 * 
                                                                                                                                                                      Demand Source/Source BU          
                                                                                                                                                                                                                 * 
                                                                                                                                                                      Order Line                                     
                                                                                                                                                                                                                    * 
                                                                                                                                                                      Schedule Line/Reason Code         
                                                                                                                                                                                                                 * Ship 
                                                                                                                                                                      Date/Ship Time                              
                            Storage Locations                                                  This report displays a list of Material                                * Area/Levels                                  * Business Unit             *  As needed                                                 Inventory           PSNT           Inventory>Maintain Storage Locations>Storage Locations Report
                                                                                               Storage Location Details.                                                                                                     Storage Location           * 
                                                                                                                                                                       * Closed                                         Or Range of Storage 
                                                                                                                                                                                                                              Locations          
                                                                                                                                                                      * Location Type                              
                                                                                                                                                                                                                         * 
                                                                                                                                                                      ASRS ID                                        
                                                                                                                                                                                                                      * 
                                                                                                                                                                      Container Type                              
                                                                                                                                                                                                                     * 
                                                                                                                                                                      Dim UOM                                       
                                                                                                                                                                                                                     * 
                                                                                                                                                                      Height, Width and Length              
                                                                                                                                                                                                                    * 
                                                                                                                                                                      Non Own                                       
                                                                                                                                                                                                                       * 
                                                                                                                                                                      Nettable                                         
                                                                                                                                                                                                                      * 
                                                                                                                                                                      Hold                                               
                                                                                                                                                                                                                     * 
                                                                                                                                                                      Suspend                                        
                                                                                                                                                                                                                   * 
                                                                                                                                                                      Capacity Vol                                  
                                                                                                                                                                                                                      * 
                                                                                                                                                                      Check Weight                                
                                                                                                                                                                                                                            
                                                                                                                                                                         * Physical Cycle                          
                                                                                                                                                                                                                           
                                                                                                                                                                      * Inspection Location                     
                                                                                                                                                                                                                       * 
                                                                                                                                                                      Default Item for this Location         
                                                                                                                                                                                                                            
                                                                                                                                                                       
                                                 Report Name                                                     Report Description                                          Information Retrieved                                      Prompts                        Execution  Category Module                               Server
                                                                                                                                                                                                                                                                          Cycle                             Type                              Navigation
                            Putaway Plan                                                      This report can be ran as part of the auto-                            * Putaway Plan Line Number         * Inventory BU                  As needed                                                           Inventory          PSNT           Inventory>Putaway Stock>Putaway Plan Report
                                                                                              putaway job.  This report displays all of the                                                *                                * All Staging ID                 
                                                                                              items being put away.  Otherwise, the                                  Item ID                                            * Or Specific Staging ID   
                                                                                              report lists all of the items not marked for                                                                              *   * Sort by Storage 
                                                                                              putaway that satisfy the cirterial specified                           Description                                     Location, Item ID, 
                                                                                              on the Putaway Plan page.                                                                                             *       Receiver ID
                                                                                                                                                                     Dimensions                                    
                                                                                                                                                                                                                    * 
                                                                                                                                                                     Lot ID                                             
                                                                                                                                                                                                                    * 
                                                                                                                                                                     User ID                                          
                                                                                                                                                                                                                      * 
                                                                                                                                                                     Serial ID                                         
                                                                                                                                                                                                                     * 
                                                                                                                                                                     Quantity                                         
                                                                                                                                                                                                                      * 
                                                                                                                                                                     UOM                                              
                                                                                                                                                                                                                       * 
                                                                                                                                                                     Putaway Location                          
                                                                                                                                                                                                                   * 
                                                                                                                                                                     Continer ID                                    
                                                                                                                                                                                                                    * 
                            Reconciliation                                                    This report lists discrepancies between the  * Item                                              * Inventory BU                   As needed                                                                   Inventory          PSNT           Inventory>Inventory Counts>Reconcile Inventory Balances>Reconcilation Report
                                                                                              actual count and the quantity expected for                                                    *                               * Event ID
                                                                                              physical inventory and cycle counts.                                   Counting Event ID                         
                                                                                                                                                                                                                       * 
                                                                                                                                                                     Print if Percent Error >=X and 
                                                                                                                                                                     Dollar Error >=Y * Item        * 
                                                                                                                                                                     Staged                                           
                                                                                                                                                                                                                       * 
                                                                                                                                                                     Area Levels                                   
                                                                                                                                                                                                                        * 
                                                                                                                                                                     Serial ID                                         
                                                                                                                                                                                                                  * Lot 
                                                                                                                                                                     ID                                                   
                                                                                                                                                                                                                * 
                                                                                                                                                                     Container                                       
                                                                                                                                                                                                                     * 
                                                                                                                                                                     System QTY                                  
                                                                                                                                                                                                                     * 
                            Slow Moving Inventory                                             This report identifies infequently used                                * Item # and Description                 * Inventory BU                  As needed                                                     Inventory          PSNT           Inventory>Manage Inventory>Reports>Slow Moving Inventory
                                                                                              inventory items.  This report can help your                                                 *                                 * All Items                        
                                                                                              organization reduce inventory costs and                                Standard UOM                               * Single Item                   
                                                                                              system maintenance costs by pointing out                                                *                                     * Range of Items             
                                                                                              items that should be discontinued.                                     Qty Onhand                                    * Sort Cirteria (Number 
                                                                                                                                                                                                                     *      of Transactions, Number 
                                                                                                                                                                     Onhand Value                                 of Units Transacted, 
                                                                                                                                                                                                                   * #      Demand Value 
                                                                                                                                                                     of Demand Transactions                Transacted)             * 
                                                                                                                                                                                                                * # of      From and To Date
                                                                                                                                                                     Demand Units                                
                                                                                                                                                                                                           * Total 
                                                                                                                                                                     Demand Value                               
                                                 Report Name                                                    Report Description                                           Information Retrieved                                      Prompts                       Execution  Category Module                                Server
                                                                                                                                                                                                                                                                          Cycle                            Type                               Navigation
                            Negative Balance                                                  This reports identifies all levels at which a                         * Item ID                                         * Inventory BU                  As needed                                            Inventory          PSNT            Inventory>Manage Inventory>Reports>Negative Balances
                                                                                              given item has a negatvie value.  Negative                                                   *                               * All Items                        
                                                                                              quantities can occur at the inventory                                 Type                                                * Single Item                   
                                                                                              business unit level, at the storage location                                                 *                               * Range of Items    
                                                                                              level, or for an item-lot combination.                                Qty Available                                 
                                                                                                                                                                                                                      * 
                                                                                                                                                                    QTY Onhand                                 
                                                                                                                                                                                                                  * 
                                                                                                                                                                    Qty Owned                                    
                                                                                                                                                                                                                  * 
                                                                                                                                                                    Qty Reserved                                
                                                                                                                                                                                                                     * 
                                                                                                                                                                    UOM                                              
                                                                                                                                                                                                                   * 
                                                                                                                                                                    Lot ID                                             
                            Stock Status                                                      This reports summarizes the availability                              * Item ID/Description                      * Inventory BU                  As needed                                                   Inventory          PSNT            Inventory>Manage Inventory>Reports>Stock Status
                                                                                              and value of stock by item.                                                                                         *        * All Items                        
                                                                                                                                                                    Item Status                                     * Single Item                   
                                                                                                                                                                                                                           * Range of Items
                                                                                                                                                                        * Inv Item                                   
                                                                                                                                                                                                                          
                                                                                                                                                                      * Item Group                                
                                                                                                                                                                                                                          
                                                                                                                                                                     * Item Family                                
                                                                                                                                                                                                                     * 
                                                                                                                                                                    UOM                                              
                                                                                                                                                                                                                   * 
                                                                                                                                                                    Source                                           
                                                                                                                                                                                                                  * 
                                                                                                                                                                    Leadtime                                        
                                                                                                                                                                                                                     * 
The words contained in this file might help you see if this file matches what you are looking for:

...Report name description information retrieved prompts execution category module server cycle type navigation material putaway plan by staging id this reports displays each item and inventory business unit as needed psnt stock review click print button top right hand corner for a given that is waiting to be moved into dmensions lot user serial quantity uom replenishment register all replenish manage request activies of particular replenisment does not run certain replishment process date status issue document details about busines fulfill orders requests createupdate summary demand source order number bu line schedule...

no reviews yet
Please Login to review.