Skip to main content
Question

What is the difference between PMTran.Date and PMTran.TranDate?


aaghaei
Captain II
Forum|alt.badge.img+10

Does anyone know what is the difference between the  PMTran.Date and PMTran.TranDate? The PMTran.TranDate is not visible to user out of the box and is defaulted to the BusinessDate. User can enter and edit PMTran.Date though. So, the question is what the purpose of PMTran.TranDate is when it is not available to user?

5 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Support Team
  • 222 replies
  • March 17, 2025

@aaghaei The Trandate is the date for financial transactions but PMTran.date can be the date of original transaction like Timecards which has many lines of activity with different dates for a week but when the PM Transaction is being released and posted into GL the PMTran.TranDate is being used for GL Journal Transaction which is unique for the whole Transaction.


AdelinaBasyrova75
Acumatica Moderator
Forum|alt.badge.img

@aaghaei, PMTran.TranDate is the project transaction date

PMTran.Date can be different.

Please find example for timecard mentioned: 

 

What workflow/scenario are you considering?

Thank you!

cc ​@hkabiri 


aaghaei
Captain II
Forum|alt.badge.img+10
  • Author
  • Captain II
  • 1201 replies
  • March 18, 2025

Thank you ​@AdelinaBasyrova75 & ​@hkabiri 

Actually, I tested from the interface and also looked into the Code and what is used for JE Posting date is the PMTran.Date not the PMTran.TranDate. If I simply just create two transctions in one PM Batch and set two different PMTran.Date, platform creates two GL Batches. PMTran.TranDate is just filled with Today’s date. See the below screenshot.

 

 

So, the question still remains that:

1) What is the purpose and use case of PMTran.TranDate?

2) Why it is not available to user?

 

I am going to make this available to users to enter some date for tracking purpose and I want to make sure it will not conflict with a pre-defined use case.


AdelinaBasyrova75
Acumatica Moderator
Forum|alt.badge.img

@aaghaei , project transactions can be created at any day in the past and the future. It will be reflected in the PMTran.Date. For example, the project cost happened on March 18, but we only enter it to the system day later on March 19.

Thanks


aaghaei
Captain II
Forum|alt.badge.img+10
  • Author
  • Captain II
  • 1201 replies
  • March 19, 2025

Thank you ​@AdelinaBasyrova75 but either I am not understanding the responses or responses are irrelevant to the questions. There are bunch of dates in PMTran.

CreatedDateTime: The date a transaction is entered into Acumatica which is March 19 based on your response.

LastModifiedDateTime: The date transaction is last modified. At the time a transaction entered is same as CreatedDateTime.

Date: The date transaction belongs to. In your response it is March 18. This is the date that will drive Financial Period and will be used as Journal Entry Date.

BilledDate: The date a transaction billed to a client used for T&M projects really.

TranDate: I don’t know what is the purpose and use case of it and why it is not available to user?

StartDate: I don’t know what the purpose is and use case of it?

EndDate: I don’t know what the purpose is and use case of it?

 

Please kindly respond only if you know for sure what are these fields.


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