---
title: "Codeunit 131000 Library - Utility"
author: "JOP-AL"
url: https://jonas-paprotka.de/ref/codeunit/131000-library-utility/
type: codeunit
id: 131000
name: "Library - Utility"
app: "Application Test Library"
versions: "28-29"
build: 29.0.54011.55644
countries: "W1, DE, US"
source: "https://jonas-paprotka.de/ref/codeunit/131000-library-utility/source/"
checked: 2026-11-20
changed: 2026-10-05
subject: "Microsoft Dynamics 365 Business Central"
license: "Metadata from Microsoft's symbol packages. AL source MIT, Copyright (c) Microsoft Corporation. Selection and wording © 2026 JOP-AL. https://jonas-paprotka.de/licenses/"
---

# Codeunit 131000 Library - Utility

JOP-AL, https://jonas-paprotka.de/ref/codeunit/131000-library-utility/

| | |
| --- | --- |
| App | Application Test Library |
| Versions | 28-29 |
| Minors | W1 28.0-29.0; DE 28.0-29.0; US 28.0-29.0, [every minor](https://jonas-paprotka.de/ref/codeunit/131000-library-utility/editions.json) |
| Source file | LibraryUtility.Codeunit.al |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| CreateNoSeries | (var NoSeries: Record "No. Series"; Default: Boolean; Manual: Boolean; DateOrder: Boolean) | - | public | 28-29 | - | - |
| CreateNoSeries | (NoSeriesCode: Code[20]; Default: Boolean; Manual: Boolean; DateOrder: Boolean) | - | public | 28-29 | - | - |
| CreateNoSeriesLine | (var NoSeriesLine: Record "No. Series Line"; SeriesCode: Code[20]; StartingNo: Code[20]; EndingNo: Code[20]) | - | public | 28-29 | - | - |
| CreateRecordLink | (RecVar: Variant) | Integer | public | 28-29 | - | - |
| CreateRecordLink | (RecVar: Variant; LinkType: Option) | Integer | public | 28-29 | - | - |
| CheckFieldExistenceInTable | (TableNo: Integer; FieldName: Text[30]) | Boolean | public | 28-29 | - | - |
| CompareTwoRecords | (RecRef1: RecordRef; RecRef2: RecordRef; FieldCountsToBeIgnored: Integer; DiscardDateTimeFields: Boolean; var FieldNumbersNotMatched: array[200] of Integer; var Value1: array[200] of Variant; var Value2: array[200] of Variant; var MismatchCount: Integer) | Boolean | public | 28-29 | - | - |
| ConvertMilliSecToHours | (TimePeriod: Decimal) | Decimal | public | 28-29 | - | - |
| ConvertHoursToMilliSec | (TimePeriod: Decimal) | Decimal | public | 28-29 | - | - |
| ConvertNumericToText | (NumericCode: Text) | Text | public | 28-29 | - | - |
| ConvertCRLFToBackSlash | (TextIn: Text) | Text | public | 28-29 | - | - |
| FindFieldNoInTable | (TableNo: Integer; FieldName: Text[30]) | Integer | public | 28-29 | - | - |
| GetFieldLength | (TableNo: Integer; FieldNo: Integer) | Integer | public | 28-29 | - | - |
| GetLastTransactionNo | () | Integer | public | 28-29 | - | - |
| GetNewRecNo | (RecVariant: Variant; FieldNo: Integer) | Integer | public | 28-29 | - | - |
| GetNewLineNo | (RecRef: RecordRef; FieldNo: Integer) | Integer | public | 28-29 | - | - |
| GetGlobalNoSeriesCode | () | Code[20] | public | 28-29 | - | - |
| GetNextNoSeriesSalesDate | (NoSeriesCode: Code[20]) | Date | public | 28-29 | - | - |
| GetNextNoSeriesPurchaseDate | (NoSeriesCode: Code[20]) | Date | public | 28-29 | - | - |
| GetNextNoFromNoSeries | (NoSeriesCode: Code[20]; PostingDate: Date) | Code[20] | public | 28-29 | - | - |
| GenerateRandomCode | (FieldNo: Integer; TableNo: Integer) | Code[10] | public | 28-29 | - | - |
| GenerateRandomCodeWithLength | (FieldNo: Integer; TableNo: Integer; CodeLength: Integer) | Code[10] | public | 28-29 | - | - |
| GenerateRandomCode20 | (FieldNo: Integer; TableNo: Integer) | Code[20] | public | 28-29 | - | - |
| GenerateRandomText | (Length: Integer) | Text | public | 28-29 | - | - |
| GenerateRandomUnicodeText | (Length: Integer) | Text | public | 28-29 | - | - |
| GenerateRandomXMLText | (Length: Integer) | Text | public | 28-29 | - | - |
| GenerateRandomNumericText | (Length: Integer) | Text | public | 28-29 | - | - |
| GenerateRandomAlphabeticText | (Length: Integer; Option: Option Capitalized,Literal) | Text | public | 28-29 | - | - |
| GenerateRandomEmail | () | Text[45] | public | 28-29 | - | - |
| GenerateRandomEmails | () | Text[80] | public | 28-29 | - | - |
| GenerateRandomPhoneNo | () | Text[20] | public | 28-29 | - | - |
| GenerateRandomFraction | () | Decimal | public | 28-29 | - | - |
| GenerateRandomDate | (MinDate: Date; MaxDate: Date) | Date | public | 28-29 | - | - |
| GenerateGUID | () | Code[10] | public | 28-29 | - | - |
| GetEmptyGuid | () | Guid | public | 28-29 | - | - |
| GenerateRandomRec | (var RecRef: RecordRef) | - | public | 28-29 | - | - |
| GenerateMOD97CompliantCode | () | Code[10] | public | 28-29 | - | - |
| ExistsDecimalValueInArray | (RowValueSet: array[250] of Text[250]; Value: Decimal) | Boolean | public | 28-29 | - | - |
| FindRecord | (var RecRef: RecordRef) | - | public | 28-29 | - | - |
| LineBreak | () | Text | public | 28-29 | - | - |
| FindOrCreateCodeRecord | (TableID: Integer) | Code[10] | public | 28-29 | - | - |
| CreateCodeRecord | (TableID: Integer) | Code[10] | public | 28-29 | - | - |
| UpdateSetupNoSeriesCode | (TableID: Integer; FieldID: Integer) | - | public | 28-29 | - | - |
| AddTempField | (var TempField: Record Field temporary; FieldNo: Integer; TableNo: Integer) | - | public | 28-29 | - | - |
| GetMaxOptionIndex | (OptionString: Text) | Integer | public | 28-29 | - | - |
| GetMaxFieldOptionIndex | (TableNo: Integer; FieldNo: Integer) | Integer | public | 28-29 | - | - |
| FillFieldMaxText | (RecVar: Variant; FieldNo: Integer) | - | public | 28-29 | - | - |
| DecStr | (str: Text) | Text | public | 28-29 | - | - |
| GetNoSeriesLine | (noSeriesCode: Code[20]; var noSeriesLine: Record "No. Series Line") | Boolean | public | 28-29 | - | - |

## Source

Symbols: Microsoft.ApplicationTestLibrary.symbols.d852d5d2-a39d-4179-baeb-f99a19e32510, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-11-20.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at 4303e5e584d3aa5d9e98cbc615525a5396ad6ed7.

JOP-AL, 2026-11-20.
