How can I get the following fields related to the Purchase Order?

Epicor ERP 10
1

I’m doing a Query between a lot of tables (POHeader, PODetail, PORel, Vendor, JobHead, ShipVia, PurAgent, etc.) but there’s some informations that I can’t find in Epicor:

  1. The shipping date of the PO
  2. The received quantity so far of each line
  3. Who released the job related to the PO Line

Are these fields directly in the database in some table or is there any way so I can get what I want with some other queries.

Thanks

2

For #1 - On PO’s there are several kinds of dates which can vary by release.

  • The Header has fields for Due Date, Promise Date, and Post Date. If these are entered, new lines & Releases will use these as their default.
  • Release’s have Due Date and Promise date fields. And can vary from the header, other lines, or other releases.

#2 Received Qty can be found by linking to RcvDtl. Joining the PONum, POLine, and PORelNum to the PO. Make sure its an outer join

#3 The Job info can be obtained by linking JobHead to PORel.JobNum

This would require a lot of outer joins, to prevent missing info. A sub-query may be in order.

3

Thanks !

But for #3, what is the field in JobHead where I know WHO released the job? I can’t find it at all in the database nor in the extended properties

4

There isn’t a specific field for who clicked the “Released” button on Job Entry. You could add a Data Directive to store the user that did that in one of the UserChar fields of the JobHeader.

However, the user ID of the person that created the Job (assuming the creator is the one that eventually releases it), is in JobHead.CreatedBy

1 Like
5

I thought about creating or using an UD field but I wanted to know if it was stored anywhere before doing that.

CreatedBy would be a good indicative but since it’s not always the same person, I’ll pass on that.

Thanks for confirming it.