0 Replies Latest reply: Aug 22, 2017 7:26 AM by shweta gupta RSS

    Flagging for stock

    shweta gupta

      Hi Fellas,

       

      I am working on Stock Calculations

      There is stock scanning done by the salesperson i.e how much stock is left to the dealer.

      Now I need to check how much product is being sale out every month. Since how long a product is not being sold from a particular dealer.

       

      My data set is like this

      Stock6:

      LOAD

          dealer_code_c,

      //    account_id2_c as Account_id,

          MaxStockDate,

          fe_ref_num,

          Stock_ID,

          StockDate,

          Stock_Name,

          SerialNo,                          // different everytime, can be same if this is scanned again at the same dealer

          aos_products_id_c,

          Deleted_Stock,

          Stockqty,

          flow_type,

          account_type,

          stock_type_c,

        

       

      Can we flag serial number as yes(if scanned last month) no(if not scanned earlier) on the basis of this month and last month

      that is, If  at dealer 1 serial abc is scanned on 12-07-2017 and        //No
                                                 abc is scanned on 08-08-2017 // old stock  //yes

                         at Dealer1 serial cde is scanned on 07-07-2017  stock sold if not available on next dates

                                           serial efg is scanned on 09-07-2017    New stock.

       

      Can someone suggest anything! Ihope i have written my requisite well.