Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / SSRS report show value...
Finance forum
Unanswered

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

Posted on by 462

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,

VK

  • vicky1234 Profile Picture
    vicky1234 462 on at
    RE: SSRS report show values of multiple sources in same grid D365 Sales Purchase 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.
    pastedimage1673362300724v1.png

    thanks,

    VK

  • GirishS Profile Picture
    GirishS 27,828 Super User on at
    RE: SSRS report show values of multiple sources in same grid D365 Sales Purchase 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.

    payment_2D00_journal.png

    Thanks,

    Girish S.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,513 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,862 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans