NOT WORKING - NEW COLUMN (for comparing ledgers inter company)

Discussion in 'Requests' started by SHAHCOAL PVTLTD, Jul 30, 2019.

         
  1. SHAHCOAL PVTLTD

    SHAHCOAL PVTLTD New Member


    Dear All,

    After i installed the TDL given below the inter company ledger comparison is not working (which is done through new column )

    the last tdl i added was

    Expand Info & Width Increase
    [System : Formula]
    isEnhancedFieldsOn: Yes

    [#Field: EI Desc]
    Add: Option: Enhanced Ei Desc: @@isEnhancedFieldsOn

    [!Field : Enhanced Ei Desc]
    Add: Max: 51
    Add: Width: 50

    Option: Ei Desc Print: Not $$inPrintMode
    Add: Lines: 0
    Add: Align: Justified

    [!Field : Ei Desc Print]
    Add: FullWidth: Yes
    Add: Lines: 1


    [#Field: DSP VchNumberTitle]
    Add: Option: Enhanced VNum: @@isEnhancedFieldsOn

    [#Field: DSP VchNumber]
    Add: Option: Enhanced VNum: @@isEnhancedFieldsOn

    [#Field: BILLRef]
    Add: Option: Enhanced VNum: @@isEnhancedFieldsOn

    [#Field : VCH Short Title]
    Add: Option: Enhanced VNum: @@isEnhancedFieldsOn

    [#Field: VCHBILL Name]
    Add: Option: Enhanced VNum: @@isEnhancedFieldsOn

    [#Field: VCH Ref]
    Add: Option: Enhanced VNum: @@isEnhancedFieldsOn

    [!Field : Enhanced VNum]
    Add: Width: 25


    [#Field: Voucher Name Field]
    Add: Option: Enhanced Voucher Name: @@isEnhancedFieldsOn

    [#Field: Master Name Field]
    Add: Option: Enhanced Voucher Name: @@isEnhancedFieldsOn

    [#Field: Item Name Field]
    Add: Option: Enhanced Voucher Name: @@isEnhancedFieldsOn


    [!Field : Enhanced Voucher Name]
    Add: Width: 70
    Add: Max: 70

    [#Field : VCH Narration]
    Add: Option: Enhanced Narration: @@isEnhancedFieldsOn

    [!Field : Enhanced Narration]
    Add: FullWidth: Yes
    Add: Max: 150
    Add: Lines: 3

    [#Collection: List of Stock Items]

    Use : Alias Collection
    Title : $$LocaleString:"List of Stock Items"
    Type : Stock Item
    Fetch : Name
    Report : Stock Item
    Variable : SStockItem
    Trigger : SStockItem
    IsODBCTable : Yes
    Delete : Format
    Add : Format : $Name,50
    Add : SubTitle : $$LocaleString:"PRODUCT","Part No.", "DESCRIPTION", "Group", "%", "COST", "LSP", "QTY"

    Add: Format :$partno
    Fetch: partno

    Add: Format : $Description
    Fetch : Description

    Add: Format : $parent
    Fetch : parent

    Add: Format : $GSTIGSTRate
    Fetch : GSTIGSTRate

    Add: Format : $Standardcost
    Fetch : standardcost

    Add: Format : $LastSalePrice
    Fetch :LastSalePrice

    Add: Format : $closingbalance
    Fetch :closingbalance

    [#Collection: List of Ledgers]

    Use : Ledger Collection
    Title : $$LocaleString:"List of Ledgers"
    Type : ledger
    Fetch : Name
    Report : ledger
    Variable : Sledger
    Trigger : Sledger
    IsODBCTable : Yes
    Delete : Format
    Add : Format : $Name,50
    Add : SubTitle : $$LocaleString:"LEDGER NAME", "GROUP", "PAN", "GSTIN", "OP BALANCE", "CL BALANCE"

    ;;"Mobile No", - add this above if required
    ;;'Add: Format :$LedgerMobile
    ;;Fetch : LedgerMobil

    Add: Format : $parent
    Fetch : parent

    Add: Format : $IncomeTaxNumber
    Fetch : IncomeTaxNumber

    Add: Format : $PartyGSTIN
    Fetch : PartyGSTIN

    Add: Format : $OpeningBalance
    Fetch : OpeningBalance

    Add: Format : $ClosingBalance
    Fetch : ClosingBalance

    [#Collection : VLedTable]

    Use : Ledger Collection
    Title : $$LocaleString:"List of Ledger Accounts"
    Delete : Format
    Add : Format : $Name,50
    Add : SubTitle : $$LocaleString:"LEDGER NAME", "GROUP", "GSTIN", "CL BALANCE"

    ;;"Mobile No" - add this above if required
    ;;Add : Format :$LedgerMobile
    ;;Fetch :LedgerMobil

    Add: Format : $parent
    Fetch : parent

    Add: Format : $PartyGSTIN
    Fetch : PartyGSTIN

    Add: Format : $ClosingBalance
    Fetch : ClosingBalance

    [#Collection: List of Groups]

    Use : Ledger Collection

    Title : $$LocaleString:"List of Groups"
    Type : Group
    Fetch : Name
    Delete : Format
    Add : Format : $Name,50
    Add : SubTitle : $$LocaleString:"GROUP NAME","MAIN GROUP",
    Add : Format : $parent
    Fetch : parent

    ;;end of file


    PLEASE HELP ME OUT
    THANK YOU


     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In your Inter-company comparision TDL...... put all Column-field width's in terms of percentage........whose total come to 100%.

    e.g. if you have 5 columns....make it 40%+15+15+15+15%

    OR.......

    Un-load the above TDL.
     


  3. SHAHCOAL PVTLTD

    SHAHCOAL PVTLTD New Member


    SIR FIRST I TRIED THIS
    (i put width : and % screen) as shown below "but i got the message that this is a invalid input for this field"

    [#Collection: List of Ledgers]
    Use : Ledger Collection
    Title : $$LocaleString:"List of Ledgers"
    Type : ledger
    Fetch : Name
    Report : ledger
    Variable : Sledger
    Trigger : Sledger
    IsODBCTable : Yes
    Delete : Format
    Add : Format : $Name,50
    Add : SubTitle : $$LocaleString:"LEDGER NAME", "GROUP", "PAN", "GSTIN", "OP BALANCE", "CL BALANCE"

    Add: Format : $parent
    Fetch : parent
    Width : 50% Screen
    Add: Format : $IncomeTaxNumber
    Fetch : IncomeTaxNumber
    Width : 8% Screen
    Add: Format : $PartyGSTIN
    Fetch : PartyGSTIN
    Width : 12% Screen
    Add: Format : $OpeningBalance
    Fetch : OpeningBalance
    Width : 15% Screen
    Add: Format : $ClosingBalance
    Fetch : ClosingBalance
    Width : 15% Screen

    -----------------xx-----------------------

    then i tried a different way i put the values as under
    Add: Format : $parent,50
    Fetch : parent
    Add: Format : $IncomeTaxNumber,8
    Fetch : IncomeTaxNumber
    Add: Format : $PartyGSTIN,12
    Fetch : PartyGSTIN
    Add: Format : $OpeningBalance,15
    Fetch : OpeningBalance
    Add: Format : $ClosingBalance,15
    Fetch : ClosingBalance
    ---------------xx-----------------------

    but still no luck.
    Please help this tdl is very helpful and i don't want to unload it.
    please suggest an alternate solution
    thank you.
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Width has to be defined in the FIELD, not the COLLECTION.

    You have made a comparision report.... so in your report...whatever the fields are there........in that you need to define percentage.
     


Share This Page