8 Replies Latest reply: Nov 1, 2017 5:43 AM by Mark Little RSS

    create a new field

    sagara perera

      Dear All

       

      I need to create a new field  namely  DESCRIPTIONusing the below given field 

                “BAL_ACCT_CODE AS CACC

       

      BAL_ACCT_CODE AS CACC comprise the appended accounts codes, which should bear the following particulars. In addition by using the codes 10100 minus 15600 we should arrive at the wording “Total_Net_Assest”, ensure that the “Total_Net_Assest” wording should appear in the “DESCRIPTION’ field.

       

       

      AN ESSENTIAL FIELD “DESCRIPTION’

      BAL_ACCT_CODE AS CACC

      AMOUNT

      FIXED ASSETS

      10100

      626,043,313

      DEPRECIATION

      15600

      -8,282,434

      TOTAL_NET_ASSEST  (10100-15600)

      634,325,747 

      INVESTMENT EXTERNAL

      22035

      2,490,625

      STATIONERY STOCK

      30010

      25,900,833

      ADVANCES & PRE-PAYMENTS

      33000

      31,575,750

      TRADE DEBTORS

      31000

      4,122,317,827

      RETURN CHEQUES

      32000

      17,401,462

      STAFF LOANS

      32600

      42,619,432

       

       

      MY SCRIPT

       

       

      BS:
      LOAD BAL_BRANCH_CODE AS BCOD,
      BAL_ACCT_CODE AS CACC,
      //BAL_ACCT_YEAR AS TRAN_DATE,
           DATE(Floor(MonthStart(MakeDate(BAL_ACCT_YEAR,BAL_ACCT_PERIOD)))) as TRAN_DATE,
      //BAL_ACCT_PERIOD,
           BAL_HC_DBBAL,
      BAL_HC_CRBAL
      FROM
      G:\SGR\QLICK VIEW\QVD\BLSHEET_CU_GL_BALANCE.QVD
      (
      qvd);

       

       

       

      Sagara