Report Definitions screen Customization

Just wanted to check with you all again this!!

​@wfilipiak67  Can you please provide your inputs on this?

​@nsmith51 ,
I do not have a lot to do with customizing this screen or building the financial reports beyond the basic needs. 
Sorry. 

Hi ​@nsmith51 

Reports such as Project P&L are ARM reports (Report Definitions) in Acumatica.
These ARM reports are very convenient for creating financial statements. However, their limitation is that you cannot customize the available parameters as flexibly as you require.

You can use Report Designer, a powerful tool that provides extensive support and advanced customization through formula configurations, to fulfill your requirements.

Best Regards,

NNT

Hi ​@nsmith51, You can achieve this by defining report-level parameters based on the tables mapped and then applying the required filters using those parameters in the report’s data source.

Hi ​@premalathan35  Have you done this customization before?

If yes, can you please share the sample code to use this parameters in data source?

​@nsmith51 I have not done exactly like this. But Create a parameter kind of PMProject table and add a filter like this. 

PMProject.BranchID = @BranchID
AND PMProject.ProjectGroupID = @ProjectGroupID.

​@premalathan35  Sorry, I think you are not understanding my question.

How can we apply add these fields in the Row Sets → Data Source column?