In "Outstanding Receivable" how to fetch on account value and closing balance?

Discussion in 'Free Source Codes' started by Jenny, Feb 6, 2020.

         
  1. Jenny

    Jenny Active Member


    Code:
    [#Part: GRPLedBILL Details]
        Add: Lines: After:GRPLedBILL Total :JennyOnaccountDetail,JennyFinalBalDetail
       
    
    [Line: JennyOnaccountDetail]
    
        Left Fields : BILLFixed1, LedBILLOp1, LedBILLCl1
        Repeat      : LedBILLCl1
       
    [Field: BILLFixed1]
        Fields : BILLDate1, BILLRef1, BILLIsAdvance1, BILLParty1
       
    [Field: BILLDate1]
        Use     : NameField
        Set as  : ""
        Width   : If ($$InExportMode AND @@IsHTMLFormat) Then (@@ShortDateWidth + 4) Else @@ShortDateWidth
       
    [Field: BILLRef1]
        Use     : NameField
        Set as  : ""
        Width       : 12
        SpaceLeft   : if ##IsBillWiseReport AND $$InPixelMode then 2.5 else 0.5
       
    [Field: BILLIsAdvance1]
        Use     : NameField
        Set as  : ""
        Width       : If $$InPrintMode Then 6 Else 7
       
    [Field: BILLParty1]
        Use     : NameField
        Set as  : ""
        Width       : if NOT $$InPixelMode then @@NameWidth - 3 else if (##ShowOpBillAmt OR $$NumSets > 1) then @@ShortNameWidth + 5 else @@NameWidth + 5
       
    [Field: LedBILLOp1]
    
         Use         : NameField
         Set as      : "On Account"
         Width       : if NOT $$InPixelMode then @@AmountWidth else if ##IsBillWiseReport then @@AmountWidth - 1 else @@NumberWidth + 3
           
    [Field: LedBILLCl1]
    
        Use         : AmountField
        Set as      : $OnAccountValue
        Border        : Sub Totals
        Width       : if NOT $$InPixelMode then @@AmountWidth else if ($$Numsets>1 AND $$InPrintMode) Then @@NumberWidth+1 Else If ##IsBillWiseReport then @@AmountWidth - 1 else @@NumberWidth + 3
        Format         : "DrCr,NoZero," + ##ShowForex
       
    
       
    ;;;;;;;;;;;;;;;;;;;;;;Final Balance;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    
    
    [Line: JennyFinalBalDetail]
    
        Left Fields : BILLFixed11, LedBILLOp11, LedBILLCl11
        Repeat      : LedBILLCl11
       
    [Field: BILLFixed11]
        Fields : BILLDate11, BILLRef11, BILLIsAdvance11, BILLParty11
       
    [Field: BILLDate11]
        Use     : NameField
        Set as  : ""
        Width   : If ($$InExportMode AND @@IsHTMLFormat) Then (@@ShortDateWidth + 4) Else @@ShortDateWidth
       
    [Field: BILLRef11]
        Use     : NameField
        Set as  : ""
        Width       : 12
        SpaceLeft   : if ##IsBillWiseReport AND $$InPixelMode then 2.5 else 0.5
       
    [Field: BILLIsAdvance11]
        Use     : NameField
        Set as  : ""
        Width       : If $$InPrintMode Then 6 Else 7
       
    [Field: BILLParty11]
        Use     : NameField
        Set as  : ""
        Width       : if NOT $$InPixelMode then @@NameWidth - 3 else if (##ShowOpBillAmt OR $$NumSets > 1) then @@ShortNameWidth + 5 else @@NameWidth + 5
       
    [Field: LedBILLOp11]
    
         Use         : NameField
         Set as      : "Final Amount"
         Width       : if NOT $$InPixelMode then @@AmountWidth else if ##IsBillWiseReport then @@AmountWidth - 1 else @@NumberWidth + 3
           
    [Field: LedBILLCl11]
        Use         : AmountField
            Type        : Amount
            Set as      : $FinalBalance
            Style       : "Normal"
            Width       : if NOT $$InPixelMode then @@AmountWidth else @@NumberWidth
            Format      : "DrCr,NoZero," + ##ShowForex
            Border        : Sub Totals
     

    Attached Files:




  2. I you Analysis and Use this [Line: BILL OnAccDetail] : Is this a way to Find the Solutions
     



  3. Please check something like
    $OnAccountValue:Ledger:#LedgerName
     


  4. Jenny

    Jenny Active Member


    i do but not working
     



  5. You can not use #ledgername
    You need to change it accordingly field name within your report. On account value of referred field.
    Otherwise you may have to send sample data and your codes for detailed check. Thank you
     


  6. Jenny

    Jenny Active Member


    Thank you........my query solved.....
     
    zakirhossain_diu likes this.


Share This Page