The Finance Round-Up #7

4 minute read time.

Welcome back!

With the release of 2021R3 (V12P27) last month, we are going to be using this edition to take a look at what’s new and the latest changes to the existing functionality for finance.

Back in 2021R2 (V12P26), the prepayment invoice management function (GESPREPI) was added under the A/P-A/R accounting module, on the Invoicing sub-menu. This allowed users to create, post and pay prepayment invoices by setting up customer contract data, with relative amounts and specific invoice types for prepayments and final invoices. The invoices were created in the Customer BP invoice function (GESBIC). Dedicated automatic journals are used when posting the prepayment invoices, linked to a contract, as well as transferring amounts from prepayments to the final invoice.

Fast forward 3 months to 2021R3, where there have been further developments to this function; you can now create, manage, and post prepayments invoices linked to a sales order using GESPREPI. Using a standard sales invoice, you can link the invoice to the prepayment management function by setting the PREFUN parameter (TC chapter > INV group) to prepayment invoices for the site. Note, there can only be one contract for each sales order line. Payments are posted to an automatic journal until the contract is settled. The final invoice is a standard sales invoice and when it is posted, the prepayment amounts are reversed so that the open items are settled. This closes the prepayment contract.

Other new features include the new parameter CTLCLOPER located in the CPT chapter, under the CLO group. This is the period closing balance control parameter which will be set to No by default. However if set to Yes, balance controls are performed when closing one or a group of periods.

There have also been improvements made to the VAT framework. As per the image below, there are new pre-settings included on the accounting code for company on lines 10 and 11, this will determine the account to be used at the company level.

Similarly, lines 18 and 19 in the accounting code for site have been added to determine the account to be used at the site level.

Another new feature for to the VAT framework is the addition of the VAT box code, in the summary section of the VAT report, when printing the following reports from the VAT return function; DCLVATBOXDEB1, DCLVATBOXDEB2, DCLVATBOXPAY1 and DCLVATBOXPAY2.

There has also been a development to the bank reconciliation report, whereby a new parameter for reconciliation date has been added to allow users to search for entry lines that have or have not been reconciled as of the reconciliation date.

If the parameter is left blank, the report will only include non-reconciled bank/accounting entry lines within the date range. However when a reconciliation date is entered, the report prints every entry line within the date range that is not reconciled as of the reconciliation date.

For more information on these new features and others, please review the release notes or further training on how to use the features, check out our What’s New in Patch 27 training material on Sage University.


Latest Finance KBs


Handy Links

HMRC Header Change


Sage X3 product life cycle policy

Sage X3 Support: Where can I go to find out stuff? - If you are new to the X3 world or just need a handy reminder of all the support avenues available, then this blog post is for you!

Sage X3 Latest Patches - Visit this forum discussion to ensure you're on the latest patch level, with the correct technology component version.

Sage X3 (U.K. & Ireland) - Support and Training video playlist on YouTube.

Sage U – Sage training courses that range from 1 hour ‘Lunch and Learn’ sessions, role-based training for users and Expert level courses.

UKI X3 Support Handbooks - download the Customer/Partner Support handbook.


Please leave a comment below to let us know if there are any specific topics you would like to see covered – we will do our best to accommodate requests!

For the latest updates, from the Sage X3 Finance Support in UKI, keep an eye out for the next edition of the Finance Round-Up.