Order Tables and MiscShip Tables

[aarong (Aaron Gulley)]

Hi All,

Has anyone linked these tables together? Epicor Consultant said it wasn’t possible.

Kind regards,
Aaron.

[Fernando]

You should be able to join on MscShpHd.OrderNum = OrderHed.OrderNum
What does the report need to display?

[aarong (Aaron Gulley)]

I do not believe it’s that simple a lot of the order number information isn’t filled in… Just the job number which doesn’t match the job number on the order tables.

Nothing to join it to the order tables… I need to think of another way.

[Fernando]

Wait are you trying to join JobNum’s ? the MscSHpHd has that field also.

MscShpHd.JobNum = JobHead.JobNum