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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Can't post sales invoi...
Microsoft Dynamics GP (Archived)

Can't post sales invoice - error in table iv_lot_mstr

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

When I try to post a sales invoice, it gives this error:

Uncontrolled database exception. One operation remove in the table 'iv_lot_mstr' failed because it couldn't block the record.

Then, the sales invoice goes to Batch recovery. In that window, it doesn't post either giving the same error.

The edit list doesn't show any error. I don't understand.

Does anybody know what is the problem?

I'm using GP 10, SP4 ESLA.

 

Thanks,

JCF

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Can't post sales invoice - error in table iv_lot_mstr

    Did you ever get any resolution for this?  are you using any ISV's?  

    We are running into this same issue at a client.

    Thanks!

    Devon

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Can't post sales invoice - error in table iv_lot_mstr

    JCF,

    Couldn't block the record or lock the record?

    No matter, I would try this first -

    1. have everyone exit dynamics

    2. close any windows you may have open

    3. delete any records in the tables SY00800 and SY00801 in the Dynamics database

    4. delete any records in the DEX_LOCK AND DEX_SESSION tables in the tempdb

    If that didn't work, I'd have to go research that record to see if it was included on any other record.

    Hope that helps.

    Kind regards,

    Leslie

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans