"Sales Invoice Header" Table

(3) Share

Report

Posted on by JE-20081519-0

2,926

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 60,969 Super User 2025 Season 2 on at

Like (1)

Report

"Sales Invoice Header" Table

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,692 Moderator on at

Like (1)

Report
"Sales Invoice Header" Table

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 12,138 Super User 2025 Season 2 on at

Like (2)

Report

"Sales Invoice Header" Table

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. 19,166 Super User 2025 Season 2 on at

Like (2)

Report

"Sales Invoice Header" Table

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,511 Super User 2025 Season 2 on at

Like (0)

Report

"Sales Invoice Header" Table

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,209 Super User 2025 Season 2 on at

Like (3)

Report

"Sales Invoice Header" Table

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 93,024 Super User 2025 Season 2 on at

Like (0)

Report

"Sales Invoice Header" Table

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