Line ID for Cash Application
Trying to build a query that shows cash application by revenue account. I need the line ID or dist line ID since we have more than one line on an invoice. I see an APPLIED_CUSTOMER_TRX_LINE_ID field in the ar_receivable_applications_all table, which would be PERFECT, but it's not populated.
Anyone know why that field isn't populated? Has anyone found a method to link the transaction lines to the application lines (other than by dollar amount)?