Hi - one of the departments here wants an invoice built that only shows pending payments due. However, I'm having trouble finding a link between T_ORDER_SCHEDULE where payment plans are scheduled and T_PAYMENT. I don't see a column in T_ORDER_SCHEDULE that indicates if that particular scheduled payment is paid (like the amt_recd column in T_SCHEDULE) so I can't isolate which scheduled payments have been received. Am i missing another table?
Any guidance is appreciated! Thanks!
Off the top of my head I think you'll need to go to T_TRANSACTION.
Thanks - that was my fear. I'll have to internally (in the stored proc itself) built a temp payment schedule table and populate with data from t_payment myself. I was hoping to avoid that, but if there's no link, there's no link. Thanks!