What are the exaclty definitions of FinYTD, TranYTD, FinPTD,TranPTD and so on.

  • 22 April 2021
  • 4 replies

Userlevel 6
Badge +5


      When I study the table, I see a lot of columns start with Fin or Tran.
I konw Fin means the Finanical Period,   How about Tran?

I know YTD is year to date, PTD is period to Date.
But what are tranPTD and TranYTD?
For me, it looks like the same with FinPTD and FinYTD


Best answer by Gabriel Michaud 23 April 2021, 23:19

View original

4 replies

Userlevel 6
Badge +5

Hello, did anyone know the difference?

Userlevel 7
Badge +10

This has evolved over time and the annotations on the Data Access Classes have not been update to reflect the internal changes.

2018 R2 Or Before

Previously, it was entirely based on the transaction date vs. financial period (Tran**** is related to transaction date, and Fin**** is related to the financial period of the document). Amounts are always be the same if you don’t manually override the financial period in documents. 

Here’s an example -- assume your financial year is calendar year (01-2021 = January 2021). You create a transaction on January 15th. Period is defaulted to 01-2021. Row would show period 01-2021, amount FinAmount + TranAmount would be the same.

Now, let’s say you enter the transaction on February 3rd, but you want this to be posted in 01-2021. You’d have two rows -- one based on the selected financial period (01-2021), and another one based on the transaction date period (02-2021)

2019 R1

With the introduction of company-specific year start date, you can now have multiple companies in the same tenant with a different financial year. The existing fields have been repurposed and are used to track the balances based on each company’s financial year, or using the master calendar. The Tran*** fields aggregate data based on the master financial period, and the Fin*** fields aggregate data based on the company financial period.

If you only have one company, or if every company uses the same financial calendar, you’ll see identical values in these fields. This also requires enabling the “Multiple Calendar Support” checkbox in Enable/Disable features during initial configuration.


Userlevel 6
Badge +5

@Gabriel Michaud 
Thank you,Sir.  You are quite an expert. 

Userlevel 7
Badge +19

@ray20  Yes…. He is the Master… :) 


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