Skip to main content
Solved

Financial Statement


I need in formatting profit and Loss financials Statement so that you can see it monthly. As a trend Like January to April 

Best answer by meganfriesen37

Take a look at the comments from Tim here:  https://www.augforums.com/forums/acumatica-analytical-report-manager-financial-report-writer/rolling-12-month-report-profit-loss-pl-in-acumatica/#post-9290  He’s got a bunch of great screenshots of how to do a monthly P&L / Income Statement

View original
Did this topic help you find an answer to your question?

7 replies

Robert Sternberg
Captain II
Forum|alt.badge.img+8

Hello!

Have you tried using the Data Source on your Column Set to adjust the Period?

 

 


  • Author
  • Freshman I
  • 2 replies
  • April 28, 2023

Am new to acumatica so its like talking im Latin right now. I will try to go to data Source


meganfriesen37
Captain II
Forum|alt.badge.img+11

Take a look at the comments from Tim here:  https://www.augforums.com/forums/acumatica-analytical-report-manager-financial-report-writer/rolling-12-month-report-profit-loss-pl-in-acumatica/#post-9290  He’s got a bunch of great screenshots of how to do a monthly P&L / Income Statement


Forum|alt.badge.img
  • Jr Varsity II
  • 27 replies
  • July 25, 2024
Robert Sternberg wrote:

Have you tried using the Data Source on your Column Set to adjust the Period?

I am trying this for the first time. Do you know if there are additional settings/formulas required? I’m trying to count-up from column 1 (being period 01-xxxx), so I’ve used offset as 1 rather than -1 and my results for that column are returning blank. Thanks


meganfriesen37
Captain II
Forum|alt.badge.img+11

If you use Start Period 01-____ (leave the year blank) it will pick the first period of the year that the user enters as their “start period” when they run the report.

If you use the offset period option, and put in 1 in the period field, it wants to add a period to the “start period” that the user enters.


Forum|alt.badge.img
  • Jr Varsity II
  • 27 replies
  • July 25, 2024

Thanks @meganfriesen37, so ‘offset’ only applies to the report parameter entered @StartPeriod and @EndPeriod?

Is there a best quick an easy ‘best practice’ for a 12m side by side monthly P&L that returns the data in between the start and end? For instance, the user defines start as 01-2024 and end as 06-2024 (though there is partial data in 07-2024) only period 01-06 should return data? Period 01 will also be the first column. Thanks


meganfriesen37
Captain II
Forum|alt.badge.img+11

Hi,

I’ve done it in the past where I set up all the periods with their own columns and just have the user enter the “Start Period” (Which I really treat as the end period) and then in each column, I have a visibility setting to say (i.e. for period 02-2024)
Formula for Period 2:  =IIf(Left(@StartPeriod,2) <=02, true, false) 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings