Project P&L

@katiedavison did you select “load from list?” you could also check the site map to see if there is another screen ID for this report

@iqraharrison48  yep i loaded the list! how do I check the site map?

@katiedavison if you search for site map in the search bar it should take you to that screen.  from there, you can search for the report name (sometimes it’s not exact so i would start broad and then hopefully that helps narrow it down)

Hi @katiedavison ,

I believe that report is built within the Finance Report Writer (ARM), not the Acumatica Report Designer “.rpx” report writing tool.

Regarding the site map, you can find it searching for ‘Site Map’ Menu item (SM200520).

@katiedavison ,

Please go to Finance → Preferences, Report Definitions to revise your Project P & L report.

Laura

@Laura02 this is very helpful but how do I edit the “guts” of the report? For example - it shows every single line item on my Schedule of Values but I only want to see a summary of the revenue line item.  Looking to edit some of the coding of the report.. how do I do that? 

Hello Katie,

Acumatica comes with no pre-defined financial reports for projects, so I know that someone at your firm, or your Acumatica Partner designed the report.  The people who designed the report are a good resource for help - an hour of training will make a big difference - will help you to get started modifying project financial reports.

From the Report Definitions screen, Row Sets, Column Setss and optionally, Unit Sets are the Guts of your reports:

In Row Set and Column Set, look for Data Source fields → these important settings control how much Detail is shown on reports, what kind of figures are shown, which projects, tasks, etc. 

Laura

@Laura02  that was EXTREMELY helpful! I have figured out how to do it now! Last question: it does not list the project that was selected at the top of the report so if you were to print out the report you’d have no idea what project it was for.  How can I incorporate that as part of the header?