Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Data Deletion - Deleting Invoiced Blanket Sales Orders - Status must be open error message

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

We got quite a few Blanket Sales Orders that are released and we have created the sales orders and shipped/invoiced them already.

When I tried to use the Data Delete >>> Sales Document >>> Delete Invoiced Blanket Sales Orders

I am getting an error message telling me that the Blanket Order status must be open.

Does this mean, all those Blanket orders that was released and completed shipped/invoiced - need to reopen so that we can delete it?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Data Deletion - Deleting Invoiced Blanket Sales Orders - Status must be open error message

    This is the first time we are using this routine. It is a standard routine and we did not customized it.

    Will enable debugger to find out what is causing the issue.

    Thanks for your input.

  • Marcellus Profile Picture
    Marcellus 2,735 on at
    RE: Data Deletion - Deleting Invoiced Blanket Sales Orders - Status must be open error message

    Hi Berlinda,

    I didn't find anything that would throw the error message.

    Have you used the routine successfully before? Do you know if the routine is customised?

    It would be a good idea to enable the debugger while you run it to see where the error message is coming form.

  • Verified answer
    Marcellus Profile Picture
    Marcellus 2,735 on at
    RE: Data Deletion - Deleting Invoiced Blanket Sales Orders - Status must be open error message

    There must be a TESTFIELD(Status, Status::Open) somewhere, let me check.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Data Deletion - Deleting Invoiced Blanket Sales Orders - Status must be open error message

    I was able to delete a blanket order that is already fully shipped and invoiced in a released status manually. There is no error that comes up.

    (I used F4 to delete)

    When I tried to used the process under Data Deletion >>> Sales Document >>> Delete Invoiced Blanket Sales Order

    This is the error I am getting.

    Status Must Be Open in Sales Header Document Type = "Blanket Sales Order", No.= '12-FGDBSO-00002'

    I am just trying to delete just this one blanket order

  • Verified answer
    Marcellus Profile Picture
    Marcellus 2,735 on at
    RE: Data Deletion - Deleting Invoiced Blanket Sales Orders - Status must be open error message

    Hi Berlinda,

    I tried to replicate the problem but for me it worked without errors.

    I tried the released status with and without outstanding qty I also tried it with a approvals enabled.

    Is there anything else in the error message? Is it telling you which Blanket Order is causing the problem? You could try to delete it manually maybe that would bring you closer to the solution.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans