# Missing PartTran Records **Category:** [Vista/Vantage 8](https://www.epiusers.help/c/vantage-8/8) **Created:** 2016-11-03 15:29 UTC **Views:** 847 **Replies:** 3 **URL:** https://www.epiusers.help/t/missing-parttran-records/36086 --- ## Post #1 by @ckrusen While researching a problem, I found that there are missing records (a gap in TranNum's) in our PartTran table Below is a snapshot of the query of the PartTran table. Notice how the TranNum's jump from 208704 to 208707. And the original issue I was researching was that Packer 25566 had two STK-CUS lines, but we can't find any transactions for the one line. I didn't think any process ever deleted PartTran records. --- ## Post #2 by @johndack Hi, Didn’t get some transactions done with a date in the future did you? This has happened to me before Regards, John --- ## Post #3 by @ckrusen I though about that. But my query above only limits the TranNum >= 208700. So it should have shown anyway. (Unlike the Part Transaction History Tracker - which uses a cutoff date). Also Tran 208707 was actuall line 2 of the Packer. So the missing trans (208705 and 06) would have been from the same packer and created at the same time. --- ## Post #4 by @ctkunkel It is sad but true, you may find their are unused and duplicated transaction numbers. I know this through analysis of my company's PartTran table entries. I believe these transaction numbering errors are related to either App Server hangs or crashes. Carl --- **Canonical:** https://www.epiusers.help/t/missing-parttran-records/36086 **Original content:** https://www.epiusers.help/t/missing-parttran-records/36086