How to store Last Amount thru Variable?

Discussion in 'Free Source Codes' started by Jenny, Jul 25, 2023.

    
  1. Jenny

    Jenny Active Member


    Code:
    [#Report: AutoBRSUnReconListSavedLinkAll];;;this is the report which is showing amount 
        Variable        : LastReconAmt
    
    [Variable : LastReconAmt]
        Type        : String
        Persistent    : Yes
        Default        : $$AsAmount:0
      
    [System: Variable]
        LastReconAmt:$$AsAmount:0
    
    [#Field:EBanking Summary CrAmount]
    Modifies:LastReconAmt
    
    [#Field: IFLT AttrValue]
    Set as:    ##LastReconAmt ;;i want amount in this field
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You are setting VALUES in both Variable definition as well as System as 0 .....

    Keep it blank. In the Field FROM WHERE you need to pick up the values ........... add the line ---- Modifies : LastReconAmt
     
    Jenny likes this.


  3. Jenny

    Jenny Active Member


    Not Working..where i Mistake

    Code:
    [#Report: AutoBRSUnReconListSavedLinkAll];;;this is auto BRS ?yes
        Variable        : LastReconAmt
    
    [#Field:EBanking Summary CrAmount];;;this is the amount which i want to store in variable
            Modifies:LastReconAmt
    
    
    [Variable : LastReconAmt]
        Type        : String
            Persistent    : Yes
    
    [System: Variable]
        LastReconAmt:""
    
    [#Field: IFLT AttrValue];;;i want to showing amount in this field
    Modifies : ##LastReconAmt
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Field: IFLT AttrValue];;;i want to showing amount in this field
    Modifies : ##LastReconAmt


    [#Field: IFLT AttrValue]
    set As: ##LastReconAmt
     



  5. Please check with this once.

    Code:
    [#Report    :     AutoBRSUnReconListSavedLinkAll];;;this is auto BRS ?yes
    ;Variable    :     LastReconAmt
    
    [#Field        :    EBanking Summary CrAmount];;;this is the amount which i want to store in variable
    Type        :    Amount
    Modifies    :    LastReconAmt    :    Yes
    
    [Variable     :     LastReconAmt]
    Type          :     Amount
    Persistent     :     Yes
    
    [System        :     Variable]
    LastReconAmt:    ""
    
    [#Field        :     IFLT AttrValue];;;i want to showing amount in this field
    Type        :    Amount
    Set as        :    ##LastReconAmt
    Set Always    :    Yes
    
    ; just to check if there some refreshing issue write below commented code & check
    
    ;On     :    Focus    :    yes    :    Set Field    :    ##LastReconAmt
    
     
    Last edited: Jul 25, 2023


  6. Jenny

    Jenny Active Member


    Showing error field : Flt AttrValue incorrect type for field conflicts with storage
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Field: IFLT AttrValue] already exists and is of Type - NAME .....

    Make a system formula and then use --- $$String:mad:@Formula in that field
     


  8. Jenny

    Jenny Active Member


    If i remove Type then its showing "Credit"
     


  9. Jenny

    Jenny Active Member


    [Field: IFLT AttrValue] ;;; its Default Field

    Use : Short Name Field
    Width : 10
    Inactive : NOT $$IsEmpty:$SecondaryObject OR ($$Line > 1 AND $$IsEnd:#IFLTCombine) OR NOT $$Table:IFLTAttr:$NeedsParm
    Storage : Attribute Value

    Where to change?
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    IFLT AttrValue -- is a field for FILTER ..........

    What is your objective ???? ............. the field where you are defining a variable to hold a value -- is Banking Summary's Credit amount ............
     


  11. Jenny

    Jenny Active Member


    Now in filter its showing 0.00 , Amount not fetch

    Code:
    [#Field            :    EBanking Summary CrAmount]
    Type            :    Amount
    Modifies        :    LastReconAmt    :    Yes
    
    [Variable         :     LastReconAmt]
    Type              :     Amount
    Persistent         :     Yes
    
    [System            :     Variable]
    LastReconAmt:   :""
    
    [#Field            :     IFLT AttrValue];;;i want to showing amount in this field
    Type            :    String
    Set as            :    ##LastReconAmt
    Set Always        :    Yes
    On                 :    Focus    :    yes    :    Set Field    :    ##LastReconAmt
    
    
    [#Field: EBanking Summary DrAmount]
    
        Use            : Amount Field
        Set as        : If NOT $$IsDr:$TransactionAmount Then "" Else $$setLastrecon:$TransactionAmount
        Scale        : ##SVScaleFactor
    
    [#Field: EBanking Summary CrAmount]
    
        Use            : Amount Field
        Set as        : If $$IsDr:$TransactionAmount Then "" Else $$setLastrecon:$TransactionAmount
        Scale        : ##SVScaleFactor
       
    
    [Function:setlastrecon]
        Parameter:pTransaction Amount:Amount
       
    10:Set:LastReconAmt:$$LocaleString:##pTransactionAmount
    15:Log:$$LocaleString:##pTransactionAmount
    20:Return:##pTransactionAmount
    
     

    Attached Files:



Share This Page