web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Where is Customer 'Sta...

Small and medium business | Business Central, N...

Suggested Answer

Where is Customer 'Status'?

(0) Share

Report

Report

Posted on by Community member

Hi,

I'm trying to make a dashboard in Qlik Sense.

I am connecting to Business Central in Cloud via API.

When I extract the Customers tables i don't find the 'Status' field.

Which is the table with the Status of Customers?

Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Community member 11 on at

Like (0)

Report

Hi User,

The Status is Field Blocked (Field No. 39).

I hope this helps.

Regards

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, as far as I know, there is no status field for customers in BC. But if you are referring to whether the customer is available or not, I think you can use Blocked field.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

There is no "Customer Status" field in the business central customer table.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 3,229

#2

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans