Error In TDL Ledger Voucher Total & In Normal Ledger Print

Discussion in 'Free Source Codes' started by Rajat Agarwal, Jan 20, 2024.

    
  1. Rajat Agarwal

    Rajat Agarwal Member


    Dear Experts

    There is a difference in adding the opening and closing balance in ledger voucher and opening balance is not fetching the details in Print.

    Secondly there is a Subtraction in NW and Metal it is okay in Ledger Voucher but not fetching in print....Pls help..

    Code:
    ;=========================================LEDGER REPORT FOR PRINT ====================================
    
    [#Line : LV Title]
        Add : Field : After : LEDMailName : LVOpngTitle, LVOpngBal
    
    [Field : LVOpngTitle]
        Info     : "LBS / LBG  :"
        Width   : 15
        Align   : Left
        Color      : Yellow
        Background    : Goodwill3
    
    [Field : LVOpngBal]
        Use     : Number Field
        Set as  : $$Total:NWAmt-$$Total:MAmt
        Width   : 15
        Format  : Decimal:3
        Storage : LDRTOTAL
        Align   : Left
        Color      : Yellow
        Background    : Goodwill3
    
    [System:UDF]
        LDRTotal:Number:6589
     

    Attached Files:

    Last edited: Jan 20, 2024


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Have you defined the TOTAL in Part level (of the Print code) -- if not -- you cannot use the Function $$Total ----
    If appearing in Ledger but not in Print -- means the total has not been defined in the Print code.

    If in your report and the Print-report the Fields are the same -- then use the Field Name to get the values.

    e.g. -- #Fld1 - #Fld2
     


  3. Rajat Agarwal

    Rajat Agarwal Member


    Sir I had already use the total in Part level but unable to take the results...but still $$total function is not working
    Can I send you the code on your email
     


  4. Rajat Agarwal

    Rajat Agarwal Member


    Sir there is difference in closing balance total and why the opening balance is not fetching from LV Part....
    secondly the difference of LBG/ LBS from LV part is not fetching in print....

    the code suing for print is given below:

    [#Line: LV ClosingBalance]
    Add: Line :Before : LVFCThree:DSP VchRDClgTitle

    [Line:DSP VchRDClgTitle]
    Line:DSP VchRDTitle

    [Line:DSP VchRDTitle]
    Invisible : NOT $$InPrintMode
    Fields:Simple Prompt, DSPLPD1, DSPLPD2, DSPLPD3, DSPLPD4
    Local:Field:Simple Prompt:Info:"Closing Balance"
    Local:Field:Simple Prompt:Style:Extra Large Bold
    Local:Field:Simple Prompt:Space Left:6
    Border:Thin top Bottom

    [Field:DSPLPD1]
    Use:Number Field
    Format:Decimal:3
    Space Left:2.7
    Set as:$$Total:GWAmt
    Set Always:Yes

    [Field:DSPLPD2]
    Use:Number Field
    Format:Decimal:3
    Space Left:6.5
    Set as:$$Total:NWAmt
    Set Always:Yes

    [Field:DSPLPD3]
    Use:Number Field
    Format:Decimal:3
    Space Left:3.5
    Set as:$$Total:MAmt
    Set Always:Yes

    [Field:DSPLPD4]
    Use:Number Field
    Format:Decimal:2
    Space Left:6.5
    Set as:$$Total:LbrAmt
    Set Always:Yes

    [#Part: DSP VchTitle]
    Add: Line : Before:DSP VchTitle:DSP VchRVTitle
    Option: JWDSPT : @@IsJewelSft
    [!Part: JWDSPT]
    Total:DSPLD1, DSPLD2, DSPLD3, DSPLD4
    [!Line:JWDSPT]
    Invisible: Not $$InPrintMode
    [Line:DSP VchRVTitle]
    Invisible : NOT $$InPrintMode
    Left Fields:Simple Prompt, DSPLD1, DSPLD2, DSPLD3, DSPLD4
    Right Fields: Medium Prompt, DSP VchLD2
    Local:Field:Simple Prompt:Info:"Opening Balance"
    Local:Field:Simple Prompt:Style:Extra Large Bold
    Local:Field:Simple Prompt:Space Left:6
    Local:Field:Medium Prompt:Info:"Lbs / Lbg :"
    Local:Field:Medium Prompt:Style:Extra Large Bold
    Local:Field:Medium Prompt:Space Right:30

    [Field:DSPLD1]
    Use:Number Field
    Format:Decimal:3
    Space Left:3.7
    Set as:$$Total:LEDNARR
    Style: Normal Bold

    [Field:DSPLD2]
    Use:Number Field
    Format:Decimal:3
    Space Left:7
    Set as:$$Total:LEDNARR1

    [Field:DSPLD3]
    Use:Number Field
    Format:Decimal:3
    Space Left:4.8
    Set as:$$Total:LEDNARR2

    [Field:DSPLD4]
    Use:Number Field
    Format:Decimal:2
    Space Left:7
    Set as:$$Total:LEDNARR3

    [Field:DSP VchLD2]
    Use : Amount Field
    Set as : $$String:$LDRTOTAL
    Width : 15
     

    Attached Files:

    Last edited: Jan 24, 2024


  5. Rajat Agarwal

    Rajat Agarwal Member


    Pls let me know what is the error in this code ..so that the new opening balance in ledger voucher will show in print
     


Share This Page