Integrations & ERP Custom Fields / Sage X3

Payment Integration to Sage X3

TThe following procedure outlines the setup of YayPay and your Sage X3® system to support pushing payments from YayPay to Sage X3®. This happens soon after a payment attempt has been made in YayPay and validated by the payment processor to be successful.

Supported Payment Allocations

The Sage X3 connector supports pushing the following types of payment allocations:

  • An invoice settled partially or completely using a newly created payment and credit memo.
  • An invoice settled partially or completely using a newly created payment and another payment acting as credit.
  • An invoice settled partially or completely using only a credit memo.
  • An invoice settled partially or completely using only a payment acting as credit.

Setup Prerequisites

The prerequisite for this setup outlined is that your Payment Processor Gateway / Merchant credentials have been approved and issued to you (as well as configured in YayPay under the Settings > Integrations page).

1. Customize Payment Methods in Sage X3


Before creating a payment in YayPay, you should make sure that your account in Sage X3 has customized payment methods.





Each payment method should correspond to the payment method in YayPay.


For example, if you create a payment and select the payment card method in YayPay, it means that Sage X3 should have the same payment method.

2. Select Sage X3 Checking Account in YayPay


You can also configure YayPay to send the Card or ACH payment to a specific Checking Account. This list of drop-down values is sourced from your Sage X3 system.

Go to your Business Settings page in YayPay (Settings -> Business) to select the appropriate Bank Account for both ACH and Card Payments from the 2 drop-down lists. These Checking Accounts should also be linked to a Bank Account in Sage X3.


To see Bank Accounts in Sage X3, you should open the Navigation Menu, select Common Data > BP accounting table > Bank accounts.

After the sync process, YayPay updates Bank Accounts in the Default bank account for ACH and Default bank account for CC lists.

3. Configure YayPay to create and send the payment information to Sage X3

Log into YayPay and go to the Settings > Integrations page. Select the Sage X3 Connector Settings.



  • Fill in the Default Sage Site for Payment field.
  • Enable the Create payments setting.
  • Click SAVE CHANGES to save your updates.

NOTE: When you create a payment in YayPay and push it to Sage X3, the payment in Sage X3 will bear the Bank field, indicating the bank code from the selected account in YayPay:


4. Create a payment item manually (or review the payment attempt through YayPay’s Cash App page)

1. Go to Cash App and click on ADD PAYMENT

2. In a new popup window enter the necessary payment info and click Save Payment

Figure 1. Creating a payment in YayPay

3. The created payment appears to be on the list 

Figure 2. Displaying a payment in Cash APP in YayPay


4. In order to pull payment info correctly the Site value from the Sage field should be indicated in YayPay Settings >Integrations> Sage X3

Warning

The Site field might be different for each payment, make sure you change the setting for each type of payment

5. Currency of the created payment should coincide with the currency in the record created in Sage 

6. Displaying pushed payments from YayPay to Sage X3:

Figure 3. Selecting Payments in YayPay

To open pushed payments, click A/P-A/R Accounting > Payments > Payment/Receipt Entry > YYPGP YayPay Generic Payment

Figure 4. Displaying payment types

According to the payment request presented above, the created payment in Sage X3 has the following view:

Figure 5. Displaying the pushed payment from YayPay

5. Post Payment

Once you push payment from YayPay to Sage X3, you should take the following steps:


1. Open a created payment


2. Click Milestone 

to see the steps that you should perform in Sage X3 to finish the payment. Once you click Milestone, Sage X3 opens the following window:



Until you perform the steps that Sage X3 recommends, the payment status is Entered.



Info

When you fill in the Default Sage site for payment field in the Sage X3 connector in YayPay, make sure that the financial year for the specified site is opened in Sage X3.



3. Bank deposits

If the bank wasn’t sent on the payment from your system, you’ll have to update each payment with the proper bank code.

Generate the remittance slip – A/P-AR accounting\Remittances\Automatic Remittance creation:

Pay attention that you should fill in data that corresponds to your payment.

  • Uncheck All companies and enter the company you are working with.
  • Uncheck All sites and enter the site name you are working with.
  • Uncheck All transactions and enter one of the transaction codes for YAYPAY you are working with.

For example, YayPay Credit Card Payment (because a payment was created with this payment method).

  • Uncheck All Banks (unless you only have 1 bank in your system, then it's fine to select ALL) and enter your specified Bank code.
  • Uncheck All users or check All users, just in case the integration uses a different user code than your login.
  • Click OK

The resulting log file will look something like this.  Line 1 is the Deposit Slip, the rest are all the payments on the Slip.


Also, the payment has the status Slip entered.




4. Bank posting

Once you finish the Bank deposits operation, you should start the Bank posting operation

Post the Remittance in the Bank Posting function – A/P-A/R Accounting\Payments\Bank Posting:

Pay attention that you should fill in data that corresponds to your payment.

  • Uncheck All companies and enter the company you are working with.
  • Uncheck All sites and enter the site name you are working with.
  • Uncheck All transactions and enter one of the transaction codes for YAYPAY you are working with.

For example, YayPay Credit Card Payment (because a payment was created with this payment method).

  • Uncheck All Banks (unless you only have 1 bank in your system, then it's fine to select ALL) and enter your specified Bank code.
  • Uncheck All users or check All users, just in case the integration uses a different user code than your login.
  • Click OK

The logfile will report completion or show you any errors.


Also, the payment has the status In the bank.


Warning

In the instruction, the “BE021” site is only an illustration. Customers should have their own specific site within the Company (for example, the Company code is PL10, the site code is PL011).
Thus, a site is configured for each Customer under which payments should be created


6. Frequently Asked Questions

Is the Payment Integration to Sage X3 affected if the "PAUSE ALL" button is pressed (the button is found in the Settings > Integrations page of YayPay)


Yes, the Pause All operation pauses both the AR Sync from Sage X3 to YayPay and the Payment creation from YayPay to Sage X3



Can't find what you need?

Contact our support team support@yaypay.com for help.