Adding Project Start Date to header
Trying to figure out how to code the Column Set so that get the following: 'Project Start Date: MM/DD/YYYY' and if available 'Project End Date: MM/DD/YYYY'
Is there a way to look at the tables behind the forms so that I can see what field name I need to be looking for? I want to pull the date from the Projects>Project Properties> *Start Date:
Is this possible? Attached a visual representation of what I am trying to achieve. When I tried to add Functions > Application > GetPeriodStartDate(organizationID,period) I generated the following error (I apologize in advance, I am a newbie to Acumatica Report Definitions) "The expression contains the 'organizationId' object that is not defined in the current context." Can anyone help, or am I asking for something that can't be done?
As far as I know there's no way to access this information using the Analytical Report Manager. I would suggest taking a look at Velixo Reports for Acumatica, you have access to this information by using =PROJECTSTARTDATE() in Excel, and you can format the report any way you like: