Home » Categories » Solutions by Business Process » Profiler |
Copy Items Back to Lookup File (9902) |
Article Number: 1253 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 5:16 PM
|
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. |
Attachments
![]() There are no attachments for this article.
|
Screen Actions – Links Tab
Viewed 38 times since Wed, Oct 23, 2024
User-Defined Reports - Update Excel Spreadsheet from Accumulators
Viewed 15315 times since Mon, Jun 11, 2012
Q - Batch Run of a Menu
Viewed 1381 times since Fri, Jun 29, 2012
Copy/Move Menu Options
Viewed 1461 times since Thu, Jun 28, 2012
Screen Actions - Allow Details Option when Updating Master Screen
Viewed 110 times since Thu, Jan 9, 2025
Benefits of EDI
Viewed 1499 times since Thu, Jul 5, 2012
Operational Overview - EDI Order Processing
Viewed 1423 times since Thu, Jul 5, 2012
User Defined Report – Omit Print of Item
Viewed 871 times since Wed, Jun 13, 2012
Constraints and Exceptions - EDI Order Processing
Viewed 2649 times since Thu, Jul 5, 2012
Extra 10 Lookup Options (9904)
Viewed 1570 times since Fri, Jun 29, 2012
|