You know how you can link a document to an Epicor lot record, right?
En masse, I need to figure out which lots have linked documents. Erp.DocType isn’t a valid table in SQL (see below) and Erp.PartLot.ShipDocAvail doesn’t get me what I need. Field help didn’t.
Any ideas folks?
Best answer by slepley
View original
I believe the table that you want, Agent Mulder, is the XFileRef table. I have a BAQ that probably would be helpful, but I cannot figure out how to share it. Btw, DocType is valid, but what you really want is Ice.DocType.
I don’t use lot tracking, but if it works like all other file attachments that can be associated with a record, the two tables you need are XFileRef and XfileAttach. XFileRef has info about where the attached file resides on your system, and XFileAttach has info about what record in ERP that file is associated with.
Thank you both, and
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.