Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Accounting source report
Finance forum
Suggested answer

Accounting source report

Posted on by 314
Hi,
 
For the custom report, need to get the total amount against the project as like the similar way it is shown in accounting source report, basically there are two types of transactions where one will have project id mentioned in description field but not having the id in project id column and the other type will be the project id will be present in the project id column but not in the description so I'm trying to get the sum value of both types of transactions, so could you give some inputs on how we can get the overall amount against the project id as we're seeing in the accounting source report? I can see in backend that for project id there are two logic , one is based on projtrans posting and other one is based on SDRI - can we have any existing methods which will return the amounts for project based on some filters like date, main account?
  • VV-22040800-0 Profile Picture
    VV-22040800-0 314 on at
    Accounting source report
    Any inputs on this?
  • VV-22040800-0 Profile Picture
    VV-22040800-0 314 on at
    Accounting source report
    Hi,
     
    Is there a way to run the accounting source report through code with relevant parameters and get the data's as similar we get in the standard report execution?
  • VV-22040800-0 Profile Picture
    VV-22040800-0 314 on at
    Accounting source report
    Hi team,
     
    Actually, I'm trying to get the amount spent against the project that has hit the GL, so any inputs on this?
  • VV-22040800-0 Profile Picture
    VV-22040800-0 314 on at
    Accounting source report
    Hi,
     
    Any inputs on this?
  • VV-22040800-0 Profile Picture
    VV-22040800-0 314 on at
    Accounting source report
    Hi Waed,
     
    Actually I want to use the similar type of logic to get the amount, if you see the accountingsourceexplorerprocessor class there will be two place where project id value is set, one will be based on projtransposting which will have condition only with voucher matching and the other one will be based on many conditions like source document, accounting distribution which I need to use in my logic but the standard logic will have the matching with the temp table field data whereas I don't have those field data to match, also regarding my second question I'm basically trying to see is there any pre built class/method which will show all the amount that is associated with the project id? 
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 3,706 on at
    Accounting source report
    Hi,
     
    For your first question as your data is based on two different tables you can use DP SSRS report and fill your data from two table on the same temp table and to return the total amount you can do it in two ways either calculate it on the code or you can add new column for the amount and sum it on the SSRS report design.
     
     
    For your second question "Can we have any existing methods which will return the amounts for project based on some filters like date, main account?" do you want to add grouping? by main account?
     
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
     
     
     
     

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... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans