By using this website, you agree to our Terms of Use (click here)
We currently have a couple of GIs that I wrote which used UnbilledQty and UnbilledAmount of POReceiptLine to easily identify PO Receipts which hadn't been billed.
With the (stupid) 2019.1 upgrade, UnbilledAmount is no longer available. I had a quick attempt to resolve this but wasn't able to. My current plan is to decommission my queries. The closest I've found is the Purchase Receipt Billing Details report, basically scanning the output and looking for rows where Billed Qty <> Receipt Qty.
This is far from ideal.
Does anyone else have a better way to do this under 2019.1?
Have you considered using UnbilledQty/BilledQty and UnbilledAmt/BilledAmt on the POLine and comparing to OpenQty and UnitCost? If you have receipts that do not start as a POLine, you are probably better off doing a join between APTran and POReceiptLine and comparing that way. We bumped into some mess when we upgraded to 2019.R1 because of them removing these field too. 🙁
We have a mix of PO receipts and non-PO receipts. We basically need to recreate the old unbilled amount field from PO Receipts.