Balance Detail in Voochers

Discussion in 'Requests' started by nasir, Dec 28, 2019.

         
  1. nasir

    nasir Member


    i got a code and change as per my requirement
    but still not got the right solution

    fields are comming like this previous balane received amount net balance in a rows
    i ned these fields column typr
    like

    previous balance=2222
    Received amount=2222
    net balance=0000
    this way


    kindly make correction for this
    see codeplzzzzzzzzz and screen shoots


    [#Line: PPR Words]
    Add:Fields:aFTER:pPR Words:ExBal,RcptAmt1,NetBal

    [Line:ExBal]
    Field:ExBalFld



    [Field:ExBal]
    Field : Simple Prompt, Amount Field
    Local : Field : Simple Prompt : Info : "Previous Balance:"
    Local : Field : Simple Prompt : width : 12
    Local : Field : Amount Field : Set as : If ($$IsDr:$$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) +
    then($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)+$$abs:$$CollectionField:$Amount:1:AllLedgerEntries else +
    ($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) - $$abs:$$CollectionField:$Amount:1:AllLedgerEntries
    Local : Field : Amount Field : Format : "Symbol,DrCr"
    Invisible:Not ##BalPrntRcpt



    [Line:RcptAmt1]
    Field:RcptAmtFld

    [Field:RcptAmt1]
    Field : Simple Prompt, Amount Field
    Local : Field : Simple Prompt : Info :$$LocaleString:"Receipt Amount:"
    Local : Field : Simple Prompt : Width : 10
    Local : Field : Simple Prompt : Border : Full Thin Bottom
    Local : Field : Amount Field : Set as : $$CollectionField:$Amount:1:AllLedgerEntries
    Local : Field : Amount Field : Format : "Symbol,DrCr"
    Invisible:Not ##BalPrntRcpt


    [Line:NetBal]
    Field:NetBalFld

    [Field:NetBal]
    Field : Simple Prompt, Amount Field
    Local : Field : Simple Prompt : Info : "Current Balance:"
    Local : Field : Simple Prompt : Width : 10
    Local : Field : Amount Field : Set as : $$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries
    Local : Field : Amount Field : Format : "Symbol,DrCr"

    Invisible:Not ##BalPrntRcpt

    [#Part: Receipt Print Config]
    Add:Line:At End:BalPrnt

    [Line: BalPrnt]

    Fields : Medium Prompt, BalPrnt
    Local : Field : Medium Prompt : Set as:"Show Mini Statement?"

    [Field: BalPrnt]

    Use : Logical Field
    Modifies : BalPrntRcpt

    [System:Variable]
    BalPrntRcpt:Yes

    [Variable:BalPrntRcpt]
    Type:Logical
    Persistent:Yes
     


  2. nasir

    nasir Member


    see screen shoots plzzz
     

    Attached Files:

    • Ppr.pdf
      File size:
      240.9 KB
      Views:
      14


  3. nasir

    nasir Member


    any body help plzzzzzzz
     


Share This Page