1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Cannot change Period ???

Discussion in 'Tally Developer' started by Johar, Oct 12, 2020.

    
  1. Johar

    Johar Member


    I am unable to change the period, can anybody help regarding the same.....

    Thanks


    [#Menu: Gateway of Tally]
    Item: "Batch Wise Item Summary" : Display Collection : Batch Report

    [Collection : Batch Report]
    Collection: MyBodyPart
    Variable: MyVar
    Report: ItemReport
    Trigger: MyTrigger
    Title: "List Of Batch's"
    Full Height: Yes
    Align: Center


    [Variable: MyVar]
    Type: String

    [Report: MyTrigger]
    Form : TriggerForm
    Variable: MyVar
    Title: "Select Batch Name"

    [Form: TriggerForm]
    Parts: TriggerPart
    Height: 100% Page
    Width:10% Page

    [Part: TriggerPart]
    Lines: TriggerLine

    [Line: TriggerLine]
    Field: TriggerField

    [Field: TriggerField]
    Use: Name Field
    Table: BatchReport
    SubForm :Item Report
    Show Table: Always
    Variable: MyVar
    Modifies: MyVar

    [Report: Item Report]
    Form : ItemForm
    Set : bename : $$batchfilter
    ;Set : SVFromDate : $$MonthStart$LastVoucherDate:Company:##SVCurrentCompany
    ;Set : SVToDate : $$MonthEnd:$LastVoucherDate:Company:##SVCurrentCompany

    [Form: ItemForm]
    Parts: ItemTitlePart, ItemBodyPart
    Button: ChangePeriod, PrintButton, ExportButton
     
    Johar, Oct 12, 2020
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Report: Item Report]
    Form : ItemForm
    Set : bename : $$batchfilter
    Set : SVFromDate : $$MonthStart:$LastVoucherDate:Company:##SVCurrentCompany
    Set : SVToDate : $$MonthEnd:$LastVoucherDate:Company:##SVCurrentCompany

    OR

    Set : SVFromDate :##SVFromDate
     
    Amit Kamdar, Oct 12, 2020
    #2


  3. Johar

    Johar Member


    Sorry Amity Sir, its not working I tried earlier, it takes whole financial Year

    Thanks
     
    Johar, Oct 12, 2020
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Set : SVFromDate : $$MonthStart:##SVCurrentDate
    Set : SVToDate : $$MonthEnd:##SVCurrentDate
     
    Amit Kamdar, Oct 12, 2020
    #4


  5. Johar

    Johar Member


    Amit Sir,

    Period changes but report has no effect even if we change period, Please help

    Thanks
     
    Johar, Oct 12, 2020
    #5


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Cannot say -- since only part code is there.......
     
    Amit Kamdar, Oct 12, 2020
    #6


  7. Johar

    Johar Member


    Amit sir, can I send you full code on your mail ID
     
    Johar, Oct 12, 2020
    #7


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    send to nehalsofttech@gmail.com along with dummy data and screenshot with explanations....

    will look into it....as time permits....it is AUDIT season for me.
     
    Amit Kamdar, Oct 12, 2020
    #8


  9. Johar

    Johar Member


    Amit Sir,

    I have sent you mail please check


    Thanks a lot
     
    Johar, Oct 13, 2020
    #9


  10. Johar

    Johar Member


    Amit Sir,

    Any update on my TDL


    Thanks
     
    Johar, Oct 14, 2020
    #10


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I solved the system wide period change issues....

    Not yet worked on the period wise data collection... will do in a day or two at the weekend..
     
    Amit Kamdar, Oct 14, 2020
    #11


  12. Johar

    Johar Member


    Ok Sir, Thanks
     
    Johar, Oct 15, 2020
    #12


  13. Johar

    Johar Member


    Amit Sir,

    Please do the needful.

    Thanks
     
    Johar, Oct 17, 2020
    #13


  14. Himanshu-2002

    Himanshu-2002 Active Member


    Hello Johar Sir,
    Amit sir is a very busy person So, I think you have to wait patiently And You can try it on your own ...to apply date filter in collection you can use Parm Var attribute at collection level

    Example:
    [Collection: Example]
    Parm Var: SvFromDate:Date:"01-01-18"
    Parm Var:SvToDate:Date:"01-01-20"
    Type: Voucher: VoucherType
    Child of: $$VchTypeSales
     
    Himanshu-2002, Oct 17, 2020
    #14


  15. Johar

    Johar Member


    Amit Sir,

    Thankyou for your valuable time and effort you did on my said TDL, Iam also trying to find out the error as to why the said period data is not getting retrieved.

    thanks a lot
    Johar
     
    Johar, Oct 19, 2020
    #15


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Maybe will work in coming weekend..... but I think it is due to collection. Your data is being retrieved from another collection of BATCHES....

    Will have to check further.....let's see.
     
    Amit Kamdar, Oct 19, 2020
    #16


  17. Himanshu-2002

    Himanshu-2002 Active Member


    Amit Sir If He is using some other collection then You can paas date parameters in the source Collection Right ?
     
    Himanshu-2002, Oct 19, 2020
    #17


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I tried that also..........PARM VAR : SVFFromDate .............not working..........

    As per my logic .... There is a LOOP in the initial collection and hence Date is not computing. The Report is being called by a TRIGGER as well as through a Field.
     
    Amit Kamdar, Oct 19, 2020
    #18


  19. Himanshu-2002

    Himanshu-2002 Active Member


    You tried like This?
    Parm Var: SvFromDate:Date:##SvFromDate
    Parm Var:SvToDate:Date:##SvToDate

    If Yes then Try like this
    Parm Var: SvFromDate:Date:#SvFromDate
    Parm Var:SvToDate:Date:#SvToDate
     
    Himanshu-2002, Oct 19, 2020
    #19


  20. Himanshu-2002

    Himanshu-2002 Active Member


    Use Local Field instead of Variable
     
    Himanshu-2002, Oct 19, 2020
    #20


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yep...both ways....also tried user defined "From / TO" date fields with ---- variable and udf methods both.
     
    Amit Kamdar, Oct 19, 2020
    #21


  22. Johar

    Johar Member


    Himanshu Sir,

    if you want I can send you my code plz send me your mail id



    Thanks

    Johar
     
    Johar, Oct 20, 2020
    #22


  23. Himanshu-2002

    Himanshu-2002 Active Member


    Not Really, Because Amit Sir is more knowledgeable than Me So, If he is struggling to solve it then I don't think I can solve it
     
    Himanshu-2002, Oct 20, 2020
    #23


Share This Page