Quater wise report

vikram7_dabasvikram7_dabas Member Posts: 611
Dear all
I want Quarter wise (April to june),(july to september),(october to december),(january to march) report and I m moking report by taking Sales Invoice Header dataitem,it doesnt matter that ur report contains this dataitem or not.
Vikram Dabas
Navision Technical Consultant

Comments

  • DaveTDaveT Member Posts: 1,039
    Hi Vicram,

    Not 100% sure what your asking but I think you want the sales header values split across quarters. If so then you need to create four date ranges and four variables and total into the variables based on the date ranges. The standard aged debts are designed on this principle but are a little complex. Have a look at them and it should give you the general idea.

    P.S. there are loads of post on how to find / set the date ranges.

    hope this helps
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • kinekine Member Posts: 12,562
    1) If you need start and end date for the quarter, you can use virtual table Date to find it.
    2) I do not understand what is your problem. Please, be more specific...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DaveTDaveT Member Posts: 1,039
    kine wrote:
    If you need start and end date for the quarter, you can use virtual table Date to find it.

    Hi Kamil,

    =D> That's a great tip - I been coding this all along #-o

    Thanks a million :wink:
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
Sign In or Register to comment.