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

Cancelled posted sales invoice

(6) Share

Report

Posted on by CU21011505-2

187

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 (7)

Answers (0)

Sort by

Suggested answer

Teagen Boll 3,198 Super User 2026 Season 1 on at

Like (3)

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
Suggested answer

Grigorios Mavrogeorgis 2,514 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi,

The table you need is Sales Invoice Header, table 112. There is a field called Cancelled with boolean type — if it is true the invoice was cancelled. Also there is a field Closed which is separate thing, so make sure you filter on Cancelled field specifically.

If you need also to find the related credit memo that was created when cancelling, check Sales Cr.Memo Header table 114 and look at the Applies-to Doc. No. field linking back to original invoice.
For the report just filter Sales Invoice Header where Cancelled is true and you will get the list you need.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards

Gregory Mavrogeorgis

Work: GMSOFT Limited
Blog: Inside Business Central
LinkedIn: www.linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Now that you have the page open, you can find this field info using the following method.

Business Central 2023 wave 2 (BC23): Highlight the field in Page Inspection (Quickly locate a field on the page)

https://yzhums.com/44033/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 17,623 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hello,
The flag is on table 112 – Sales Invoice Header, field name Canceled (Boolean). That is the field shown on the Posted Sales Invoice page as Canceled = Yes; Microsoft also confirms that when you use Cancel or Correct, Business Central posts a corrective sales credit memo and sets the original posted sales invoice Canceled field to Yes. So for your report, filter Sales Invoice Header (112) where Canceled = true/Yes; if you also need the reversing document, look at the related posted sales credit memo created by the cancellation/correction.
Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Gerardo Rentería Ga... 27,261 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Correct or Cancel Unpaid Purchase Invoices
Process Purchase Returns or Cancellations
Correct or Cancel Unpaid Sales Invoices

Best Regards
Gerardo

Was this reply helpful? Yes No
CU21011505-2 187 on at

Like (1)

Report
Copy link

Link copied!

Hi

Table 112 does not have a field named cancelled , it has a field named correction but that does store the info that I am looking for , any help please

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 17,024 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

You can go to Posted Sales Invoice Page and Filter the "Cancelled" field with "Yes". You will get the data and can run Analysis Mode as well as you can extract the same in Excel.

Was this reply helpful? Yes No