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

Purchase Invoice already exists message with no previous postings

(0) Share

Report

Posted on by Luis Ochoa

I am trying to migrate the date form our old software using SNC Datev, and I keep getting the error "Purchase Invoice XXX already exists", even though I made sure there is no duplicate in the source file, and there are no previous postings. Furthermore, none of the invoices have more than 20 characters (BC limit).

Does anybody know why this happens?

Is there an easier way to migrate the postings using something already in BC and not an external product?

Thank you so much in advance!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

This may not be referring to the Document No field but rather to the Vendor Invoice No or External Document NO field.

Was this reply helpful? Yes No
Luis Ochoa on at

Like (0)

Report

Yes, when using SNC Datev the Document No field gets filled with the invoice number from the vendor, but there is no duplicate in the CSV file.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, SNC DATEV is not a standard feature of BC, I think you should contact the partner.

https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/pubid.sievers-group%7Caid.snc_datev%7Cpappid.0672b665-308b-4613-bc5e-c7e865740d11?tab=overview

Or you try using Configuration Package?

https://yzhums.com/4286/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Luis Ochoa on at

Like (0)

Report

Hi, thank you for your reply.

Is it possible to post to General Ledger the items I import using the configuration package?

Thanks again.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the following helps.

How to use Configuration Package to post documents (Sales Order, Purchase Order, Transfer Order, General Journal, etc.)

https://yzhums.com/16530/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

Hi

Of course you can use Configuration Packages to migrate your data.

the error you receive on the invoice number could be due to a code error in your system, as it is not standard BC

learn.microsoft.com/.../set-up-standard-company-configuration-packages

DAniele

Was this reply helpful? Yes No
Luis Ochoa on at

Like (0)

Report

I have more information about the error we are presenting. Today we tried posting the entries with a new invoice number series. At first it worked, but the posting was made with the wrong date. So we tried reversing the posting using the G/L Registers archive, and then posting again using the same information. When doing this, we got again the error message of a purchase invoice being duplicated. Then I assume the system is keeping the invoice number stored somewhere and detecting it has a duplicate.

When I go to posted purchase invoices I see nothing. However, if I go to "Find entries" and look for one of the documents with the invoice numbers we created, there are results for it. So I believe the system is seeing this and recognizing it as a duplicate.

Is there a way to remove the entry (all the entries) from BC so it won't recognize it at all?

Thanks again.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, first if you want to cancel the Posted Purchase Invoice, you must cancel it from the Posted Purchase Invoices screen.
If you created it from General Journal, no problem.

In addition, Reverse does not mean deletion, it just recreates the negative entries to cancel the original data.

You can use the function below to renumber.

Finally, the Entries data that has been posted cannot be deleted.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Luis Ochoa on at

Like (0)

Report

Hi. Thank you for your reply.

That's precisely the issue. There is nothing in the posted purchase invoices screen:

Was this reply helpful? Yes No