Below piece of code can be used to retrieve next record Id from the table.
SystemSequences systemSequences;
SystemSequence systemSequence = new
SystemSequence();
systemSequence.suspendRecIds(tableNum(SalesTable));
systemSequence.removeRecIdSuspension(tableNum(SalesTable));
static void
getNextRecId(Args _args)
getNextRecId(Args _args)
{
//Table that stores record ids details for tables
SystemSequences systemSequences;
//Class that handles Record id generation
SystemSequence systemSequence = new
SystemSequence();
;
info(strFmt(“%1”,
tableNum(SalesTable)));
tableNum(SalesTable)));
systemSequence.suspendRecIds(tableNum(SalesTable));
info(strFmt(“Next
record id: %1”, systemSequence.reserveValues(1,tableNum(SalesTable))));
record id: %1”, systemSequence.reserveValues(1,tableNum(SalesTable))));
systemSequence.removeRecIdSuspension(tableNum(SalesTable));
}
