"Sales Invoice Header" Table

(3) Share

Report

Posted on by JE-20081519-0

3,549

Hi:

When reporting on data in the Sales Invoice Header table (112), how do you exclude credit memos?

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Mohana Yadav 61,204 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Credit memos will be in a different table called "Sales Cr.Memo Header"

why did you think that Sales Invoice Header table has credit memos?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,794 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi,

If you're building a custom report in AL, you can explicitly filter the Sales Invoice Header table and related data. Example:

procedure GetSalesInvoicesExcludingCreditMemos() var SalesInvoiceHeader: Record "Sales Invoice Header"; begin SalesInvoiceHeader.SETRANGE("Cancelled", false); // Exclude canceled invoices SalesInvoiceHeader.SETRANGE("Closed", false); // Exclude fully applied/closed invoices if SalesInvoiceHeader.FINDSET then repeat // Process your sales invoice data here until SalesInvoiceHeader.NEXT = 0; end;

Check this code if it works for you.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,803 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello

Yes Both the Tables are different.

Sales Invoice Header - 112

Sales Credit Memo Header - 114

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,130 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

if this help:https://community.dynamics.com/forums/thread/details/?threadid=ad018b47-507f-ef11-ac21-7c1e520c9c19

https://bcentral.dev/nav/2016/w1/table/sales-invoice-header

https://bcentral.dev/nav/2018/w1/table/sales-crmemo-header

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,547 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can use the filter option or exclude negative amounts to refine the data. However, does this apply to the Sales Invoice Header?

Also, the Sales Cr. Memo Header table number is different from the Sales Invoice Header—I believe they are 112 and 114, respectively.

Thanks! Ramesh

If this helped you, please check the box Does this answer your question?

Was this reply helpful? Yes No
Verified answer

Teddy Herryanto (Th... 14,302 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

The Invoice and Credit have different tables.

Sales Invoice Header - 112
Sales Credit Memo Header - 114

If you want to exclude a cancelled invoice, you can filter out the Cancelled field.

SalesInvoiceHeader.SetRange(Cancelled, false);

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If you only want the Header, you can also use Cust. Ledger Entry (21).

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No