Note: The name “SmartConnector” has changed to the “Integration App” as they are built on our Integration Platform as a Service (iPaaS), integrator.io.
When the NetSuite Settlement Transaction to NetSuite Refund Add flow runs, the Integration App accesses the open invoice in NetSuite for every individual settlement transaction records associated with TRANSACTION TYPE > Refund and attempts to create a Credit Memo and Customer Refund for these transactions.
If you have to refund just the tax amount to your buyer on Amazon Seller Central, this article is for you. In such a scenario, the Amazon settlement report contains a refund for the tax amount with no principal amount details associated with it. In this case, when the Integration App tries to create a refund in NetSuite, an error is generated as NetSuite always requires a line item against an order for which refund is being created.
To workaround this use case within NetSuite, the Advanced Settings > NetSuite item to track tax only refunds from Amazon field in the Settlement section allows you to import tax only refunds from Amazon into NetSuite. Once you select a default item of your choice in this field, the Integration App identifies the item within NetSuite and creates a credit memo against this item as a line item. It’s recommended you create a Non-Inventory item (Sale/Resale) for this purpose. The tax amount is reflected in the Amount field against the line item on the credit memo record and the tax amount is set to zero. This is done as NetSuite requires a positive subtotal for all the line items on the transaction record
Note: The internal id of a Non-Inventory item provided by you is used for all tax only refunds in the settlement report from Amazon.
Screens depicting the impact of this setting in NetSuite
Once you select the internal id of an item in the NetSuite item to track tax only refunds from Amazon field and run the Amazon Settlement Report to NetSuite Add integration flow, the Integration App process all the TRANSACTION TYPE > Refund records within settlement report using the NetSuite Settlement Transaction to NetSuite Refund Add flow.
This entire process creates a Celigo Amazon Settlement Transaction record of type refund in NetSuite and applies customer refund against this record. Without this field, an error will be generated when you try to process a tax only refund record from Amazon settlement report.
If you open the invoice associated with this refund, you will see that item associated the order is different from the one listed on credit memo.
Inside the Invoice record, you can find the actual item for which order has been placed.
Within the Credit Memo record you can find the following changes from the standard process:
- Line Item records get created for the item you had selected in the NetSuite item to track tax only refunds from Amazon field. The original item for which order was placed is removed from the credit memo.
- Quantity associated with the item is always listed as Zero because Amazon Settlement Reports doesn’t contain the quantity of the item.
- Tax only refund amount from the settlement report is credited in Amount field of the line item record within the credit memo.