Home » Categories » Solutions by Business Process » Profiler

Copy Items Back to Lookup File (9902)

Datafile Software

Copy Items Back to Lookup File (9902)

This special action allows the setting within Profiler screens of up to sixteen copy items from the main file back to the lookup file, each with their own definition of a lookup database, lookup item and from/to copy items.In addition these items can be set to only action when adding, updating or replication a record or to only copy back when the ‘copy back’ item value is changed.

Within the screen design select ‘Parameters’ and then the option ‘Extra File / Record Lookup & Updating’ followed by ‘Custom Points’.

Set the option number ‘9902’ as the custom point, leave the suffix blank and you will then be prompted to change the ‘Write Back to Lookup’ definition – respond ‘Yes’ to this.

Lookup DB – here you set the Profiler file number of the file you want to copy back to. This file must be defined within the Data File Profiles of the application as a lookup from the file number the screen is based upon.

Lookup Item – here you set the data item number that is the lookup code on the main file.

Copy From – here you select the item on the main file that you want to be copied back to the lookup file.

Copy To – here you select the item on the lookup file that is being updated from the main file.

If Add – if set then the copy item is actioned whenever a record is added to the main file.

If Upd – if set then the copy item is actioned whenever a record is updated on the main file.

If Rep – if set then the copy item is actioned whenever a record is replicated on the main file. Copy items are actioned after update of the replicated record.

Condition – within the Application Profile you can define up to fifteen test conditions per file.This prompt asks for the condition number to apply to this copy item. If the condition is true the copy is actioned.

Warn – if set then when the copy ‘from’ item is different from the value of the copy ‘to’ item the system will warn the values are different and ask for OK to proceed with copy.

Only Write Back if copy back value changes – if set then the copy items are only actioned when the value in the ‘copy from’ item is changed.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Screen Options - Increment Code within ‘Location’
Viewed 1641 times since Fri, Oct 26, 2012
Generate Stock Transactions (9909)
Viewed 1487 times since Fri, Jun 29, 2012
Operational Overview - EDI Order Processing
Viewed 1541 times since Thu, Jul 5, 2012
General Details
Viewed 1520 times since Thu, Jun 28, 2012
EDI Messages and Files
Viewed 1835 times since Thu, Jul 5, 2012
Systems Constants File - EDI Order Processing
Viewed 2043 times since Thu, Jul 5, 2012
Configuration - Application Settings
Viewed 1476 times since Fri, Jun 29, 2012
Automatic (Q) Menu - Default to Email
Viewed 1724 times since Mon, Jun 11, 2012
Create New Database
Viewed 2299 times since Fri, Jun 29, 2012
G2 – Extract Records between Database Files
Viewed 924 times since Thu, Jun 28, 2012