Delete Blank Purchase Quotes

(4) Share

Report

Posted on by Marcella Affonso

224

Hi, I'm trying to select multiple lines and delete purchase Quotes but I can't, I noticed that if I select 2 lines the 'delete' is greyout. I also tried Config pack in our sandbox but if I select 'delete table' it will delete PO (because they use the same table 38)

Any tips how to do this faster?

thanks,

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Marcella Affonso 224 on at

Like (4)

Report
Copy link

Link copied!

Update: I used 'edit in Excel' and it worked, thanks!

Was this reply helpful? Yes No
Verified answer

Sohail Ahmed 11,169 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!
Hi Marcella,

You’re right — since Purchase Quotes and Purchase Orders share the same table (Table 38 - Purchase Header), deleting quotes selectively can be tricky using a configuration package.

Here are two practical options:

✅ Option 1: Use Edit in Excel

You can use the Edit in Excel feature from the Purchase Quotes list page. Once exported:

Filter by Document Type = Quote

Remove the ones you want to keep

Delete the rest directly from Excel and publish — this allows batch deletion safely.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,169 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!
✅ Option 2: Add Custom Action Button in AL

If you're a developer or working with one, you can extend the Purchase Quote List page and add a new action to delete selected quotes. Here's a quick example:

codeunit 50100 "PurchaseQuoteMgt" { Permissions = tabledata "Purchase Header" = RIMD, tabledata "Purchase Line" = RIMD; procedure DeleteSelectedQuotes(var RecPurchaseHeader: Record "Purchase Header") var PurchLine: Record "Purchase Line"; begin if RecPurchaseHeader.FindSet() then repeat PurchLine.SetRange("Document Type", RecPurchaseHeader."Document Type"); PurchLine.SetRange("Document No.", RecPurchaseHeader."No."); if PurchLine.FindSet() then PurchLine.DeleteAll(); RecPurchaseHeader.Delete(); until RecPurchaseHeader.Next() = 0; end; }

pageextension 50101 "ExtPurchaseQuoteList" extends "Purchase Quote List" { actions { addlast(Processing) { action(DeleteSelectedQuotes) { Caption = 'Delete Selected Quotes'; Image = Delete; trigger OnAction() var SelectedQuotes: Record "Purchase Header"; QuoteMgt: Codeunit "PurchaseQuoteMgt"; begin CurrPage.SetSelectionFilter(SelectedQuotes); QuoteMgt.DeleteSelectedQuotes(SelectedQuotes); end; } } } }

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,941 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Edit in Excel should be the first step as its the easiest one.

You can use configuration package as well, it will do the same job.

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 5,166 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

The simplest thing would be to delete using the Edit option in excel.

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, hope the following helps as well.

Dynamics 365 Business Central: How to bulk delete data on a list page that includes a Card page (For example, bulk delete items on the Item List page)

https://yzhums.com/60227/

Thanks.

ZHU

Was this reply helpful? Yes No