Tag: al

Guid.CreateSequentialGuid in AL

This feature is simulating and also similar (not the same) to what the SQL NEWSEQUENTIALID does in order to generate consecutive GUIDs. See more on: NEWSEQUENTIALID (Transact-SQL) - SQL Server | Microsoft Learn This command is available since SQL Server 2005 (version 9.0). So the first question comes natural (why they took so long... NAAA...... Continue Reading →

0

Sorting by Type and Line No. in Sales and Purchase Postings

Legacy posting has been performed, for ages, following the primary key sorting order: (“Document Type”, “Document No.”, “Line No.”). And when it is time to post, it posts one document at the time. So, now, the sorting order is following the “Line No.”.  With very heavy concurrency and/or in stretched exotic scenarios, processing by following... Continue Reading →

1

Blog at WordPress.com.

Up ↑