Hi All,
Im trying to customise our job traveller to include the Customer ID in the header of each page. Ive figured i could like to the Demand which could link to the Customer ID on the Sales Order but havent been able to get it to show anything. Has anyone done this before that could help? I understand that epicor doesnt really link jobs to Sales Orders but rather to Demands that could come from anywhere the production team use the Customer Id to keep track of jobs on the floor.
Are you linking to JobProd to get the demand link? Also, do you have multiple demand links on your jobs?
JobTrav already includes customer “calc” fields under the JobHead table.
They’re in the RDD:
But if I remember correctly they were NOT included in the stock RDL. So you have to add them to the RDL query and as query fields, then you can use them.
HI Mate could you break this down for me the report currently looks like this but im not getting anything showing up ion the travelers where i have the customer field
Did you add the column to your query?
It is on JobHead, so would be T1.Calc_custName.
In case it helps… here are some snips from my set-up:
RDL Query:
Field Expression:
My set-up is a little different as I’m also setting it up to show a ContractID
Result:
