Need to Merge the Corporate Card AP invoice Lines

Summary:

Dear Team,

System Generated AP invoice (Invoice Number: 1-2024-10-09 ) which is related to Corporate Card. This invoice having Many lines.

But my client requirement is that system need to generate Corporate Card AP invoice with only 1 line if the distribution code is same. That means system need to merge the Invoice lines based on the distribution code combination.

For this AP invoice we have a unique Supplier(Vendor)name: FAB Master Card

This requirement we need only for the Corporate card related AP invoices, where the supplier (Vendor) name as: FAB Master Card.

Please check attached files and let me know how to achieve this requirement.