Purchase Invoice #### already exists

Ms10Key
Member Posts: 13
Hi All,
My client (v5.0 SQL) receives the following error while posting a Purchase Journal, "Purchase Invoice #### already exists". I have reviewed the G/L Entry Table and the Purchase Invoice Header Table and did NOT find the related Document No. I also reviewed the No. Series which recorded the Last No. Used as 2 numbers BEFORE the number that errored. Also, we are using a Posting No. Series on the batches because multiple users have their own journals. Because the batch lines were each in balance, the batch posted up to the line with the error and then stopper. There are a few lines remaining in the journal. Other clients have complained about similar issues and we were not able to replicate the issue. Any ideas? Thanks for you assistance. ](*,)
My client (v5.0 SQL) receives the following error while posting a Purchase Journal, "Purchase Invoice #### already exists". I have reviewed the G/L Entry Table and the Purchase Invoice Header Table and did NOT find the related Document No. I also reviewed the No. Series which recorded the Last No. Used as 2 numbers BEFORE the number that errored. Also, we are using a Posting No. Series on the batches because multiple users have their own journals. Because the batch lines were each in balance, the batch posted up to the line with the error and then stopper. There are a few lines remaining in the journal. Other clients have complained about similar issues and we were not able to replicate the issue. Any ideas? Thanks for you assistance. ](*,)
0
Comments
-
There may be two reasons:
1. Some modifications in the code
2. Check the External Document No field for duplicates.0 -
DO the user post in multiple companies often? using the same naming system in each company?
If the user deletes their ZUP does the issue go away ?0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions