Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Najeem JanatAli]

Hi All

Is there is main account/chart of account report to see which accounts are suspended and which are deactivated

Thanks and regards

[Beth Zapadka]

Hi Najeem,

I didn’t see this info available in the COA grid for export or within the standard reports, but you can get it by exporting the Main account entity (MainAccountEntity) from the Data Management workspace (columns ACTIVETO and ISSUSPENDED).

——————————
Beth Zapadka
ERP Functional Expert
Glentel Inc.
——————————
——————————————-

[Najeem JanatAli]

Hi 

Beth we are on AX 2012 R3, please advise

thanks and kind regards——————————————-

[Beth Zapadka]

My apologies, my exposure to this ERP started as part of an upgrade from AX 2009 to D365 so I only had temporary view-only access to AX and spent limited time there (past experience is with Oracle). However, I don’t believe there were any changes to this particular table so your dba or technical support should be able to extract the data from there… it likely has the same name too.

——————————
Beth Zapadka
ERP Functional Expert
Glentel Inc.
——————————
——————————————-