Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Recurring Sales Invoic...
Small and medium business | Business Central, N...
Suggested answer

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

(2) ShareShare
ReportReport
Posted on by JE-20081519-0 1,925
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
  • Suggested answer
    Montassar Krichi Profile Picture
    Montassar Krichi 124 on at
    Recurring Sales Invoices -- "The Item does not exist"
    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:
    1. Go to Configuration Packages (search in BC).
    2. Create a new package.
      • Table ID = 171 (Standard Sales Line).
    3. Click "Fields" and select all fields you want, especially Standard Sales Code, Type, No., and Line No..
    4. Click Export to Excel (you can filter or sort for blank or invalid No. fields).
    5. Look for any rows where:
      • Type = Item
      • No. is blank or references a non-existent item

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,452

#2
YUN ZHU Profile Picture

YUN ZHU 1,313 Super User 2025 Season 1

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans