cancel
Showing results for 
Search instead for 
Did you mean: 

Adding sales order values

Former Member
0 Kudos

I have another little problem.

I run projects for my company and the projects involve several sales orders.

What i am looking to do is pull all the values from the sales orders into one invoice.

I have three values pulling in...Nett, VAT, Gross

I basically want the crystal report to show the total value of all sales orders added together. so if i had 2 sales order into one project

Sales order 123456

Nett £100

VAT £20

Gross £120

Sales order 654321

Nett £200

VAT £40

Gross £240

I want the report to show

Nett £300

VAT £ 60

Gross £360

Basicall an addition of the two sales orders and suppression of the sub totals.

Please help

Accepted Solutions (0)

Answers (1)

Answers (1)

siva_vasireddy2
Active Contributor
0 Kudos

Hi,

This report can be build by yourself with SQVI by combining the Tables