Is there a way to find who created the Lot Number Something appeared with the same Lot Number but different Part.
Unless there is a created by field. adding logging would help you for future lot auditing.
How do you add logging?
That would be a data directive on the table. there is a logging widget.
So for this one we can’t really tell who created this?
Correct that is the widget. You don’t have to have a condition. the widget covers add/changed for you.
I thought it was on the lot creation.
First transaction should be where the lot was created (in my example the PUR-STK receipt)
Hi John,
I have in the image above. there was the two Lot Number both the same but different Part. and the other one is mostly blank with no user ID we were wondering how we had that and who created that. 
there are a bunch of them
Check the table PartLot - keys are Company, PartNum and LotNum.
Looks like it’s part-number centric, so you could have lot #123456 under Part A and under Part B.
PartNum is the second column from the left (labeled as “Part” in the heading).
If you use the Lot Tracker on the two part/lot combinations you pointed out earlier, you should be able to find the first transaction (presumably PartTran records) for each of them.
Hi John. It’s not even on PartTran table
Do this - write a BAQ against PartTran with the following fields
- Company = whatever company you’re in
- PartNum = selfexplanatory
- LotNum = same
- TranNum
- EntryPerson
Sort by TranNum - first transaction should be the one where the lot was created.
Hi John I found it in the PartLot table but its not in the PartTra table. is there an Entry person in PartLot?
PartTran has the field EntryPerson. It’s the only table you need for this. You know what parts and lots you’re looking for…if you sort by TranNum, the earliest transaction should be the one where the lot was created.
PartTran is the only table you need. Already specified the fields.