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

​@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.

​@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 

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.

​@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

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.

​@aaghaei , I’d recommend you reporting a how-to support case with the business task/scenario details that you are trying to archive using PMTran table. Thank you! 

Thank you ​@AdelinaBasyrova75 

I have a case open. I usually get a fester resolution on community than creating support case. That is why I posted here. Cheers.

​@raghaei97 , would you like to share the case number with me for further assistance? Thank you

Sure ​@AdelinaBasyrova75 and thank you. The case number is 431294. The response from support team is TranDate is the Business Date but no explanation is provided what use case it has to store the Business Date and hide it from users!

Also I still don’t have answer on StartDate and EndDate. You might have a better luck getting a meaningful answer. 

Thank you for the reply ​@YasasWithanage76. That explains the system behavior but doesn’t make sense. Typically, in Acumatica (and it is how all modules are working) whatever is the Posting Date drives the Financial Period unless user overrides the period. It is so bizarre that a date entered by user drives the Financial Period, and a hidden date is used as GL Batch Posting date that out-of-the-box can’t be verified when a GL Batch Posting date is compared to PM Transactions.
I am going to make PMTran.TranDate visible to users and Call it Posting Date so user knows where the GL Batch Date is coming from.