1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Change Period (Set Default)

Discussion in 'Free Source Codes' started by Jay kumar tailor, Jul 2, 2019.

    
  1. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Hi All
    Jay Here

    Sometimes, When i Checking Ledgers For Full FInancial Year.
    I Face Problem With Period.
    Everytime We Need To Change Period.

    So, We Can Skip This Condition.
    In A Simple Way.
    Like This....
    Code:
    [#Report : Ledger Vouchers]
Set : SVfromDate:$$FinYearBeg:##StartDate:$StartingFrom:Company:##SVCurrentCompany
Set : SVToDate:##Svcurrentdate
     
    Jay kumar tailor, Jul 2, 2019
    #1
    santosh swami, Bidyut Banerjee, psr and 2 others like this.


  2. sohel

    sohel New Member


    Hi Jay, it small but very effective. Cool brother
     
    sohel, Jul 19, 2019
    #2


  3. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Be Careful Don't Open Cash/Bank Ledger if Data is Large. For Avoid Trouble..
     
    Jay kumar tailor, Jul 19, 2019
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member



    To avoid Cash/Bank.... do the following:

    Code:
    [#Report : Ledger Vouchers]
Set : SVfromDate:$$FinYearBeg:##StartDate:$StartingFrom:Company:##SVCurrentCompany : NOT ($$IsBelongsTo:$$GroupCash OR $$IsBelongsTo:$$GroupBank OR $$IsBelongsTo:$$GroupBankOD)
Set : SVToDate:##Svcurrentdate: NOT ($$IsBelongsTo:$$GroupCash OR $$IsBelongsTo:$$GroupBank OR $$IsBelongsTo:$$GroupBankOD)
     
    Amit Kamdar, Jul 19, 2019
    #4


  5. Bipin Damania

    Bipin Damania Active Member


    Amitji

    Showing error
     
    Bipin Damania, Jul 19, 2019
    #5


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Code:
    [#Report : Ledger Vouchers]
Set : SVfromDate:If @@NotCashBank Then $$FinYearBeg:##StartDate:$StartingFrom:Company:##SVCurrentCompany Else $$MonthStart:##SVCurrentDate
Set : SVToDate:##Svcurrentdate

[System : Formula]
NotCashBank : NOT ($$IsBelongsTo:$$GroupCash OR $$IsBelongsTo:$$GroupBank OR $$IsBelongsTo:$$GroupBankOD)
     
    Amit Kamdar, Jul 19, 2019
    #6
    santosh swami likes this.


  7. sandip kumar

    sandip kumar New Member


    How to set starting date from 17-7-2018
     
    sandip kumar, Jul 24, 2019
    #7


  8. arihantl

    arihantl New Member


    NOT WORKING SIR
     
    arihantl, May 12, 2020
    #8


  9. Neeru

    Neeru Active Member


    Dear Sir,

    How we set yesterday date and current data.

    for Exp.
    Today is 12-5-2020. then ledger accounting report show us 11-5-2020 to 12-5-2020 only..
     
    Neeru, May 12, 2020
    #9


  10. Bipin Damania

    Bipin Damania Active Member


    Try this
    Set : ##SVMachineDate-1
     
    Bipin Damania, May 12, 2020
    #10


  11. Khyrul

    Khyrul New Member


    How to view (filter) overdue receivable by Due On date ?

    [#Collection: Company Receivables]
    Add:Filter:IsmyFromDt
    [System:Formula]
    IsmyFromDt: .....................?
     
    Khyrul, Jun 7, 2020
    #11


  12. auruem

    auruem Member


    somethig is wrong,
    its not working sir...
     
    Last edited: Jul 10, 2020
    auruem, Jul 10, 2020
    #12


  13. Taurabh

    Taurabh New Member

    Taurabh, Jul 11, 2020
    #13


  14. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    See This.
    Free ...
    Download Link Available in Description Box.
     
    Jay kumar tailor, Jul 22, 2020
    #14


  15. Chetan S

    Chetan S New Member


    Sir, instead of beginning of current financial year, can we select company beginning date?
     
    Chetan S, Sep 5, 2020
    #15


  16. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Yes
     
    Jay kumar tailor, Sep 5, 2020
    #16


  17. Chetan S

    Chetan S New Member


    I modified it and it is working Sir. Thanks
     
    Chetan S, Sep 5, 2020
    #17


  18. B Prasad

    B Prasad New Member


    Is there something wrong. It's not working.
     
    B Prasad, Mar 21, 2021
    #18


  19. mkraju_mst

    mkraju_mst New Member


    [Collection:party_Item_Pur_ItemColl]
    Source Collection:party_Item_Pur_Coll
    Walk:AllInventoryEntries
    By:StockItemName : $StockItemName
    Aggr Compute : VCHNoOfTrayy : Sum: $VCHNoOfTray
    Aggr Compute : VCHGWeightt : Sum: $VCHGWeight + $VCHNoLoose
    Aggr Compute : VCHNoPiecee : Sum: $VCHNoPiece
    Aggr Compute : VCHNoLoosee : Sum: $VCHNoLoose
    Aggr Compute : VCHAvaRagePerr : Sum: ($VCHGWeight+$VCHNoLoose) / Sum: $VCHNoPiece
    Compute : VCHKgsTrayy : $VCHKgsTray
    Keep Source:().

    sir
    Please correct my above code formula mistake

    Aggr Compute : VCHAvaRagePerr : Sum: ($VCHGWeight+$VCHNoLoose) / Sum: $VCHNoPiece ---result not shown
     
    mkraju_mst, Mar 31, 2021
    #19


Share This Page