I have a data directive on UD100 to auto increment Key1. The code syntax checks out ok and Key1 is auto incrementing as expected once I manually enter the first records value. However when I run validate I get the error “Index was outside the bounds of the array”. I used code found in an older po…

@klincecum your latest works until I go over 100 and then I have the same issue. [image] I was able to get it to work by using int lastRecord_ID = 100000; Unless you have another suggestion?

[image] dgross: your latest works until I go over 100 and then I have the same issue. Because I didn’t think far enough ahead. I’m dense sometimes. Give me a minute. We’ll go X amount of digits.

int lastRecord_ID = 0; Ice.Tables.UD100 lastRecord = null; try { lastRecord = (from ud100Rows in Db.UD100 orderby ud100Rows.Key1 descending select ud100Rows).First(); } catch {}; if(lastRecord != null) lastRecord_ID = Convert.ToInt32(lastRecord.Key1); f…

THANK YOU!!! that works. I left it at 10 leading zeros to be safe. This is basically a sequential Request No that will be printed on a form and the Key1 field is the link from the Kinetic Landing Page to the Detail page. Thank goodness for DMT as I utilized it to Add and Delete records for the UD…

Issue could be orderby key1, which is a string. You need to convert it to an int to get the real number.

here is a link to the latest way to get next id. [image] Auto Numbering - Customer ID Epicor ERP 10 It has been fun seeing the document that i published YEARS ago roll around the internet on how to auto-assign customer/supplier/project ID. I made it to be public for that …

[image] knash: You need to convert it to an int to get the real number. Tunnel Vision. [Focus What They Want GIF by Graduation] Original code with one minor change: orderby Convert.ToInt32(ud100Rows.Key1) descending int lastRecord_ID = 0; Ice.Tables.UD100 lastRecord = null; try { las…

Sorry @klincecum but the latest code is making the Key1 = 1 for all records. Original code with one minor change: orderby Convert.ToInt32(ud100Rows.Key1) descending

Weird, then use the one that does :slight_smile:

Wonder if it this would work? lastRecord = (from ud100Rows in Db.UD100.OrderByDescending(i => Convert.ToInt32(i.Key1) ) select ud100Rows).First();

Index was outside the bounds of the array in Data Directive Custom Code on UD100

Kinetic ERP

knash (Ken Nash) April 12, 2023, 5:38pm 15

here is a link to the latest way to get next id.

Topic		Replies	Views
UD100/UD100A Auto Increment Epicor ERP 10	3	2315	May 1, 2018
Increment Key for UD table in BPM Epicor ERP 10	14	5214	July 31, 2020
UD Table Relations - data type error - Number of Rows in xxx query Epicor ERP 10 bpm	14	1840	August 17, 2020
C# Code UD Table Sort - Help Needed Epicor ERP 10 bpm	5	1057	May 6, 2021
Setting UD Table Key using C# Expression failed on Convert.ToInt32 Epicor ERP 10 e10	4	1560	February 21, 2019

Index was outside the bounds of the array in Data Directive Custom Code on UD100

Related topics