Generate Audit Number

Brian Element
Background

This script will create an number field that keeps a count based on the selected field.  When the contents of the field change it resets to 0 and starts the count over.  There is also a second script that will order the field based on a date field.

Documentation

This script will create an number field that keeps a count based on the selected field.  When the contents of the field change it resets to 0 and starts the count over.

To use this script you must select a file and a field to perform the count on.

Using the sales transaction file as an example and selecting the PROD_CODE as the field we get the following:

If we index the file by PROD_CODE you will see that the auto number changes with the contents of the PROD_CODE changes.

 

Language
IDEAScript

lotis Fri, 01/25/2019 - 00:11

Hi
I would like to create an number field that keeps a count based on the selected field.  When the content of the field change it resets to 0 and starts the count over however, i want it to consider the dates also such that the oldest date is assigned the earliest number

lotis Fri, 01/25/2019 - 00:12

Hi
I would like to create an number field that keeps a count based on the selected field.  When the content of the field change it resets to 0 and starts the count over however, i want it to consider the dates also such that the oldest date is assigned the earliest number

Brian Element Fri, 01/25/2019 - 07:40

Hi Lotis,

I have posted a second script that is what I think you are looking for.  

Brian

Anthony.Kariuki Mon, 08/24/2020 - 05:40

 
I would like to create an number field that keeps a count based on the selected field(Farmer No Or Name).  When the content of the field change it resets to 0 and starts the count  over -Even if he reappears again however, i want it to consider the dates such that on a certain day everytime he appears the count resets
E.g
Farmer_Name Farmer_No Transaction_Code BagTag/Appended_Field
John     KP01   T_09_01   1
John KP01 T_09_02  2
John Kp01 T_09_03 3
Tom Kp02  T_09_04  1
John Kp01 T_o9_05 1

Anthony.Kariuki Tue, 09/15/2020 - 07:18

The solution above resolves the issue

Brian Element Fri, 11/13/2020 - 06:34
That is because the script is for an ASCII version of IDEA and you have the unicode version. If you go to the IDEA passport and look in the IDEAScript vault there is a script that will do the conversation, it is called "Convert ASCII IDEAScripts for use in Unicode". You can also get a copy of the Utility Smart Analyzer app in passport as it contains an improved version of this application.

pixl Tue, 01/07/2025 - 07:15

Hi!
Cannot find the script on that page. Isn't it available anymore?

PATKELL Thu, 03/06/2025 - 10:14

Brian
I am looking for a script that will create transaction in a file it would record that belong together

I thought there was a script that did this

Any thoughts

Pat keller

Brian Element Fri, 03/07/2025 - 07:03

Hi Pat,

In SmartAnalyzer in the utility app that you can download from Passport there is a Sequential Numbering app that might do what you are looking for.  Here is the description of it.  Let me know if you are looking for something different.

The Sequential Numbering utility creates a new SEQ_NUMBER field in the specified database that contains a sequential number based on a user-defined index. You can define up to eight fields for the index. When the transactions based on the index change, then the SEQ_NUMBER field is reset to 1.

The following is an example of the dataset:  

JE_NO    DATE    TIME    PERIOD    
160    2015-12-31    5:55:00    6    
160    2015-12-31    5:55:00    6    
160    2015-12-31    5:55:00    6    
160    2015-12-31    5:55:00    6    
161    2009-01-01    7:17:00    7    
161    2009-01-01    7:17:00    7    
162    2009-01-03    18:24:00    6    
162    2009-01-03    18:24:00    6    
163    2009-01-03    18:24:00    5    
163    2009-01-03    18:24:00    5    
164    2015-07-31    10:21:00    1    
164    2015-07-31    10:21:00    1    
164    2015-07-31    10:21:00    1    

When the Sequential Numbering utility is run on the above dataset, with the JE_NO field defined in the index, the SEQ_NUMBER field is added that contains the generated sequential number for each item with the index. When the index value changes, the sequential number resets to 1.

JE_NO    DATE    TIME    PERIOD    SEQ_NUMBER    
160    2015-12-31    5:55:00    6    1    
160    2015-12-31    5:55:00    6    2    
160    2015-12-31    5:55:00    6    3    
160    2015-12-31    5:55:00    6    4    
161    2009-01-01    7:17:00    7    1    
161    2009-01-01    7:17:00    7    2    
162    2009-01-03    18:24:00    6    1    
162    2009-01-03    18:24:00    6    2    
163    2009-01-03    18:24:00    5    1    
163    2009-01-03    18:24:00    5    2    
164    2015-07-31    10:21:00    1    1    
164    2015-07-31    10:21:00    1    2    
164    2015-07-31    10:21:00    1    3