Skip to main content
Answer

Profit & Loss Rolling 12 Month report (RM000030) runs incorrectly with Number of Financial Periods setting being 12

  • June 15, 2024
  • 3 replies
  • 290 views

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

Hi ALL,

Profit & Loss Rolling 12 Month report (RM000030) runs incorrectly. Missing period 12.

 

I looked at this report on Acumatica's Demo data and it ran correctly. It's possible that Acumatica's Demo data has Number of Financial Periods of 13 while our Number of Financial Periods are 12.

 

I think Column Set on Report Definitions needs to be edited, but I don't know how to edit it correctly.

 

 

Looking forward to your support.

 

Best Regards,

NNT

Best answer by sroberts29

That 'visibility formula' needs to be removed from all columns if you have a 12-period configuration.

3 replies

sroberts29
Freshman II
Forum|alt.badge.img+1
  • Freshman II
  • Answer
  • June 15, 2024

That 'visibility formula' needs to be removed from all columns if you have a 12-period configuration.


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Author
  • Captain II
  • June 17, 2024

Hi @sroberts29 

Thank you so much !

 

Best Regards,

NNT


  • Freshman I
  • June 23, 2025

Can you please show the Amount Type setting you used in the Data Source row for monthly movements?

The first one i can see is Turnover, what should the rest be?