As you know, Batch Versions can have the Print Queue Name overwritten at the Version level. This override is stored in a database BLOB and is not accessible through SQL. On the other hand, there may be many reasons why it needs to be overwritten, as well as why it may need to be changed:

• What if the Queue name was release-specific, like QB7333 and you are Upgrading to B7334?
• What if you decided to create a new Queue and move some Versions from the old Queue to the new one or, for example, assign all "R09*" reports to this new Queue?
• What if you have removed a Queue which was referenced in some Versions and now need to clear or update the overwritten Queue name in all affected Versions?
• What if you have Upgraded the Server and would like to change your Default Queue to be multi-threaded, but need to make sure that your Post programs and such are run in a different, single-threaded queue? - There is a list of Programs that must be executed in single-threaded queues in the Solution ID#200783067/Doc ID 626133.1 (former KB Article OTI-00-0156 - "XE Single Threaded UBE's"). If your default queue is multi-threaded, you will need to re-assign all of these UBE's to an alternative single-threaded Queue (or Queues).

Until now, there was no easy way to bulk-update this setting, because it is hidden deep inside BLOB fields in the Database.

Update Queue Names In Versions changes that. You do not need to know what Versions have the old Queue Name overwritten - it finds them all. The whole process typically takes less than a minute. Here's a screenshot of the tool:

All actions are conveniently reported in PDF format for your reference. The Trial Run facility and the UBE / Version Selection Criteria provide for the ultimate flexibility and safety. A Trial Run with blank selections is a way to document all of your existing Queue assignments - it will produce a PDF file, listing all existing UBE's and VER'sions along with the currently assigned Queue Names. Due to an ERP9 bug, Version Revisions program in ERP9 does not show the Queue Names assigned in Versions, so this tool is the only means to actually find out what queue names are assigned to what versions.

Update Queue Names In Versions also allows to bulk-update the Print Data Selections on the Cover Page flag in the affected Versions, so that every time any such Version is run, it's actual Data Selection Criteria will automatically print on the Cover Page - these DS can be different from the standard DS, if the user made any changes when submitting the job. This is done independently of the Queue Name update, so that either or both can be done in any combination.

Sample PDF's:
Updating all R421* Versions to use QBATCH Queue
Updating all R425* Versions to use QB7333 Queue
Updating all R42* Versions to remove Queue Overrides

Downloadable Demo Video

A Limited Trial version is available upon request - limited to changing <BLANK> Queue Names to literal "TRIAL" and the other way around, in a small number of standard versions.

There are no hardware dependencies, as all Updates are done through OneWorld/EnterpriseOne® API's (but not by using Check-Out/Modify/Check-In sequence, that's why it's so incredibly fast), ensuring consistent results.

Many reference sites are available worldwide.