Skip to main content
Solved

Fixed Asset Report fields


Forum|alt.badge.img

Can anyone tell me what the formula $AdditionsInPeriod or $DisposalInPeriod in a FA report means? I assume it means the total additions or disposals for the period but I am not familiar with the prefix $.

The report I am working on seems fine but the totals do not balance. I am trying to understand the field content so I can correct the totals.

Many thanks in advance.

 

Best answer by ejmillar

 

Try the attached report. I’m about to sign off for the day so if you need anymore help then I’ll be available on Monday.

 

 

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

14 replies

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

Anything with a “$” in front of it is a Variable in the report, so you’ll need to find the section of the report where this variable is calculated to identify the formula behind it.

There’s more information about variables here: https://help.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=2dc83394-349f-4a45-b0df-e8f7a8a4b618


Forum|alt.badge.img

Thanks Megan. I am really battling with totals on a report. It is a fixed asset report and the totals are completely wrong. Can anyone assist? Here is the formula:

=sum([FADetails.AcquisitionCost])

The other formulae seems to work just fine, e.g. =$AdditionsInPeriod or =$BeginningDepr but that doesn’t work for the Acquisition Cost. 

Does anyone have any ideas please?

Many thanks

 
 
 

 


Forum|alt.badge.img

Good day all - I have had some advice regarding the above case and the relevant formulae. A colleague suggested that I should insert variables in the report, but I still don’t get the correct result. Maybe I am not doing it correctly? Does anyone have any advice please. Getting desperate now.

 


ejmillar
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • 58 replies
  • May 10, 2024

Hello,

Can you post the whole formula for the variable?

Is the calculation for a group?

If it is you will need to set the group in the ResetGroup property of the variable.

 


Forum|alt.badge.img

Hi Ewan

yes, the formula is for a group, i.e. Fixed Asset Class. However, it is only the Acquisition cost and Closing Cost that are not calculating properly.

Here is the Variable formula: =$TotalBeginningAmount+$BeginningAmount

Added it to GroupFooterSection1

I’m not sure if I added it in the right place or if it is the right formula

Where would I add the ResetGroup property?

Thanks in advance for your help.


ejmillar
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • 58 replies
  • May 10, 2024

The reset group is highlighted below. It will need to be set to the Fixed Asset Class.

Can you upload the report so I can take a look at the issue?

 

Thanks,

Ewan.


Forum|alt.badge.img

Sure I can. I am renaming it to a .doc file so I can upload it. It is a .rpx file, so I think you will have to rename it.

 

 


ejmillar
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • 58 replies
  • May 10, 2024

Hi,

I’ve made a few changes. Can you see if this works?

Regards,

Ewan.


Forum|alt.badge.img

There are some differences but the totals are still not correct.

 

Acquisition Cost (only running report for 1 class) - incorrect - s/be 1 034 219.31

Additions - correct - 54 258.08

Closing Cost - incorrect - 1 088 477.39

Thanks so much for trying to help me.


ejmillar
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • 58 replies
  • Answer
  • May 10, 2024

 

Try the attached report. I’m about to sign off for the day so if you need anymore help then I’ll be available on Monday.

 

 


Forum|alt.badge.img

Hi there Ewan - I am so grateful for you assistance. We are almost there. The Acquisition Cost is still out a little on SOME of the categories, but weirdly, the closing cost is correct, as are all the other fields. 

Unfortunately I can’t identify the differences - the do not relate to any particular asset(s). I have tried to look at the formulae for both but they are so different so I can’t identify the difference.  

Do you have any idea what I should look for?


ejmillar
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • 58 replies
  • May 13, 2024

Hi Barbara,

 

Can you change the variable $BeginningAmount to the following to see if that fixes the issue?

 

=$BeginningAmount+ iif($History = 0,
    [HistoryLast.YtdBal]
    - iif([FAHistoryByPeriod.FinPeriodID] = [FAHistoryByPeriod.LastActivityPeriod],                    [HistoryLast.PtdAcquired]
         + [HistoryLast.PtdDisposalAmount]
         - [HistoryLast.YtdRGOL]
         + [HistoryLast.PtdDepreciated],
    0),
[FADetails.AcquisitionCost])


Forum|alt.badge.img

Thanks Ewan - I’m afraid not. The Class totals remain the same but the Grand Total has gone out completely. Strangely, when I tried changing the formula (my changes didn’t work) then changed it back to yours, it worked on a test system, but is out again when I transferred to the Live system.

Report Totals for Acquisition Cost

Original 147 632 060.97
Calculation 147 672 020.96
Revised

7 678 869.52


Forum|alt.badge.img

Hi again Ewan

I though you might be interested to know that the report works perfectly for the current year. It is only if I run it for the previous financial year that it shows differences in some classes.

It’s a mystery but Im going to run with it for now. I can’t spend any more time on it now.

Thanks so much for your help.


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