No cash_receipt_id key in AR_payment_schedules_all to get to AR_cash_receipts_all
I need to get additional receipt information for an existing custom AR Register Report but do not have a cash_receipt_id key in ar_payment_schedules_all rows to link to the AR_cash_receipts_all table for paid invoices. Can anyone shed some light on this?
I have the feeling the existing custom AR Register report perhaps should be reporting off of the AR_receipts_rep_itf table.
The seeded AR Register report doesn't work so we depend on our AR Register custom reports (2).
Let me know if what I see in the AR_payment_schedules_all table is what I am suppose to see or if we need to create an SR.