Share
Report
1,970We went live with the HITB at the end of June. Both the detail and the summary reports ran perfectly for June and July. At the end of August, I noticed that the summary report wouldn't run. It gives this error message: [Microsoft] [SQL Native Client] [SQL Server] Violation of PRIMARY KEY constraint 'PK##0422252'. Cannot insert duplicate key in object 'dbo.##0422252'.
I tried running the report each day in August and found that the error starts August 5. I looked for duplicate entries on August 5 and didn't find any. I did find that we did a standard cost revaluation on this day though, and I changed the inventory account number before posting the revaulation entry. I also changed the inventory account number on the item card. I'm wondering if this change I made after the revaluation was done but before it was posted is causing the error. I corresponded with a consultant we use, and she didn't think this would cause the error and suggested checking links. I've checked links on sales work and history; purchasing history and transactions; and inventory bill of materials transaction history, bill of materials transactions, inventory control, inventory landed cost cards, inventory purchase receipts, inventory transaction work, and stock count history. I didn't see a way to check links on inventory transaction history.
Does anyone have any suggestions on this? I'm still able to run a summary smartlist on the data in the table but I can't run a summary HITB report for any day August 5 or after. I can't help but think that it's due to the change I made on August 5 before posting the revaluation entry, but I don't know how to check that.
*This post is locked for comments
All responses (
Answers (
