Vendor Invoice Tables - 2024 Updates

Amazon made significant updates to the invoice reporting user experience (UX) in Vendor Central in Q2 2024. This update affects invoice data provided by Reason Automation. The impact of this new UX on invoice data is explored in detail below. Currently, the new UX has been deployed for US- and EU- based vendors, and to select other countries (please contact us for the latest on spoecific marketplaces).

UX In Vendor Central

We refer to the old and new experiences as V1 and V2 respectively. The V2 experience is now shown by default in Vendor Central for US vendors, although a link is offered to “return to the previous experience”.

For as long as both experiences are available, Reason Automation can continue to provide data in both the V1 and V2 formats. These are named as follows in RA schema: V1 - invoices_summary, invoices_details

V2 - invoices_summaryv2, invoices_detailsv2

Invoices Summary V2

Key Differences:

1. Derivative Invoices are no longer provided on separate rows. Instead, a summary of “most recent state” is provided.
2. Schema changes - new columns added, one column removed

BEFORE Original invoice shown along with additional child invoices generated by shortage claims, pricing claims and other deduction activities.

AFTER The new V2 invoice schema shows only one row of data for this invoice:

The ‘any_deductions’ column is deprecated, and the following supplemental information is added:

• list_of_pos - the order numbers for POs that are related to this invoice
• in_progress - present in the downloaded invoice report, although does not seem to be populated for for vendors we have checked so far
• total_matched_to_date - reflects the amount shown as ‘Queued for payment’ under ‘Paid’ in the Status/Next Steps column in the invoices V2 UI
• queued_for_payment - same as total_matched_to_date for vendors we have checked so far. Reflects the amount shown as ‘Queued for payment’ under ‘Paid’ in the Status/Next Steps column in the invoices V2 UI
• quantity_variance - the currency amount of any quantity variance/shortage
• price_variance - the currency amount of any measured price variance (total variance, not per unit)
• quick_pay_discount - discount taken for quick-pay, if part of payment terms agreement
• child invoice identifiers - shows the child invoices related to the main invoice, issued as a result of shortage, price claim or other deductions (tip - search for these invoices in the payments_invoices table to determine status)
• invoice_source - means by which invoice was sent to Amazon

Invoices Details V2

Key Differences:

1. Derivative Invoices by ASIN are no longer provided on separate rows. Instead, a summary of “most recent state” of an ASIN-invoice pair is provided.
2. Schema changes
1. Columns removed: terms (payment), freight_terms, external_id, asin_received (was used to indicate receipt of a different ASIN than expected)

BEFORE

The original invoice is shown along with additional child invoices generated by shortage claims, pricing claims and other deduction activities, all at the ASIN grain.

AFTER

The most recent state for each invoice-ASIN pair is shown.