SSRS report show values of multiple sources in same grid D365 Sales Purchase report

(0) Share

Report

Posted on by vicky1234

hi ,

We have a requirement to show the charges of the sales confirmation report with charges which a standard report also shows however the requirement over here is as below.

Current report : shows below output with total sum = 1000 + 2000 + 160(30+40+30 +60) charges = 3160

Below report shows the charges as a separate section outside the grid .

Itemid	Description	unit price	qty	total
Item001	abc	100	10	1000
Item002	xyz	100	20	2000

			Total sum	3160

The requirement is to show the above report as below. I would like to understand if this is even feasible and if yes then how do I achieve it.

There can be zero line of charges or multiple ones as well.

Itemid	Description	unit price	qty	total
Item001	abc	100	10	1000
	charge1			30
	charge2			40
Item002	xyz	100	20	2000
	charge1			30
	charge3			60

			Total sum	3160

Thanks,

I have the same question (0)

All responses (2)

Answers (0)

GirishS 27,827 Moderator on at

Like (1)

Report

Hi vicky1234,

Your requirements are similar to that of CustPaymentJournal report.

Not exactly the same scenario but you can refer to that report. Report will be having Journal number >> Account details >> Invoice details.

Refer to the below image.

Thanks,

Girish S.

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

Thanks Girish,

The customer payment journal report shows the whole grid results and then another one, however in my case the output required is different.

thanks,

VK

Was this reply helpful? Yes No