By using this website, you agree to our Terms of Use (click here)
I was poking around the internet this morning looking for step by step instructions for a best practice to copy an existing GI to a new one and came across this. Does everyone know about SM402000 (Merged DB Structure) screen in Acumatica? I didn't, so I am posting in case anyone else did.
Look in the Relations Explorer section of Dmitry's February 27, 2019 blog entry on the Acumatica Developers Blog.
Acumatica Developers Blog -Generic Inquiry Tips and Tricks - Dmitry Naumov
The Blog entry is from over a year ago so I don't know what version of Acumatica it showed up in. The screenshot is from 20.101.0032. It isn't on the sitemap so you will have to enter it in the URL to access it.
-John
It's been there for a few years, but I can't remember what version it got introduced. Definitely one of those hidden gems.
In addition to Merged DB Structure (SM402000), there is also Raw DB Structure (SM401000) which is very similar. You can see them both on the menu just by populating the Workspaces and Category fields on the Site Map (SM200520) screen (the entries themselves are already there):
I personally still prefer looking at the primary keys in the database tables because Merged DB Structure (SM402000) doesn't quite get me that info (although it's close).
It's also worth pointing out that we'll hopefully see more of this kind of thing in 2020 R2. I talked to Vladimir Panchenko at this past Acumatica Summit in Las Vegas and he showed me a prototype where they're planning to introduce this functionality on the Generic Inquiry (SM208000) screen using pieces of these hackathon projects:
Online Members