Hello Prashanth,
I am not getting any Job Numbers populated on the query. In addition, I need to pull information from Job Operations that have outside processing.
My setup below:
If you are looking for historical outside processing receipts to jobs, maybe try looking at parttran which should have most everything, once you find the proper TranType.
Your dates might be off due to an inspection in between? On PartTran, the TranType into the job is PUR-SUB if there is no inspection done or INSP-SUB if there is inspection done. You could use a constant list to pull both as there shouldn’t be a case of duplicates, the system will either use one or the other based on your configuration.