How to view outstanding pending amount

Discussion in 'Free Source Codes' started by sathiyaraj, Sep 11, 2018.

    
  1. sathiyaraj

    sathiyaraj Member


    1.jpg I want some issue in my tdl...

    i like to select party name to view customer outstanding balance any experts kindly help me...
    thanks in adv....


    [#Form : Bills Outstanding]

    Button : SalesPartyBtn

    [Button: SalesPartyBtn]

    Title : "Outstanding report"
    Key : F5
    Action : Execute : SalesPartyBtn


    [Report: SalesPartyBtn]
    Form: SalesPartyBtn
    Title: "Ledger Balance"

    [Form: SalesPartyBtn]
    No Confirm: yes
    Part: Ledgerclosingbalance1
    WIDTH: 35
    HEIGHT: 4

    [Part: Ledgerclosingbalance1]
    Line: Ledgerclosingbalance1

    [Line: Ledgerclosingbalance1]
    Field: Ledgerselect1, Amount field
    Local: Field: Amount field : Set as: $$closingbalance:ledger:#Ledgerselect
    Local: Field: Amount field :Format : "Symbol,DrCr"

    [Field: Ledgerselect1]
    Use: short name field
    Table: Ledger
    Show Table: Always
     

    Attached Files:

    • 3.jpg
      3.jpg
      File size:
      146.9 KB
      Views:
      119
    • 2.jpg
      2.jpg
      File size:
      138 KB
      Views:
      108


  2. young man

    young man New Member


    Hi,

    You had a small mistake in following line : $ClosingBalance is a Method Name, but you have mention Function option $$.


    [Line: Ledgerclosingbalance1]
    Field: Ledgerselect1, Amount field
    Local: Field: Amount field : Set as: $Closingbalance:ledger:#Ledgerselect
    Local: Field: Amount field :Format : "Symbol,DrCr"
     


  3. young man

    young man New Member


    Revised code : $Closingbalance:ledger:#Ledgerselect1
     


Share This Page