Problem in report

milind
milind Member Posts: 130
edited 2007-03-21 in NAV/Navision Classic Client
I am trying to create a report for total invoices raised against particular orders for paricular month .I have created the report but the problem is for one order if there are three invoices then Order no. also repeated three times can anybody give me the solutions ](*,)

Comments

  • lubost
    lubost Member Posts: 633
    Can you write more details what you want to do?

    Do you want to calculate total invoiced amount or only count of invoices?
  • Waldo
    Waldo Member Posts: 3,412
    milind wrote:
    I am trying to create a report for total invoices raised against particular orders for paricular month .I have created the report but the problem is for one order if there are three invoices then Order no. also repeated three times can anybody give me the solutions ](*,)
    There are several ways:
    - you can work with grouping (grouptotalfields)
    - you can work with indenting data items.

    I'm afraid you'll have to give more details.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • milind
    milind Member Posts: 130
    Suppose I created one order A with an Order amount $300,and created three invoice say B in the month of JAN of $100 and C & D in the month of FEB of $100 each

    Order No. Order Amount Invoices
    A $300 JAN FEB MAR
    $100 $200
  • lubost
    lubost Member Posts: 633
    ... and what would you want to print?

    Try:
    Order Header (Sales or Purchase)
    Invoice Header (Sales or Purchase) - indented a linked via "Order No."

    and put fields you want in appropriate section.
  • bobnavision
    bobnavision Member Posts: 159
    use grouping on order no.

Categories