Problem in report

milind

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 ](*,)

lubost

Can you write more details what you want to do?

Do you want to calculate total invoiced amount or only count of invoices?

Waldo

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.

milind

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

... 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

use grouping on order no.