For audit purposes we are being asked for information regarding the Suppliers we have added within last 6 months to a year, does anyone have advice on how to get this information ? BAQ Query? Report? Supplier Tracker?
1 Like
There is no field on the vendor table that records the date it was created. Do you have change logs enabled for vendor? If not, you may need to make a query to find the first PO/ recvdtl or invoice related to each vendor to get an approximation.
If you need this information in the future to be more precise, you could create a UD field to store this information and a BPM to write a create date to it.
Maybe others have better ideas for you.
3 Likes
If no change logging done on the Vendor table - do something with the APInvHed/APInvDtl tables and take the first payment date. Not all vendors are going to have PO receipts - services/utilities/etc.
4 Likes
Makes sense, I was thinking of a union BAQ from multiple sources to find the first date from them. Either way it’s an approximation :).
1 Like
More than one way to build a mousetrap. 
1 Like
You’re on the right track. Just take fields Company, VendorID and Name. Group them and also grab the Min value on InvoiceDate and that should work.
Got it followed same format
Results :
And just to understand , so exactly how I have it filtered from 1-1-25 to 11-11-25 , these are the Suppliers we have added from that time frame. As the data is calculated on the minimum ( 1st) invoice date of that Supplier?
Yes, that would be the first invoice date for the vendor in question. The vendor record may have been CREATED in Kinetic prior to that date…but seeing that the create date is not tracked in base, and if you don’t have a change log set up for the Vendor table, this is likely as good a guesstimate as you’re going to get.
1 Like
Thank you very much for your help!! 
1 Like
The other option could also include the first PO date… but that would only work for venders that you create POs for, but not for non-PO suppliers (Utilities, etc)
Agreed - that’s why I pointed to the APInvHed approach - non PO vendors.
Could have also gone with CheckHed for payment dates…but that’d be less accurate due to payment terms…i.e. if vendor is net 60, payment might be made in March for a vendor added in January.
1 Like
Or you could take a minimum of all those values, possibly even including the min date of any change log record for the supplier if there is one… like @JMPCONJ said, more than one way to build it
Isn’t there an existing Idea to add Created Date and By to these types of tables?
Yes… see idea: Log In - Epicor Identity
2 Likes
Ok, so I’m not crazy. 
1 Like
well.. dont put word in my mouth… hahahaha
3 Likes
still vote for the idea people!