Rec.Truncate in AL

Apologize for a one-month+ silence but during go-live season, as Bradely Cooper stated in "Silver Lining playbook": “… It took so long for me to catch up… I just got stuck. Pat. ...I wrote that one week ago…” Cut the crap, you stupid romantic... Aaaand now, ladies and chesterfield, the already buzzed brand new and... Continue Reading →

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 →

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 →

Blog at WordPress.com.

Up ↑