Finance | Project Operations, Human Resources, ...

Accounting source report

(1) Share

Report

Posted on by VV-22040800-0

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?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Waed Ayyad 9,042 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Any inputs on this?

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report
Copy link

Link copied!

Hi team,

Actually, I'm trying to get the amount spent against the project that has hit the GL, so any inputs on this?

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report
Copy link

Link copied!

Any inputs on this?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Accounting source report

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Accounting source report

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates