I’m working on a custom version of the PO Report where we need to see all the PO releases as well. The issue I have is that the report isn’t listing all the releases.
This is what I get from the report.
I’ve already un-excluded PORelNum from the Data Def,
and added the field to the dataset query.
I’m not sure why it won’t work. Any ideas would be appreciated.
Are you displaying only open releases? And you need to calculate the OpenQty:
PORel.XRelQty - PORel.ReceivedQty
All of the releases on that PO are open, I don’t think that’s criteria being checked either. This is a custom version of the standard PO Report, where I’ve really only changed stuff in the rdl, so I haven’t set it to pay attention to whether a release is open or not. What do I need that Qty for?
If you want to calculate the value of open POs, the release qty would not reflect accurately, since a partial receipt could happen and therefore the release quantity would not work. You need the openqty * unitprice to get the open value on a release.
Oh gotcha, I’ll change that too then, thank you. I still have the problem with my release problem, though. What I’m imagining is a third line in the first screenshot I posted where It says Line 2, Rel 2. I just cannot figure out why it isn’t doing that.
I’m not sure about the datadef, but I have an Open PO Dashboard that includes unitcost and total cost (openreleases * unit cost). The grand total in the dashboard matches with the total in the Epicor Report - Open Purchase orders.
No problem, thanks for the input on the RelQty regardless.
Check the RDL report, if the dataset query is listing all releases but only one appears per line, it is probably the grouping.
