Importing Non-Card Refunds: Implementation Activity
The following activity will walk you through the configuration of refund import so that you can import to MYOB Acumatica refunds and returns issued to a customer in the Shopify store for orders paid with non-card payment methods.
Story
Suppose that the SweetLife Fruits & Jams company sells several kinds of jams in its Shopify store and wants MYOB Acumatica to keep information about the returns and refunds issued in the Shopify store. Acting as an implementation consultant, you need to set up the import of refunds from the Shopify store to MYOB Acumatica.
Configuration Overview
In the U100 dataset, for the purposes of this activity, the following features have been enabled on the Enable/Disable Features (CS100000) form:
- Retail Commerce
- Shopify Connector
- Custom Order Types
The following entities, which you will use in this activity, have been predefined in the U100 dataset:
- The ER order type on the Order Types (SO201000) form
- The REFUNDAMT non-stock item on the Non-Stock Items (IN202000) form
- The EREFUND reason code on the Reason Codes (CS211000) form
Process Overview
In this activity, you will do the following:
- On the Entity Settings tab of the Shopify Stores (BC201010) form, activate the Refund entity.
- On the Order Settings tab, review the settings related to refund import.
- On the Payment Settings tab, activate the import of refunds for a non-card payment method (Manual).
System Preparation
To prepare the system for the steps of this activity, do the following:
- Make sure the connection to the Shopify store has been established and the minimum configuration has been performed, as described in Initial Configuration: To Configure the Store Connection.
- Sign in to the MYOB Acumatica instance with the U100 dataset preloaded. You should sign in as an
administrator an administrator by using the following credentials:
- Username: gibbs
- Password: 123
Step 1: Activating the Refund Entity
Before you start importing refunds from the Shopify store to MYOB Acumatica, you need to activate the Refund entity as follows:
- Open the (BC201000) form.
- In the Store Name box of the Summary area, select SweetStore - SP, which is the store that you created in Initial Configuration: To Configure the Store Connection.
- On the Entity Settings tab, make sure that the
Active check box has been selected for the
Refund entity.
You select the Active check box for an entity to indicate that the entity's data needs to be synchronized between MYOB Acumatica and the Shopify store.
- On the form toolbar, click Save to save your changes.
Step 2: Reviewing the Refund Import Settings
To review the settings that will be applied to refunds imported from the Shopify store, do the following:
- While you are still viewing the Shopify Stores (BC201010) form, go to the Order Settings tab.
- In the Order section of the Order
Settings tab, make sure that the following settings have been
specified:
- Return Order Type: ER - eCommerce Return
Order
This order type is based on the RC order template.
- Refund Amount Item: REFUNDAMT
This tax-exempt non-stock item is used to represent the refunded amounts in documents.
- Refund Reason Code: EREFUND
This reason code of the Issue usage type is inserted in documents to indicate that the line represents a refund issued.
- Return Order Type: ER - eCommerce Return
Order
- On the form toolbar, click Save to save your changes.
Step 3: Activating the Import of Refunds for a Non-Card Payment Method
To turn on the import of refunds for the Manual payment method, which you have configured in Initial Configuration: To Configure the Store Connection, do the following:
- While you are still viewing the Shopify Stores (BC201010) form, go to the Payment Settings tab.
- In the table of this tab, select the Process Refunds
check box in the row of the MANUAL store payment method.
The resulting payment method mapping is shown in the following table.
Active Store Payment Method Store Currency ERP Payment Method Cash Account Release Payments and Refunds Process Refunds Selected MANUAL USD ONLINE 10250ST Cleared Selected - On the form toolbar, click Save to save your changes.
You have now configured the import of refunds from the Shopify store to MYOB Acumatica for payments made by using a non-card payment method (Manual).