1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Excise Master information

Discussion in 'Tally Developer' started by Taufeeq Shaikh, Sep 4, 2015.

    
  1. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Dear All.

    Am hereby trying to fetch the Statutory details of Excise Master of the Current Company. But unable to achieve the result. Address is coming but the rest of details are not coming.

    [Field : Exctrs]
    Use : Name Field
    Set as : $ExciseRangeCode:Company:##SvCurrentCompany

    [Field : Exctrs1]
    Use : Name Field
    Set as : $ExciseRange:Company:##SvCurrentCompany


    [Field : Exctrs2]
    Use : Name Field
    Set as : $ExciseRangeAddress:Company:##SvCurrentCompany

    Same way rest all the details of Excise Statutory Master.
     
    Taufeeq Shaikh, Sep 4, 2015
    #1


  2. Mahesh Sethi

    Mahesh Sethi Member


    Dear TRY This...


    [Field: ExciseMfgrInv CmpSTNo]

    Use : Name Field
    Set As : @@CMPLTaxNumber
    Style : Small Bold

    [Field: ExciseMfgrInv CmpCSTNo]

    Use : Name Field
    Set As : $InterStateSTNumber:Company:##SVCurrentCompany
    Style : Small Bold

    [Field: ExciseMfgrInv CmpExciseRegnNo]

    Use : Short Name Field
    Set as : $ExciseRegNumber:Godown:$ExciseUnitName
    Style : Small Bold

    [Field: ExciseMfgrInv CmpSTaxRegnNo]

    Use : Short Name Field
    Set as : $STRegNumber:Company:##SVCurrentCompany
    Style : Small Bold

    [Field: ExciseMfgrInv CmpRange]

    Use : Name Field
    Set As : $ExciseRange:Godown:$ExciseUnitName + @RangeCode + @RangeAddress
    RangeCode : If $$IsEmpty:$ExciseRangeCode:Godown:$ExciseUnitName Then "" +
    Else If $$IsEmpty:$ExciseRange:Godown:$ExciseUnitName Then $ExciseRangeCode:Godown:$ExciseUnitName +
    Else " / " + $ExciseRangeCode:Godown:$ExciseUnitName
    RangeAddress: If $$IsEmpty:$ExciseRangeAddress:Godown:$ExciseUnitName Then "" +
    Else If $$IsEmpty:$ExciseRange:Godown:$ExciseUnitName AND $$IsEmpty:$ExciseRangeCode:Godown:$ExciseUnitName Then $ExciseRangeAddress:Godown:$ExciseUnitName +
    Else " / " + $ExciseRangeAddress:Godown:$ExciseUnitName
    Width : 32
    Style : Small Bold

    [Field: ExciseMfgrInv CmpDivision]

    Use : Name Field
    Set As : $ExciseDivisionName:Godown:$ExciseUnitName + @DivCode + @DivAddress
    DivCode : If $$IsEmpty:$ExciseDivisionCode:Godown:$ExciseUnitName Then "" +
    Else If $$IsEmpty:$ExciseDivisionName:Godown:$ExciseUnitName Then $ExciseDivisionCode:Godown:$ExciseUnitName +
    Else " / " + $ExciseDivisionCode:Godown:$ExciseUnitName
    DivAddress : If $$IsEmpty:$ExciseDivisionAddress:Godown:$ExciseUnitName Then "" +
    Else If $$IsEmpty:$ExciseDivisionName:Godown:$ExciseUnitName AND $$IsEmpty:$ExciseDivisionCode:Godown:$ExciseUnitName Then $ExciseDivisionAddress:Godown:$ExciseUnitName +
    Else " / " + $ExciseDivisionAddress:Godown:$ExciseUnitName
    Width : 32
    Style : Small Bold

    [Field: ExciseMfgrInv CmpCommissionerate]

    Use : Name Field
    Set As : $ExciseCommissionerate:Godown:$ExciseUnitName + @ComsCode + @ComsAddress
    ComsCode : If $$IsEmpty:$ExciseComsnrateCode:Godown:$ExciseUnitName Then "" +
    Else If $$IsEmpty:$ExciseCommissionerate:Godown:$ExciseUnitName Then $ExciseComsnrateCode:Godown:$ExciseUnitName +
    Else " / " + $ExciseComsnrateCode:Godown:$ExciseUnitName
    ComsAddress : If $$IsEmpty:$ExciseComsnrateAddress:Godown:$ExciseUnitName Then "" +
    Else If $$IsEmpty:$ExciseCommissionerate:Godown:$ExciseUnitName AND $$IsEmpty:$ExciseComsnrateCode:Godown:$ExciseUnitName Then $ExciseComsnrateAddress:Godown:$ExciseUnitName +
    Else " / " + $ExciseComsnrateAddress:Godown:$ExciseUnitName
    Width : 32
    Style : Small Bold

    [Field: ExciseMfgrInv PANITNumber]

    Use : Name Field
    Set As : $IncomeTaxNumber:Company:##SVCurrentCompany
    Style : Small Bold

    [Field: ExciseMfgrInv CmpLBTRegnNo]

    Use : Name Field
    Set As : $LBTRegnNo:Company:##SVCurrentCompany
    Width : 32
    Style : Small Bold

    [Field: ExciseMfgrInv ConsigSTNo]

    Use : Name Field
    Set As : @@BuyerTaxNumMfgr
    Width : 12.25% Page
    Style : Small Bold
    Invisible : $$IsEmpty:mad:@BuyerTaxNumMfgr

    [Field: ExciseMfgrInv ConsigCSTNo]

    Use : Name Field
    Set As : $ConsigneeCSTNumber
    Width : 12.25% Page
    Style : Small Bold
    Invisible : $$IsEmpty:$ConsigneeCSTNumber

    [Field: ExciseMfgrInv ConsigEccNo]

    Use : Name Field
    Set As : $TraderConsExciseRegnNo
    Style : Small Bold

    [Field: ExciseMfgrInv ConsigRange]

    Use : Name Field
    Set As : $TraderConsRange
    Style : Small Bold

    [Field: ExciseMfgrInv ConsigDivsion]

    Use : Name Field
    Set As : $TraderConsDivision
    Style : Small Bold

    [Field: ExciseMfgrInv ConsigCommissionerate]

    Use : Name Field
    Set As : $TraderConsCommissionerate
    Style : Small Bold

    [Field: ExciseMfgrInv ConsigNotifyNo]

    Use : Name Field
    Set As : $ExciseNotificationNo
    Style : Small Bold

    [Field: ExciseMfgrInv BuyerSTNo]

    Use : Name Field
    Set As : $TraderConsVATTINNo
    Width : 12.25% Page
    Style : Small Bold
    Invisible : $$IsEmpty:$TraderConsVATTINNo

    [Field: ExciseMfgrInv BuyerCSTNo]

    Use : Name Field
    Set As : $BuyersCSTNumber
    Width : 12.25% Page
    Style : Small Bold
    Invisible : $$IsEmpty:$BuyersCSTNumber

    [Field: ExciseMfgrInv BuyerEccNo]

    Use : Name Field
    Set As : $TraderSuppExciseRegnNo
    Style : Small Bold

    [Field: ExciseMfgrInv BuyerRange]

    Use : Name Field
    Set As : $TraderSuppRange
    Style : Small Bold

    [Field: ExciseMfgrInv BuyerDivsion]

    Use : Name Field
    Set As : $TraderSuppDivision
    Style : Small Bold

    [Field: ExciseMfgrInv BuyerCommissionerate]

    Use : Name Field
    Set As : $TraderSuppCommissionerate
    Style : Small Bold
     
    Mahesh Sethi, Sep 7, 2015
    #2


Share This Page