Solved

Tenant Creation Date

  • 23 September 2022
  • 10 replies
  • 61 views
K
Rank

Is there a way to find the creation date of a tenant?  We’re interested in knowing the creation dates for the tenants in our sandbox.  Thanks.

icon

Best answer by Kandy Beatty 23 September 2022, 18:10

View original

10 replies

khalme
Rank
Userlevel 2

Another option, if you only need to quickly find the dates, is to use the Source Data link on the Schema Browser (if your version has it).

 

Kevin Halme
K
Rank

@kbeatty21 Thank you!  The GI is very helpful.  I appreciate your help.

@RohitBhandurge Thank you for finding the table.

RohitBhandurge
Rank
Userlevel 5
Badge

Hi @kenr  and @RohitBhandurge 

Here is a quick GI that may help:

 

 

@kbeatty21 - This could do the job since UPHistory is the only table keeping the history of tenants.

Rohit Bhandurge - Forever Grateful!
Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @kenr  and @RohitBhandurge 

Here is a quick GI that may help:

 

 

1 Attachment
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
RohitBhandurge
Rank
Userlevel 5
Badge

@RohitBhandurge

“There should be a way to pull this on the front end.”

 

That’s what I’m looking for, but haven’t found it.

Try with a GI for UPHistory.

Rohit Bhandurge - Forever Grateful!
K
Rank

@RohitBhandurge

“There should be a way to pull this on the front end.”

 

That’s what I’m looking for, but haven’t found it.

RohitBhandurge
Rank
Userlevel 5
Badge

@kenr - UPHistory gave me this information.

 

There should be a way to pull this on the front end.

The only thing to add is that you would need SQL access @kenr 

@kbeatty21 @kenr - Right. You can write a GI for “UPHistory” table.

 

Rohit Bhandurge - Forever Grateful!
Kandy Beatty
Rank
Userlevel 7
Badge +16

@kenr - UPHistory gave me this information.

 

There should be a way to pull this on the front end.

The only thing to add is that you would need SQL access @kenr 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
RohitBhandurge
Rank
Userlevel 5
Badge

@kenr - UPHistory gave me this information.

 

There should be a way to pull this on the front end. You can pull this in GI.

Rohit Bhandurge - Forever Grateful!
RohitBhandurge
Rank
Userlevel 5
Badge

@kenr - Surprised to see there is no table called UPCompany in the sql.

Rohit Bhandurge - Forever Grateful!

Reply


Terms & ConditionsCookie settings
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