Fetch Opening Issue

Discussion in 'Free Source Codes' started by Sanjay preethi, Aug 21, 2021.

    

  1. I want Before Period Value(Opening)

    Any Help Me Sir.....

    ;;;;Code Bellow;;;;;;;;;;




    [System:Formula]

    LedOpeningsdr : if $$ParentPeriodFrom < @@DSPFromDate then $$CollectionField:$OpeningBalanceJobd:1:MyLedOpVals Else $TBalOpening:Ledger:#LedgerName



    [Collection: MyLedOpVals]

    Parm Var : pvFrmDate : Date : $$ParentPeriodFrom
    Parm Var : pvToDate : Date : @@DSPFromDateLessOne

    Source Collection : MyLedOpValSrcs

    Compute : OpeningBalanceJobd : $OpeningBalanceJob

    [Collection: MyLedOpValSrcs]

    Parm Var : pvFrmDate : Date : $$ParentPeriodFrom
    Parm Var : pvToDate : Date : @@DSPFromDateLessOne

    Type : Ledger

    Compute : OpeningBalanceJobd : If @@IsNameLedgerName Then $$FromValue:##pvFrmDate:$$ToValue:##pvToDate:$billedqty Else $$AsAmount:0

    Filter : IsNameLedgerName
     

    Attached Files:



Share This Page