How to solve ‘Accounting destination’ error while creating payments in Sage X3

By | June 23, 2021

Payment is the transfer of money or goods and services in exchange for a product or service. A payment can be made in the form of cash, check, credit card and debit card.

Payments can be done against invoices that are generated from Sales/Purchase Invoice and Customer/Supplier BP invoice from the AP-AR accounting module. Payments transactions are created bank-wise as per the selected supplier/vendor. Payments are also done against multiple invoices and users can create the remittance entry against multiple payments. The purpose of Remittance entry is to provide the payment transactions to a particular bank in proper format with cash settlement, bill exchange issues, collections, check payments, discounts, etc.

Purchase Invoice:  A Purchase Invoice is a bill which we receive from Suppliers against which we need to make the payment.

Sales Invoice: A sales invoice is a document sent by a provider of a product or service to the purchaser that shows the items or services provided and the amount owed. The invoice establishes an obligation on the part of the purchaser to pay.

The posting of the payment of invoices coming from the Purchase, Sales or AP-AR Accounting modules is the payments generation.

In Sage X3, we may face difficulty while creating the payment of the Sales / Purchase and Customer/ Supplier BP invoices. So for resolving such errors. There is an inbuild functionality for solving the same. Kindly follow below steps:

Step1: Replicate the error in sage X3. Let us take an example.

  1. Create Sales/Purchase Invoice or Customer/Supplier BP Invoices.
  2. Now posted it.
  3. Check the journals are created of this invoices.
  4. Check the accounting task is in the running mode.
  5. Now open the Payment screen.

Navigate to : AP/AR Accounting -> Payments -> Payment/Receipt entry

  • Now select and open the payment entry type which is defined in the invoices.
  • Enter all the mandatory data in the screen.
  • Now select the invoice from the left list panel which you have created above.
  • As you can see in the below screen shot user is not able to select the invoice, as system is giving below error message.
Fig : Payment screen

Now for solving this error , follow below Step 2:

Step2:

Navigate to: Setup -> A/P-A/R Accounting -> Payment Entry Types

  1. Select respective payment type .
  2. Under this ,check is any payment attribute is define.
  3. As in the above screen shot you can see system is showing PAYIS which is a payment attribute.
  4. First check PAYIS  is defined in the payment attribute screen in Sage x3 .
  5. If not , then remove this payment attribute (PAYIS) from the respective payment entry type and select the new one which is already present or defined.

Refer below screen shot:

Fig : Payment Entry Type

Now check in the payment screen user is able to select the invoice or not. Refer below screen shot:

Fig : Payment Screen

Note: The payment attributes must be set up. They define the account structures to be used, for example, as a payment attribute of type Cash receipt that acts on a bank account and a BP account.

In this way, we can solve the accounting destination issue while making the payment of an invoices in Sage X3.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation competence. 

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We would like to hear from you.