Supplier situation inquiry (CONSBAGF) takes significantly longer in V12 than V11

After upgrading from V11 to V12 find that the "Supplier situation inquiry" (CONSBAGF) takes significantly longer in V12 than V11 where there is a reasonable number of BP Invoices to be listed. For example, in V11 a supplier inquiry where there are 1100 invoices to list comes back in 2 seconds, but in V12 it takes 16 seconds. This time is not only for the initial inquiry, but also when they click "Next" page, so is very inconvenient for the user who needs to navigate through the invoices. For suppliers with few invoices, V12 performs as expected.

In V12 there is a new field RECALC added to the screen CONSBAG1.
This allows the user to decide if they want to recalculate the risk and totals or not when clicking the "Search" or navigation buttons (Next, Back, last).
By default, the RECALC field is set as "Hidden" with the default value "Yes", so the calculation is always executed.

CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

This issue is being addressed in a future patch release.

Meanwhile, as a temporary workaround you can manually edit the CONSBAG1 screen by navigating to Development, Script dictionary, Screens, Screens. You can then set the RECALC field default value to "1" ("No") and/or set to "Enter" rather than "Hidden" depending on your customer requirements.

NOTE: this workaround is not best practise, as will be overwritten by patching or validations

Also note,

• With Recalculation=No the initial search is the same time as having Recalculation=Yes (around 16 seconds for my account with 1100 invoices)
• With Recalculation=No then an additional "Search" or the Next/Last buttons are instant response (<2 seconds) whereas with Recalculation=Yes an additional "Search" or the Next/Last buttons take another 16 seconds each time the button is clicked