Goal: When retrieving AWS costs, also retrieve the Seller ID (e.g., AWS, AWS Marketplace) for each product. This will enable us to differentiate cost items by seller.
The Problem: AWS issues two types of invoices:
An invoice per seller (used by our ERP for accounts payable), which lacks detailed billing data.
An invoice per account, which provides detailed product-level data but does not contain the Seller ID.
The Challenge: Our ERP needs the detailed billing data from the per-account invoice but also requires the Seller ID from the per-seller invoice.