Two new features have been added to change order references. The first allows change on a global basis based on an external database; the second allows changes to be made on an order-by-order basis.
This procedure operates in a similar manner to the equivalent option within the sales and purchase ledgers. A ‘change’ database, maintained via the Desktop or ProFiler, records two items – the existing reference and the new reference. When the option is selected you are asked to select this database before the system proceeds to change the order references as detailed within the database.
This procedure allows you to amend order references individually, asking for the order reference you wish to amend and the new reference required.
Notes
Both options require an exclusive lock of the order header and detail databases.
If prefixing the order reference with the customer/supplier account code as a ‘contract ref’, then the system will offer to update the account code based on the amended order reference.
To add the new options you need to amend the order processing menu’s to call the parameters for the additional features using the CONFIG sign-on. The parameter numbers are:
7811 – Global Change of Order References
7812 – Change Order Reference
If wish to use the option to globally change order references, then you need to create a new database and the ability to maintain this file. You can create a new database via the DataFiler Database Utilities.
The change database is a fixed structure file with two items – the current order reference and the new reference.
No Item Name Type Description
1 CURR-ORDNO X (16) Prime-index of the change database, this item holds the current value of the order reference.
2 NEW-ORDNO X (16) This item holds the value of the new order reference.
Article ID: 347
Created On: Wed, Jun 13, 2012 at 3:25 PM
Last Updated On: Wed, Jun 14, 2023 at 5:22 PM
Online URL: https://kb.datafile.co.uk/article/change-order-references-347.html