Questions Database Code Values Using Inspect Element

I just learned this today, but apparently it's been available since Acumatica 2020 R1.

Sometimes when you're working with a formula in a Generic Inquiry, you need to know the codes behind a drop-down value.

I had a way to figure out the codes, but it was kind of cumbersome.

Because it was cumbersome, I documented the codes for AP Documents and AR Documents, but there are lots of other drop-downs and it would be too tiring to document all of them:

https://www.augforums.com/forums/acumatica-generic-inquiries/accounts-payable-document-type-database-code-values

https://www.augforums.com/forums/acumatica-generic-inquiries/accounts-receivable-document-type-database-code-values

Thankfully, since Acumatica 2020 R1, there is a really easy way to find out the database codes behind a drop down.

Let's say we're on the Bills and Adjustments (AP301000) screen. Just go to CUSTOMIZATION -> Inspect Element (Ctrl+Alt+Click)

You can also use the Ctrl+Alt keyboard shortcut if you don't want to use your mouse.

Then click on a drop down field like the Type drop down field in the screenshot below. This will bring up the Element Properties pop-up window that you see here:

What is new is the DROP DOWN VALUES button that you can see in the previous screenshot. You can see the database code values in the Value column:

Isn't that easy?