Overall how many standard fields are there in Acumatica ? Is there a way in the system I could see the number of standard fields for a specific module ?
Answer
I understand ther are currently 200 plus screens in Acumatica . How many standard fields are there in Acumatica ?
Best answer by Naveen Boga
Unfortunately, we don’t have a place to see the count of fields but you can Inspect Element and click on the DAC, so that you can see the fields in that particular DAC.
SELECT
TABLE_NAME,
COUNT(*) AS FieldCount
FROM
INFORMATION_SCHEMA.COLUMNS
GROUP BY
TABLE_NAME
ORDER BY
FieldCount DESC;
+19 HI
In the site map, we can also see the Reports and Generic Inquiry, you can ignore them if required.
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
+19Unfortunately, we don’t have a place to see the count of fields but you can Inspect Element and click on the DAC, so that you can see the fields in that particular DAC.
SELECT
TABLE_NAME,
COUNT(*) AS FieldCount
FROM
INFORMATION_SCHEMA.COLUMNS
GROUP BY
TABLE_NAME
ORDER BY
FieldCount DESC;
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.