web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Purch. Inv. Header Alr...
Small and medium business | Business Central, N...
Answered

Purch. Inv. Header Already Exist Error on Prepayment Invoice

(0) ShareShare
ReportReport
Posted on by Anita75 1,165

Hi All,

I get the well know error as below when creating a purchase prepayment invoice.

The record in table Purch. Inv. Header already exists. Identification fields and values: No.='100003'

There are few threads on this and the conclusion is somehow delete this record from table. My question is how do we do this in SaaS environment?

Already checked number series and there isn't anything unusual and try to set the next number and redo but no luck

thanks

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    Can you not use an OnBeforeInsert event subscriber to check? This is assuming the number has been allocated from the number series before that point.

  • Verified answer
    Dirk Profile Picture
    Dirk on at

    Hello,
    I would suggest to create a service request with Microsoft to get this investigated and resolved.
    Thanks
       Dirk

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Anita,

    This might be the reason but please check...

    On the Purchase & Payable setup the Posted Prepmt. Inv. Nos. field, drill in and see if the Last No. Used is correct (pic below). It might show a value that is incorrect or out-of-sync and you need to resolve. In your case, 100003, per the message, has been used but the No. Series thinks the Last No. Used = 100002.

    pastedimage1610119837342v1.png

    Again, just a theory to check. And you can also go to Posted Purchase Invoice and see if you find Document 100003.

    Thanks,

    Steve

  • Anita75 Profile Picture
    Anita75 1,165 on at

    Prepay-no.jpg

    Thanks everyone for the suggestions and number series overlapping looks like the cause but I'm not sure if this by design or a bug ..so I looked at Cronus as above

    In Cronus prepay and Inv+ numbers are different series (at least to start with as theoretically they can catch up), Since they both use the same table maybe you cannot start both say from 100001,  BUT I'm not sure if this the intended design

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,066

#2
YUN ZHU Profile Picture

YUN ZHU 658 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 595

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans