Amazon Returns
This page shows the returns that Amazon reports and the documents created from them in Business Central: a sales return order for orders you ship yourself (MFN), a sales credit memo for orders Amazon ships (FBA). The returns import creates the documents; Create Return Orders does it right away.
Opening the Page
- Via search: Amazon Returns
- Via the Amazon Dashboard → Related → Returns; the Returns with errors line under Waiting for you opens the returns with status Error.
- The message of Import Returns on the Amazon Dashboard and of Return Order for an Order on this page points here when something could not be created.
How returns come in
The REFUNDS job (every 60 minutes, 06:00–22:00) or Import Returns on the Amazon Dashboard reads Amazon's returns report (GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE) for each marketplace with Use for Orders – starting from the last report read successfully, at most 59 days back; the first run starts 30 days back. If FBA is enabled, it also reads Amazon's FBA customer returns and the FBA reimbursements.
Each return is imported only once: returns of orders you ship yourself per order, RMA and SKU; FBA returns per order, returned unit (License Plate) and SKU. If a later run reads a known return of an order you ship yourself again, it only takes over the request status, tracking number, resolution and delivery date; a request that has since been rejected or cancelled becomes Skipped as long as no document has been created yet.
| Return | Document | What happens on posting |
|---|---|---|
| Shipped by you (MFN) | Sales return order per RMA, the RMA is in Your Reference | Receiving posts the goods back into inventory, invoicing creates the credit memo. |
| Shipped by Amazon (FBA) | Sales credit memo per order, on the location of the invoice line (= FBA location) | The goods are already back in Amazon's fulfillment center; posting puts them back on the FBA location. |
Each document line takes item, variant and unit of measure from the SKU – the SKU of a pack returns packs – and price, discount and location from the invoice line it reverses. It is applied to the item ledger entry of the sale, so the goods come back at the cost at which they left. The amount Amazon actually refunded is reconciled by the settlement (add-on module, see Settlements).
Fields
| Field | Description |
|---|---|
| Amazon Order ID | Amazon order the goods are returned from. |
| Amazon RMA ID | Return authorization that Amazon granted the buyer; the sales return order carries it in Your Reference. MANUAL for lines from Return Order for an Order. |
| Marketplace | Amazon marketplace on which the order was placed. |
| Fulfillment Channel | Who shipped the order: you (MFN) – the return becomes a sales return order – or Amazon (FBA) – it becomes a credit memo. |
| SKU | Returned SKU. |
| Quantity | Returned quantity – for the SKU of a pack, the number of packs. |
| Return Reason | The buyer's reason for the return. |
| Request Status | Status of the return request at Amazon, e.g. Approved or Closed. Rejected or cancelled requests get no document. |
| Request Date | Date of the return request. |
| Return Delivery Date | When the return arrived at your place, as far as Amazon knows it from the tracking of the return label. |
| Tracking No. | Tracking number of the return package (hidden by default). |
| Resolution | How Amazon closed the return, e.g. refund or replacement (hidden by default). |
| Disposition | Condition in which Amazon found the returned unit, e.g. SELLABLE or CUSTOMER_DAMAGED – FBA only (hidden by default). Amazon keeps a unit that cannot be sold as unfulfillable inventory. |
| License Plate No. | Number that Amazon's fulfillment center gave the returned unit; without such a number, the time of the return and the fulfillment center – FBA only (hidden by default). |
| Status | State in Business Central, color-coded (see below). |
| Return Order No. | Sales return order the return became. |
| Credit Memo No. | Sales credit memo the return of an FBA order became. |
| Error Message | Why no document could be created (highlighted in red). |
Status
| Status | Meaning |
|---|---|
| New | Imported, no document created yet. |
| Return Order Created (green) | Created as a line of a sales return order. |
| Credit Memo Created (green) | Created as a line of a sales credit memo (FBA). |
| Skipped (gray) | Amazon rejected or cancelled the return request; no document is created. |
| Error (red) | No document possible; the reason is in Error Message. The returns import does not try again on its own: fix the cause and choose Create Return Orders. |
Actions
All three actions are in the action bar under Process.
| Action | Description |
|---|---|
| Create Return Orders | Creates the sales return orders or credit memos for the selected returns with status New or Error right away, instead of waiting for the returns import. Each return runs in a transaction of its own; one that fails does not hold up the others. |
| Return Order | Opens the sales credit memo or sales return order of the line. |
| Return Order for an Order | Creates a sales return order for an Amazon order covering all invoiced items – for a return that Amazon did not report. You enter the Amazon Order ID in the Amazon Order Import dialog. On this page, this creates lines with the Amazon RMA ID MANUAL and the marketplace on which the order was placed (if merchantCENTRAL does not know the order, the home marketplace). Once per order: if the sales return order already exists, the action stops – change its quantities instead. It also stops if the order has no posted invoice in Business Central. The message tells you whether the sales return order was created; otherwise this page shows the reason. Adjust the quantities before you receive the goods. |
Tips
When a return fails
- The SKU is not mapped to an item – map it on the marketplace item or as a pack offer.
- The order is not in Business Central, e.g. because it was sold before the connector was in use: the document is created for the Customer for Unknown Returns from the Amazon Settings, at the item's sales price and, for FBA, on the FBA location. Without this customer, the return stays at Error.
- More returned than sold: The quantity is checked against all invoices of the order, less open and posted returns.
New lines, existing documents
Further return lines of the same RMA (for FBA, of the same order) only go into a document that the connector created itself and that is still open, i.e. not released. Otherwise the connector creates a new document; released, posted or manually created documents stay unchanged.
Return not reported by Amazon
If a buyer sends goods back without a return request, Return Order for an Order on this page creates a sales return order for all invoiced items of the order (lines with Amazon RMA ID MANUAL) – once per order. Adjust the quantities before you receive the goods.