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

Can't save document attachment while Sales-Post has an error

(1) Share

Report

Posted on by EX-18092037-0

Hi everyone

I have a problem with saving the document attachment on Sales Header while posting the document. I saved 2 attachments to the Sales Header Attachment Factbox. I did this on event "OnRunOnBeforeFinalizePosting". If the posting flow doesn't have any error the attachment are successfully saved on the Sales Invoice Heard table, but if any errors happen during the posting flow the Sales Header is reopened again but the attachments are deleted and I want the attachments to be saved when Sales Header is reopened. I also used the Commit method but if I use Commit the document will be posted even if it has any errors.
So what I want is to prevent document from being posted if while the process any errors occurs and my attachments to be saved to Sales Header attachment document.

Can anyone help with this? Thanks in advance!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Although I personally don't recommend it, you can add a Database.Commit() Method

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/database/database-commit-method?wt.mc_id=DX-MVP-5004336

But when you post for the second time or later, you need to determine whether the attachment already exists.

Alternatively, there is actually a standard function that you can use, and you only need to click on it.

Dynamics 365 Business Central: Automatically attaching as PDF to posted sales invoice (Document Attachment)

https://yzhums.com/20657/

Hope this helps.

Thanks

ZHU

Was this reply helpful? Yes No
EX-18092037-0 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Zhu,
Thanks for your answer! The problem is that my function that saves the attachments works correctly when it has not any error during the posting flow, but if an error occurs while posting the Sales Header everything rolls back and the attachments are not saved.
I also used Commit method. The attachments are saved but also the document is posted even though it has an error.
What I want is to save the attachments, but to prevent the document from being posted. Thanks in advance!!

Was this reply helpful? Yes No
SP-19090644-0 22 on at

Like (0)

Report
Copy link

Link copied!

Hi Zhu,

Thanks for your answer. The function that I use to save the attachments works correctly when the posting flow doesn't have any error and the attachments are successfully attached to Sales Invoice Header. The problem is that when an error occurs while posting flow and everything rolls-back my attachments are not saved to the Sales Header attachment document. I also used the Commit method but if I use Commit the document will be posted even if it has any errors.

What I want is to prevent document from being posted if while the process any errors occurs and my attachments to be saved to Sales Header attachment document.

Thanks in advance!

Was this reply helpful? Yes No

Join the conversation

Community site session details

Can't save document attachment while Sales-Post has an error

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

Can't save document attachment while Sales-Post has an error

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates