Question

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

  • 23 March 2024
  • 0 replies
  • 8 views

Userlevel 3
Badge

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. 

 


0 replies

Be the first to reply!

Reply


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