Index match formula from sales data worksheet to receivable worksheet

Hi

I am trying to automatically produce Receivables Ledger Account. I am kindly asking for a formula which can automatically match date, invoice number, payment terms and Amount incl VAT from SALES DATA. Please note that invoice 6008 has two transactions. All the figures should be linked to customer code number.

The attached excel sheet explains much better.

Thank you.

Regards,

Sunboy