Total Purchase Order Out Standings irrespective of Period

Discussion in 'Tally Developer' started by Varadha, Sep 24, 2019.

    
  1. Varadha

    Varadha Member


    Dear Developers,
    I wrote a stock report consists of various balances. One of them is Purchase Order Outstandings. Since My report contains the period button all values are shown for that specific period. however, I require total Purchase order Outstandings irrespective of the period. How can I achieve it? Please help me in this regard. I am uploading my code snippet and demo company data. to replicate the issue at your end follow
    Gateway of Tally - Display - Stock Report.
    Demo company user name & Pswd is a & a

    Thanks in Advance
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    remove the period button from Form level.....

    Set SVFromDate as beginning of books date ...........
     
    Varadha likes this.


  3. Varadha

    Varadha Member


    Thank you for your advice. But other items need to be based on a specific period but only Outstanding Purchase orders are based on the whole period. That is the problem. Is it Possible? Can we do that?
     


  4. Varadha

    Varadha Member


    can you tell me what is the collection used for getting Purchase orders Outstanding report? I searched in default code I could not get proper collection name. is there any of solving the problem by constructing separate collection for that particular field and using $$CollQtyTotal Function. Can we use any variables in the newly constructed collection to fix the period? Please advice me
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yes...you can.... in that case you can define the period variable in the collection itself.
     


  6. Varadha

    Varadha Member


    how can I declare it can you provide sample code please
     


  7. Varadha

    Varadha Member


    I wrote collection like in the picture, please check. i am Attaching code snippet also
     

    Attached Files:



  8. Varadha

    Varadha Member


    Please help me
     


  9. Varadha

    Varadha Member


    Dear Amit Sir,
    Please help me in solving my issue. Send me sample code for fixing the period in the collection using variables. Variable you mean Declaring ComputeVar and using them in filter or any other way of doing it please help me sir
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    have patience....am upto neck in Sep ending .......... your solution needs time and study, which i do not have a lot now ........ so kindly wait.
     


  11. Varadha

    Varadha Member


    Thank you for your Prompt response and sorry for disturbing you don't think otherwise
     


Share This Page