Importing Card Refunds: General Information

You can import to MYOB Acumatica refunds issued for orders paid with card-based payment methods to customers in your Shopify store.

Learning Objectives

In this chapter, you will learn how to do the following:

  • Configure the import of refunds for card-based payment methods (Authorize.Net) from a Shopify store to MYOB Acumatica
  • Import refunds for card-based payment methods from a Shopify store to MYOB Acumatica

Applicable Scenarios

You import refunds of payments based on a card-based payment method from Shopify to MYOB Acumatica to keep track of refunded payments and restocked items. You may issue refunds in the Shopify store in the following cases:

  • A customer has been overcharged in error and part of the order amount needs to be refunded.
  • A customer has not received the purchased item or has received an excessive quantity of the item.
  • A customer has received the purchased item but is not satisfied with its quality or performance and wants to return it.

Configuration of Refund Import

To configure the import of refunds from a Shopify store to MYOB Acumatica, you perform the following general steps:

  1. Define a return order type.

    On the Order Types (SO201000) form, you define an order type to be used for return orders imported from the Shopify store to MYOB Acumatica. A return order type should be created with the following settings selected on the Template tab:

    • Automation Behavior: RMA Order
    • Default Operation: Receipt
    • AR Document Type: Credit Memo
  2. Define a refund amount item.

    On the Non-Stock Items (IN202000) form, you define a non-stock item that will represent imported refund amounts in sales orders and in return orders. This non-stock item should be defined with the following settings on the General tab:

    • Tax Category: A category corresponding to tax-exempt items
    • Require Receipt: Cleared
    • Require Shipment: Cleared
  3. Define a reason code.

    On the Reason Codes (CS211000) form, you create a define a reason code to be inserted in return orders for refunds imported from the Shopify store. This reason code must be of the Issue usage type.

  4. Activate the Refund entity.

    On the Entities tab of the Shopify Stores (BC201010) form, you activate the Refund entity for the Shopify store.

  5. Specify the refund import settings.

    On the Orders tab, you specify settings in the following boxes:

    • Return Order Type
    • Refund Amount Item
    • Refund Reason Code
  6. Specify payment methods for which you need to import refunds.

    On the Payments tab of the Shopify Stores form, you select the Process Refunds check box for each payment method for which you want to import refunds. For store payment methods that are mapped to card-based payment methods in MYOB Acumatica, this check box is selected by default and cannot be edited.

Import of Refunds for Card-Based Payment Methods

Refunds are imported from the Shopify store to MYOB Acumatica as part of the synchronization of the Refund entity, which can be synchronized only in the Import direction. During the preparation of refund data for synchronization, the system creates one synchronization record for all refunds that have been issued for a single sales order in the Shopify store.

For a refund to be imported successfully, all of the following conditions must be met:

  • The original sales order has been synchronized.
  • The original payment to which the refund pertains has been imported and released.
Important:

If automatic tax recalculation is disabled for orders imported from the Shopify store, the system imports each sales order with the Disable Automatic Tax Calculation check box selected on the Financial tab of the Sales Orders (SO301000) form. If such an order is partially shipped and an invoice has been created for the shipment, the prepayment amount applied to the invoice includes the total tax amount of the order. The prepayment amount is shown in the Applied to Documents box on the Payments and Applications (AR302000) form.

When a refund is created for the remaining items of the order that have not been shipped yet, the refund amount becomes greater than the remaining prepayment amount, which is shown in the Applied to Orders box on the Payments and Applications form. In this case, during the import, the system sets the Payment Amount of the imported refund to be equal to the remaining prepayment amount. Also, in the Available Balance box on the Payments and Applications form, the system records the difference as the available balance of the refund.

For more information about the synchronization process, see Data Synchronization: General Information. For more information about the import of various types of refunds, see Importing Card Refunds: Order-Level Refunds and Importing Card Refunds: Item-Level Refunds.