By using this website, you agree to our Terms of Use (click here)
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:
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?
Online Members
