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.
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:
- Derivative Invoices are no longer provided on separate rows. Instead, a summary of “most recent state” is provided.
- 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.
invoice_date | payment_due_date | invoice_status | actual_paid_amount | invoice_creation_date | invoice_number | invoice_amount | any_deductions |
12/29/2023 | 3/2/2024 | Paid,Price discrepancy dispute closed | 1173.09 | 1/2/2024 | 12345678 | 5642.87 | TRUE |
12/29/2023 | 3/2/2024 | Paid | 193.32 | 2/29/2024 | 12345678SCR | 4469.78 | TRUE |
12/29/2023 | 3/2/2024 | Paid | 492.84 | 3/29/2024 | 12345678SCRSCR | 4276.46 | TRUE |
12/29/2023 | 3/2/2024 | Submitted | 0 | 4/13/2024 | 12345678SCRSCRSCR | 3783.62 | FALSE |
AFTER The new V2 invoice schema shows only one row of data for this invoice:
invoice_date | payment_due_date | invoice_status | actual_paid_amount | invoice_creation_date | invoice_number | invoice_amount |
12/29/2023 | 3/2/2024 | PAID, PRICE_DISCREPANCY | 1822.06 | 1/2/2024 | 12345678 | 5642.87 |
The ‘any_deductions’ column is deprecated, and the following supplemental information is added:
list_of_pos | in_progress | total_matched_to_date | queued_for_payment | quantity_variance | price_variance | quantity_pay_discount | child_invoice_identifiers | invoice_source |
PO654321 | 0 | 0 | 0 | 3783.62 | -37.15 | 37.19 | 12345678SCRSCRSCR, 12345678SCR, 12345678SCRSCR | EDI |
- 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:
- 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.
- Schema changes
- 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.
invoice_number | invoice_date | po_or_order_number | asin | quantity | amount | shortage_quantity | shortage_amount | quantity_recieved | amount_recieved |
12345678 | 12/29/2023 | PO6543 | B000000001 | 12 | 985.68 | 12 | 985.68 | 0 | 0 |
12345678SCR | 12/29/2023 | PO6543 | B000000001 | 12 | 985.68 | 12 | 985.68 | 0 | 0 |
12345678SCRSCR | 12/29/2023 | PO6543 | B000000001 | 12 | 985.68 | 0 | 0 | 0 | 0 |
12345678SCRSCRSCR | 12/29/2023 | PO6543 | B000000001 | 6 | 492.84 | 6 | 492.84 | 0 | 0 |
12345678 | 12/29/2023 | PO6543 | B000000002 | 1 | 35.99 | 0 | 0 | 0 | 0 |
12345678 | 12/29/2023 | PO6543 | B000000003 | 4 | 117.08 | 0 | 0 | 0 | 0 |
12345678 | 12/29/2023 | PO6543 | B000000004 | 2 | 193.74 | 0 | 0 | 0 | 0 |
AFTER
The most recent state for each invoice-ASIN pair is shown.
invoice_number | invoice_date | po_or_order_number | asin | quantity | amount | shortage_quantity | shortage_amount | quantity_received | amount_received |
12345678 | 12/29/2023 | PO6543 | B000000001 | 12 | 492.84 | 6 | 492.84 | 0 | 492.84 |
12345678 | 12/29/2023 | PO6543 | B000000002 | 1 | 35.99 | 0 | 0 | 0 | 35.99 |
12345678 | 12/29/2023 | PO6543 | B000000003 | 4 | 117.08 | 0 | 0 | 0 | 117.08 |
12345678 | 12/29/2023 | PO6543 | B000000004 | 2 | 193.74 | 0 | 0 | 0 | 193.74 |