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... Cancelled posted sales...

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

Suggested Answer

Cancelled posted sales invoice

(0) Share

Report

Report

Posted on by CU21011505-2

108

Hello

I need to produce a report and I need to identify the posted invoices that were cancelled. Which table (ID) will have this information stored and what is the table id and the field name please.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Teagen Boll 2,460 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

That is stored in the Sales Invoice Header table (Table 112) under Field 1310 as a boolean:

If you want to see the related credit memo used to close it you can also look at a few different areas, one of them is the Sales Cr.Memo Header table (Table 114) and you can see the Applies-to fields that are populated if you use the cancel feature:

You can always use the inspect function in BC to explore pages and tables. You can read more about it here: Inspecting pages - Business Central | Microsoft Learn

Best,

Teagen Boll

Work: Catapult ERP

Social: LinkedIn

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 2,034 Super User 2026 Season 1

#2

YUN ZHU 1,199 Super User 2026 Season 1

#3

AndrewThomas81 1,080

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans