Skip to main content
Question

How to allocate the sum of total depreciate into a month in the report Fix Asset Net Value( FA613000) ?

  • March 23, 2024
  • 0 replies
  • 22 views
D
Jr Varsity II
Forum|alt.badge.img

I want to allocate this amount over the months. Does anyone have any ideas on how to write a function to divide the total allocated amount?

I used the formula =SUM(iif(left([FAHistoryByPeriod.FinPeriodID],2)='01'and right([FAHistoryByPeriod.FinPeriodID],2)=right([@PeriodTo],2),[FADetails.AcquisitionCost]/(12[FixedAsset.UsefulLife]),0) ) but the report is not showing correctly.*

The correct value is 6 months with 6 equal values but it only shows 3 months, or 1 month. 

 

Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved