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?

All responses (6)

Answers (0)

VV-22040800-0 10 on at

Like (0)

Report

Accounting source report

Any inputs on this?
VV-22040800-0 10 on at

Like (0)

Report

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 10 on at

Like (0)

Report

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 10 on at

Like (0)

Report

Accounting source report

Hi,

Any inputs on this?
VV-22040800-0 10 on at

Like (1)

Report

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 8,286 Super User 2025 Season 1 on at

Like (1)

Report

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

Community site session details

Accounting source report

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Accounting source report

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates