web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Blanket Purchase Order...
Small and medium business | Business Central, N...
Suggested answer

Blanket Purchase Order - Send

(1) ShareShare
ReportReport
Posted on by CJ-08091921-0 2
Hello, 
I'm receiving an error message when trying to email a Blanket Purchase Order. Specifically using the Send functionality under the Print/Send. The Send by Email option works as desired. The Send by Email and Send option work as desired from the Purchase Order. This is limited to the Send and Blanket Purchase Order combination. 
 
I have attempted this in multiple environments and receive the same message. It appears to be a bug. But wanted to verify with the community. 
 
The error mentions the Standard Sales -Quote. Here is the message received: "The Standard Sales - Quote report does not have a DataItem that uses the table (Table 38 Purchase Header) specified in the function SetTableView."
 
I have reviewed the document layout on the vendor and the report selection - purchase and the setups are correct. 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 90,179 Super User 2025 Season 2 on at
    Blanket Purchase Order - Send
    Hi, You can try submitting your issue to the following two places first, and Microsoft technicians should be able to handle it when they see it.
     
    Thanks
    ZHU
  • Suggested answer
    PRao Profile Picture
    PRao 268 on at
    Blanket Purchase Order - Send
    This issue is occurring when the system tries to call the SetTableView function on the Standard Sales - Quote report (a sales report), but passes it a record from the Purchase Header table (Table 38, which is used for purchases). The error occurs because the sales report is not designed to accept data from the purchase table.
     
    Looks like there is bug in the base AL code issues. 
     
     
    Try with below troubleshooting ..

    How to fix the error
    You need to correct the report selection settings in Business Central to use the correct report for purchase-related documents.
    Search for Report Selections-Purchase. Use the search bar (magnifying glass) in Business Central and type "Report Selections-Purchase.".
    Locate the document type. In the Report Selections-Purchase page, find the entry for the Blanket Order document type.
    Correct the report ID. Check the Report ID associated with the Blanket Order document type. It is likely that the current setting is using the ID for the Standard Sales - Quote report instead of a correct purchase-related report.
    Select the correct report. Choose the correct report for blanket purchase orders. The standard report is usually called Standard Purchase - Blanket Order or something similar.
    Save your changes. After selecting the correct report, save the changes to the report selection settings.


    Additional troubleshooting steps

    Check other purchase documents. While you are in the Report Selections-Purchase page, verify that the correct reports are assigned to other document types, such as Order and Quote, to prevent similar errors in the future.
    Check customizations. If a customization is in place, the issue may be due to custom code that is incorrectly referencing a sales report. If the problem persists after correcting the report selections, a developer may need to investigate the custom AL code extensions.
     
     
    Thanks, 
    PRao
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 22,623 Most Valuable Professional on at
    Blanket Purchase Order - Send
    Hi
    It seems to be a report configuration issue, where a sales report is being cross-referenced with your sales operations.
    Do you have any customizations for this feature?
    Best
    GR

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,669 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,668

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,203

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans