Displaying all the months in a year in report

asembereng
asembereng Member Posts: 220
edited 2008-12-30 in NAV/Navision Classic Client
How can i display all the months in a year. the format has to be DDMMYYY where DD has to be the last day of the month in a columnar form.

Thanks

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    Examine the contents of the Date Virtual Table (Table 2000000007) by setting type Month and using something like NORMALDATE(Period End).

    And search this forum...
  • asembereng
    asembereng Member Posts: 220
    I do not have that table.
  • garak
    garak Member Posts: 3,263
    You doesn't see this table in the Objectdesigner. But you can work with it when you create a new Form based on the table "Date" or you work with it as a Record Variable.

    Open the "date" table with a new form (only in designmode) to see, how the entries in this table looks and to know how to work with it (filters, etc)

    regards
    Do you make it right, it works too!
  • garak
    garak Member Posts: 3,263
    This is a simple report example
    Do you make it right, it works too!
  • asembereng
    asembereng Member Posts: 220
    Thanks a lot. I have seen the table and i did that report as well. now I am to do similar thing on the Cust. Ledger entry table using posting date. The system does not have all the end of month data for example it will have

    31/01/08 D100
    29/02/08 D600
    30/09/08 D400
    31/12/08 D300


    but the report should display all the end of months and display a default amount of D500 for those that are not in the Cust/ Ledger table.

    How can i do this?

Categories