Posted Sales Invoice

(6) Share

Report

Posted on by RD-11011729-0

133

Hello

I trying to run a report of posted sales invoice with the invoice line details and for a few customer no's I get an error message as below

The Filter "AB Retail" is not valid for the Bill-to Customer No. field on the Sales Invoice Header table. An error occurred while interpreting the filter: Did not expect value 'S INDES''.

These particular customer records I set it up using the configuration package and also created the sales invoices using configuration package . What could have gone with these accounts either with setting up the customer records and or creating sales invoices.

I was trying to run the report by selecting Sales / Posted Sales invoices /Print Send / Print

Appreciate some help here and how to I fix this issue

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (3)

Sort by

Suggested answer

RockwithNav 9,191 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Is this a custom Report or a standard one?

Seems some modification on the base reporting if it is - Error is simple as incorrect information is going to the incorrect column.

Try uninstalling all external extension and then see it works well.

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report
Copy link

Link copied!

I also think this doesn't seem to be a standard issue. Is this a custom report?

Below is a standard report, which hopefully will give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

OussamaSabbouh 17,676 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

This is caused by bad data imported via the configuration package: for those customers, the Bill-to Customer No. on posted Sales Invoice Header (Table 112) contains invalid characters (most commonly a trailing apostrophe ', extra spaces, or text instead of a proper customer number), so when BC builds filters for the Print report it fails with “Did not expect value …”. It usually happens when the config package source file had quotes/special characters or mapped the wrong column (e.g., name into No.). To fix it, identify the affected posted invoices, confirm the exact value in Bill-to Customer No., and clean the data (rename customers to safe codes or perform a controlled data correction for posted invoices); as a workaround, print invoices individually until the data is corrected.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

RD-11011729-0 133 on at

Like (1)

Report
Copy link

Link copied!

Thanks Everyone

This is a standard report , printing a PDF invoice works fine , just that when I want to run the Excel document data only report I get this issue. I have identified the customer no that is causing the issue . The annoying thing is that when I want to run the report for a date range and if the invoice in question is falls with in the date range then the report does not generated . is there a easy way to clean this customer record

Was this reply helpful? Yes No