How to apply payments to Supplier BP invoices

By | September 21, 2021

In Sage X3, outgoing payments need to be applied against the relevant invoices to properly reflect the amounts payable to vendors or suppliers in general and on specific invoices.

With the application of payments to supplier BP invoices it is important to note the three main areas of the process below:

  • Enter payments – original entry screen after definition of entry
  • Generate journals by payment – posting payments to the GL and viewing journals
  • View posting stages – understand next steps in the process

To begin, the user must locate or enter the payment that is desired for application against the supplier BP invoice. In this case the payment will be entered and will be a manual check. Following the path:

Steps:

All > AP – AR accounting > Payments > Payment/receipt entry

The user must select from the array of payment options that denote the method of choice with respect to the outgoing payment.

Fig 1 : Transaction selection

Fields with denoted with the red asterisk (*) must have values to satisfy the creation of manual payment entries.

Fig 2: Manual payment screen

The user must click the plus (+) symbol to denote a new manual cheque. The site and business partner are entered. The control account defaults based on the accounting codes in the set up of the business partner. The address code notes the address of the business partner whether it is a corporate address or another address.

Important to note that the payment number is grey and is only generated on creation of the cheque.

The accounting date is a key field that states when the payment will be posted to the general ledger.

The entry reference and description are free-form fields for details and descriptions that state the purpose of the payment.

The bank field denotes the bank account the funds were drawn from.

The currency will default but can be modified.

The amount of the payment is then entered along with the cheque number.

Fig 3 : Payment entry with cheque no.

Open items is selected from the left-hand side of the active screen and the payment is then linked to the invoice that receives the payment based on the BP as entered.

Fig 4 : Payment selection

The user will then select create and the payment is in the system.

To discover the next steps in the process the menu button marked milestone may be selected for more information and to progress with the application of payments.

The next step in the process of manual payments is to post to the bank. The screen below shows the display of the milestone function.

Fig 5 : Payment posting milestone log

The user may then post the transaction directly from the manual cheque screen and complete the transaction with the posting to the bank. The accounting date may be chosen as the default or the value date (external bank posting date) may be entered. If nothing is chosen in the date field, the date will default to the accounting date.

Fig 6 : Payment posting

Once posted the accounting transaction may be reviewed by selecting the menu button on the top right-hand side of the active screen denoted by the three vertical dots and choosing the zoom function and the accounting document to view the journal.

The status can then be viewed as seen below showing that the payment is in the bank.

Fig 7 : Payment creation and posting

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners 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 the 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.