Small and medium business | Business Central, N...

Delete multiple document attachement

(1) Share

Report

Posted on by Alejandro Bohorquez

101

Hi everybody,

We have the following case, we need to delete multiple documents from the table in the picture, we need to do it for Purchase orders and posted purchase orders, I'm trying with add-in edit excel which works but only for one document at a time.

Any idea for a way to do it by batch

Thanks in advance if someone can help me

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

pankaj.k 1,020 on at

Like (0)

Report
Copy link

Link copied!

Hi Alejandro,

you need to create one Batch Job That is based on Table "Document Attachment" Id: 1173

you can choose 1. "Document No filter" 2."table no Filter". etc

Have a great day!

Don't forget to help the community by verifying the answer if your question has been answered. It will let others know that the topic has verified answer.

Thanks,

Contact Info: kuwalpankaj97@gmail.com

Was this reply helpful? Yes No
Alejandro Bohorquez 101 on at

Like (0)

Report
Copy link

Link copied!

Hi

Thanks for your answer, It's possible that you can give me what steps I must follow to do the batch job?

Was this reply helpful? Yes No
Suggested answer

pankaj.k 1,020 on at

Like (0)

Report
Copy link

Link copied!

Hi Alejandro,

Please use the below code that will help to delete document one by one on the bases of Document No..

report 60005 DeleteAttechment

{

UsageCategory = ReportsAndAnalysis;

ApplicationArea = All;

ProcessingOnly = true;

Caption = 'Delete Attechment';

dataset

{

dataitem(DocumentAttachment; "Document Attachment")

{

trigger OnPreDataItem()

begin

DocumentAttachment.SetFilter("No.", DocumentNoVar);

end;

trigger OnAfterGetRecord()

begin

if Confirm(DocumentAttachment."No.") then

DocumentAttachment.Delete(true);

end;

}

}

requestpage

{

layout

{

area(Content)

{

group(GroupName)

{

field(DocumentNoVar; DocumentNoVar)

{

ApplicationArea = All;

TableRelation = "Document Attachment"."No.";

}

}

}

}

}

var

DocumentNoVar: Text;

}

Have a great day!

Don't forget to help the community by verifying the answer if your question has been answered. It will let others know that the topic has verified answer.

Thanks,

Contact Info: kuwalpankaj97@gmail.com

Was this reply helpful? Yes No
Alejandro Bohorquez 101 on at

Like (1)

Report
Copy link

Link copied!

Hi

Thanks for your answer we'll check this option.

Best regards.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Delete multiple document attachement

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

Delete multiple document attachement

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates