How to update the pay approval on a posted purchase invoice in Sage X3

By | September 22, 2021

There may be situation that a user needs to change the due date or pay approval on a posted sales invoice or purchase invoices . Sage x3 provides a functionality called the Open item edit function to make the changes to the due date , pay approval as well as other characteristics for open items.

An open item is an entry characterized by a group of data related to the operation that it represents: the original document number, the document due date, it’s payment method, the currency, the amount etc.

The management of open items makes it possible to facilitate the tracking of operations recorded for a BP (via the Purchasing, Sales, Sales/Purchase ledger or Accounting modules) under a document type parameterised according to this function:

By clicking on an item header, it is possible to modify:

the due date

the Payment Approval value

the dispute code

the payment method

the reminder management

the pay-by/pay-to BP

the early discount/late charge code

the pay-by/pay-to address code

Pay approval field can have the following values:

  1. Authorized to Pay: This option allows payments to be made for that invoice.
  2. Not Approved: This option only allows payments on or beyond the due date. When running a payment proposal, if in the invoices the pay approval value is selected as not approved, you will not see those invoices – they do not display in the left lists.
  3. Conflict: This option allows you to hold payment of this invoice. A dispute code can also be entered.
  4. Delayed: This option is used when you do not want to make a payment.

Here we can see the purchase invoice ‘PIN2109AU01100040’ has been created and posted with the pay approval status as ‘Pending’. We have to change the value of this field to ‘Approved to pay’. Refer the below screenshot.

fig01: Purchase invoice screen

Once an invoice is posted, you can use the Open Items task to edit, view, and manage the open items and their payment stages. Some of the changes that can be made are:

Pay-by/Pay-to by

Due Date

Payment method

The  steps below will allow you to modify the pay approval as well as some other characteristics of a posted purchase invoice:

Navigate to > A/P A/R Accounting > Open Items > open item edit

1)  Select the type. Here we will select ‘AUPIV’ for purchase invoice.

2) Select the open item’s document number i.e. purchase invoice number

3) Edit the pay approval field as needed. Here we will change it to “Authorized to pay” status.

4) Click on save.

Fig02: Open item

Now navigate to purchase invoice to check the reflected changes.

Select the invoice for which you have updated the pay approval status.

Here we can see the value of approval status is changed to Authorized to pay.

Fig03: Pay approval

In this way we can update the value of pay approval field for posted purchase invoice.

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.