I would like to replicate the PHR-PH6S report using the RPG so that I can set it up to run on a monthly jobstack. I have been told that I cannot get PHR-> PH6A to run as part of a jobstack because it is a nested report (maybe that is incorrect?)…
I want to be able to (by source) account for my WIP for our monthly parts reconciliation. The closest I have so far is using the PDA Parts file. The bit that I can’t figure is how to give it the date range. I have tried “isn’t closed” and “LM” for transaction close date, neither gives me what I want... WITH QUANTITY GT "0" gives me totals from the beginning of time.
Can anyone tell me how to do this? I have looked at ‘PDA Parts File’ AND ‘WIP’ files already and cannot seem to get a report to match the data that I want.
Anyone have a similar report I can copy? I want to know my WIP by source so I can set it up in a jobstack.