Recurring Sales Invoices -- "The Item does not exist"

(5) Share

Report

Posted on by JE-20081519-0

3,220

Hi:

We're trying to generate our Recurring Sales invoices but getting the following error:

Error message:
The Item does not exist. Identification fields and values: No.=''

AL call stack:
"Sales Price Calc. Mgt."(CodeUnit 7000).FindSalesLinePrice line 22 - Base Application by Microsoft version 26.0.30643.34307
"Price Calculation - V15"(CodeUnit 7003).ApplyPriceSalesHandler line 51 - Base Application by Microsoft version 26.0.30643.34307
"Price Calculation - V15"(CodeUnit 7003).ApplyPrice line 6 - Base Application by Microsoft version 26.0.30643.34307
"Sales Line"(Table 37).ApplyPrice line 2 - Base Application by Microsoft version 26.0.30643.34307
"Sales Line"(Table 37).UpdateUnitPriceByField line 29 - Base Application by Microsoft version 26.0.30643.34307
"Sales Line"(Table 37).UpdateUnitPrice line 11 - Base Application by Microsoft version 26.0.30643.34307

Please advise if there is a way to view all of the “cards” in Excel for the recurring sales lines to find the missing item issue rather than clicking through all of them.

There used to be a way through the Configuration Worksheet to do so, but we're unable to click into the “standard sales line code” as before.

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (4)

Verified answer

Montassar Krichi 231 on at

Like (3)

Report
Hi,

you can Export via Configuration Worksheet (indirect workaround)
Since the drill-down on table 171 (Standard Sales Line) is not available, try this workaround:

Go to Configuration Packages (search in BC).

Create a new package.

Table ID = 171 (Standard Sales Line).

Click "Fields" and select all fields you want, especially Standard Sales Code, Type, No., and Line No..

Click Export to Excel (you can filter or sort for blank or invalid No. fields).

Look for any rows where:

Type = Item

No. is blank or references a non-existent item

Was this reply helpful? Yes No
Verified answer

Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (3)

Report
The error is thrown during price calculation (CodeUnit 7000 and 7003) because a Sales Line has no valid Item No. — likely a standard sales line linked to a customer recurring invoice setup is missing its Item reference.

Search for: Standard Sales Lines

Click Open in Excel

Ensure you all columns like:

Code (the standard sales code)

Use filters in Excel to:

Filter for Line Type = Item

Then look for No. = blank → these are your troublemakers

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Verified answer

Sohail Ahmed 11,148 Super User 2025 Season 2 on at

Like (3)

Report

it means you've got a blank line somewhere (or a missing item number)

Check if you have done any customization in your DB? Is this error very frequent?

Arrange to debug the error. You should be able to find out the problem immediately.

Once you find the offending record, either delete the record, or put the correct item number into place.

If this helps, please mark it as the verified answer ✅

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (1)

Report

It's getting stuck while pricing calculation not on the sales line, maybe something weired is happening somewhere, don't know if you are from Developers background, debugging will help.

Was this reply helpful? Yes No
Verified answer

Mansi Soni 8,909 Super User 2025 Season 2 on at

Like (5)

Report

Hello John,

The error you're seeing suggests that a recurring sales line references an item with a blank or missing item number, which causes the system to fail when applying pricing. Since reviewing each line manually is inefficient, a quicker way is to use the Standard Sales Lines page (Standard Sales Codes) and then use the Edit in Excel feature (through the Page > Open in Excel or from the Share icon) to export all recurring sales lines. This allows you to filter for any rows where the Item No. field is blank or invalid directly in Excel or else you can simply Debug it if possible.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No