2 Replies Latest reply: May 15, 2014 10:07 AM by fatboy02 _ RSS

    stumped

    fatboy02 _

      Below is a sample from a ‘slow move’ inventory report.  I need to capture the following fields

       

      1.     Plant

      2.     Profit Center

      3.     Material #

      4.     Description

      5.     SLoc—this is where it gets tricky for me.  In the sample there are 3 storage locations (1111, 1005 and 9001) but there are others that appear later in the report.  I am only concerned with capturing the quantity that is in 9001 and need to capture a zero if 9001 does not appear.

      6.     Slow Move Value

      7.     Slow Move Qty

       

      Thanks for any suggestions or tips.  

       

       

       

      Plant MRP Profit Ctr Dv Matl #             Old Matl #         UOM MRP Reorder Pt     Price             Price Unit         Total Qty   Req Qty(Open SO)   Rec Qty(Open PO)          Avail Qty 

                              Description                           SLoc DF   Un Rest Qty  Last Rec Date     Last Con Date    6 Mth Usage        3 Mth Usage    Slow Move Value      Slow Move Qty 

      -


      -


      0003 003 1050510002 10 100003824          100003824          LB  PD             0.0          0.19              1             2,000                  0                  0              2,000 

                              CHEM, MICRO FLY ASH, 50 LB SACK                                                                                380              2,000 

                                                                    1005                   0     01/2009        01/2009                  0                  0                                                                               

      9001               2,000     01/2009        04/2009                  0                  0                                      

      -


      0003 003 1050510002 10 101477695          101477695          LB  PD             0.0          4.56              1               500                  0                  0                500 

                              CHEM, DRYAD-766, 50 LB SACK                                                                                456                100 

                                                                    1005                   0                    08/2009                  0                  0                                                                               

      1111                 500     12/2009        12/2009                400                  0                                      

      -


      0003 003 1050510002 10 101791534          101791534          LB  PD             0.0          0.92              1               836                  0                  0                836 

                              CHEM, FDP-C925-09, 44 LB BAG                                                                                769                836 

                                                                    9001                 836     10/2009                                 0                  0                                      

                                  0                  0                                      

      /code

        • stumped
          Grant Perkins

          Hi Rob,

           

          Assuming you are using a 2 or 3 line sample for your detail template ....

           

          In line 2 or 3, your choice, set up a field in the (Un Test) Qty column to capture the quantity and then in the advanced properties set the 'Start field on value to be a preceding string of he location you want - in this case 9001. Call the field something like 9001 Qty.

           

          Grab any other fields you want.

           

          The table should then show values where 9001 exists an no value in the field where it does not - you should be able to set an empty field to display 0 as a value.

           

          The last 2 fields seem to be for the entire record at all locations (?) in which case they can just be reported I guess.

           

          Does that help?

           

           

          Grant