Order Synchronization: Card Payments

In Acumatica ERP Retail-Commerce Edition, users can import and, if necessary, process debit and credit card payments from external e-commerce systems through integration with payment gateways. The ability to use card-processing features, such as authorization, capture, voiding, and refunding card transactions, is available if the Integrated Card Processing feature is enabled on the Enable/Disable Features (CS100000) form. This topic explains how to configure payment providers for processing of payments made in the Shopify store after they are imported to MYOB Advanced.

Configuration of Shopify Payments for Integrated Card Processing

Shopify Payments is a payment provider available to Shopify customers in certain countries and regions. It supports all major payment methods, does not require additional registration, and can be used as soon as the store is created. For information about availability of Shopify Payments, see the Shopify documentation.

Before payments based on Shopify Payments can be imported from the Shopify store to MYOB Advanced, you need to configure payment processing via Shopify Payments as follows:

  1. Set up Shopify Payments in your Shopify store.

    You activate Shopify Payments on the Payments settings page of your Shopify store. When you set up Shopify Payments, you might be required to provide information about your business and bank account details to receive payouts. For information about setting up Shopify Payments in the Shopify store, see the Shopify documentation.

  2. Activate integrated card processing.

    You activate integrated card processing (that is, the ability to use additional card processing steps for AR payments) by selecting the Enable Integrated CC Processing check box on the Accounts Receivable Preferences (AR101000) form.

  3. Configure a processing center for Shopify Payments in MYOB Advanced. You set up the processing center on the Processing Centers (CA205000) form. During the configuration, you select the Shopify Payments API plug-in as the Payment Plug-In (Type) and on the Plug-In Parameters tab, you specify the STORENAME parameter, which is the name of the Shopify store as it is defined on the Shopify Stores (BC201010) form.
  4. Configure a card-based payment method in MYOB Advanced.

    After you have configured the processing center, on the Payment Methods (CA204000) form, you need to set up a payment method that will be associated with the processing center. For information about setting up payment methods in MYOB Advanced, see Cash Management: Payment Methods.

  5. Map the card-based payment method with the Shopify Payments store payment method.

    You map payment methods between MYOB Advanced and the Shopify store on the Shopify Stores (BC201010) form. When a payment is imported from the Shopify store to MYOB Advanced, a prepayment is created on the Payments and Applications (AR302000) form based on the payment method from MYOB Advanced that was mapped to the payment method used for payment in the Shopify store.

For step-by-step instructions on configuring and importing payments based on the Shopify Payments payment method, see Order Synchronization: To Configure and Import Shopify Payments.

Configuration of Authorize.Net Payment Method for Integrated Card Processing

Authorize.Net is a processing center that accepts transactions through an application programming interface and processes payments online. Before card payments can be imported from a Shopify store, you need to configure payment processing via Authorize.Net as follows:

  1. Sign up for an Authorize.Net account.

    For testing purposes, you can create a sandbox account. You will use the API login, transaction, and optionally signature key generated during the account creation to connect the processing center to the Authorize.Net server.

  2. Activate integrated card processing.

    You activate integrated card processing (that is, the ability to use additional card processing steps for AR payments) by selecting the Enable Integrated CC Processing check box on the Accounts Receivable Preferences (AR101000) form.

  3. Configure the Authorize.Net processing center.

    You set up the processing center on the Processing Centers (CA205000) form. For instructions on setting up a Authorize.Net processing center in MYOB Advanced, see Integration with Authorize.Net Through the API Plug-in and To Configure the Authorize.Net Processing Center with the API Plug-in.

  4. Configure a card-based payment method.

    After you have configured the processing center, on the Payment Methods (CA204000) form, you need to create a payment method that will be associated with the processing center. For information about setting up payment methods in MYOB Advanced, see Cash Management: Payment Methods.

  5. Configure the Authorize.Net payment gateway in the Shopify store.

    You set up the Authorize.Net payment provider in the Shopify store using the same API login and transaction key that you have used to configure the processing center in MYOB Advanced. For information about configuring the Authorize.Net payment provider in the Shopify store, refer to the Shopify documentation.

  6. Map the card-based payment method with the Authorize.Net payment method defined in the Shopify store.

    You map payment methods between MYOB Advanced and the Shopify store on the Shopify Stores (BC201010) form. When a payment is imported from the Shopify store to MYOB Advanced, a prepayment is created on the Payments and Applications (AR302000) form based on the payment method from MYOB Advanced that was mapped to the payment method used for payment in the Shopify store.

For step-by-step instructions on configuring and importing payments based on the Authorize.Net payment method, see Order Synchronization: To Configure and Import Authorize.Net Payments.

Mapping of Card-Based Payment Methods

During the configuration of a connection to the Shopify store, one of the steps you perform is the mapping of payment methods configured in MYOB Advanced with payment methods configured in the Shopify store. You define payment method mapping in the table on the Payment Settings tab of the Shopify Stores (BC201010) form.

You specify the following:

  • Active: A check box that you select for a payment method to indicate that payments made in the e-commerce system that are based on should be imported to MYOB Advanced.
  • ERP Payment Method: The identifier of the payment method in MYOB Advanced that was configured to use the same processing center as was used for setting up the payment provider in the online store.
  • Cash Account: A cash account that was specified for the payment method on the Allowed Cash Accounts tab on the Payment Methods (CA204000) form.
  • Proc. Center ID: The identifier of the processing center configured for the payment method on the Processing Centers tab of the Processing Centers (CA205000) form.
  • Release Payments: A check box that you select to indicate that the payment should be immediately released after it is imported to MYOB Advanced. If this check box is selected for a card-based payment method associated with a credit card processing center in MYOB Advanced (that is, for the payment method for which a processing center is selected in the Proc. Center ID column), only payments that have been captured in the store will be automatically released on import. Payments that have been authorized but not captured in the store need to be processed after import and then released manually or by using the Release AR Documents (AR501000) form.
  • Process Refunds: A check box that indicates (if selected) that refunds made to the payment method should be imported to MYOB Advanced. This check box is selected and unavailable for card payment methods for which a processing center is specified, which indicates that all refunds made to such payment methods must be imported to MYOB Advanced.

Import of Card Payments with Integrated Card Processing

When the pre-authorized payment is imported from Shopify to MYOB Advanced (as part of the synchronization of the Sales Order entity or the Payment entity), on the Payments and Applications (AR302000) form, the system creates a document of the Prepayment type with the Pending Processing status. In the Summary area of the created document, the system inserts the following information:

  • Payment Method: The payment method that has been mapped to the store payment method in the table on the Payment Settings tab of the Shopify Stores (BC201010) form
  • Cash Account: The cash account selected for the mapped payment method
  • Payment Ref.: The number of the related credit card transaction in the processing center
  • Processing Status: The processing status of the credit card transaction. Depending on the last successful operation with the transaction, the processing status can be one of the following:
    • Pre-Authorized: The payment has been authorized but the funds have not been captured. The last successful operation was Authorize Only.
    • Captured: The funds have been captured. The last successful operation with the credit card transaction was either Authorize and Capture or Capture Authorized.
    • Pre-Auth./Capture Pending Validation: The last successful operation with the credit card transaction is unknown. To get the correct processing status of the credit card transaction, you can use the Validate Card Payment action on the Payments and Applications form.

On the Card Processing tab, the system creates a row for the last successful operation with the credit card transaction. In the PC Response Reason box, Imported External Transaction indicates that the information about the credit card transaction operation has been imported from the external e-commerce system. The transaction operation can have one of the following types:

  • Authorize Only: The payment was authorized when the order was placed but has not yet been captured.
  • Authorize and Capture: The payment was captured when the order was placed.
  • Capture Authorized: The payment was authorized when the order was placed, and then the funds were captured in the admin area of the store.
  • Unknown: The status of the operation with the credit card transaction is unknown.

The following diagram illustrates the workflow of importing a sales order to MYOB Advanced from a Shopify store where it was placed and paid by a card based on a payment method for which integrated card processing has been configured in MYOB Advanced.



Deferred Processing of Imported Credit Card Payments

Credit card transactions created in MYOB Advanced during the import of payments based on credit card payment methods require validation if the last operation on the credit card transaction has the Unknown status.

External credit card transactions that meet this condition are displayed on the Deferred Processing Required tab of the Validate Card Payments (AR513000) form.

When you start the validation process, the system requests the status of the credit card transaction, and updates the processing status of the transaction and the status of the prepayment, if necessary. If the updated processing status of the transaction is Captured, the status of the prepayment changes to Balanced. If on the General Settings tab of the Accounts Receivable Preferences (AR101000) form, the Enable Integrated CC Processing check box is selected, the system releases the prepayment.

Customizations may support forced validation of all imported credit card transactions. In this case, all credit card transactions imported from external systems will be displayed on the Deferred Processing Required tab of the Validate Card Payments form and will need to be validated.

Tip: A sales order can be fulfilled only if the credit card payment imported for it from an external e-commerce system has been validated. To streamline shipping of orders, you can set up an automation schedule on the Validate Card Payments form to regularly process imported card transactions that require validation. For information about automation schedules, see Automated Processing: General Information.