Relation or link between Credit card invoice and Expense report invoice for credit card program that
We are building a report that shows the payment information of an credit invoice along with the expense report and other details. The Card program uses "Company" as the payment option. In this case, we'll have two separate invoices, one to pay the bank for all the credit card charges and the other expense report invoice (zero dollar) just to offset the invoice 1.
The question is how do we see a link between two invoices in the system? Since we are developing a report that shows the credit card payment along with the corresponding expense report information, we need to see a link in UI or tables to build the report. Please advise how this is possible?