Reconciling AP to IN after 2019.1 upgrade
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.
I haven't worked with this yet, but I just noticed the Purchase Accrual Details (PO631000) report which uses a DAC called POAccrualStatus which looks interesting, especially the POAccrualStatus.ReceivedCost and POAccrualStatus.BilledCost fields.