Sunday, September 23, 2018

How to suspend RecId Sequence - Dynamics 365 for Finance & Operations

Hi,

as you know in D365FO now the sequences are handled by SQL and not anymore from the SYSTEMSEQUENCES table.

From particular scenarios could be necessary to suspend the Recid assignement.
In order to do that, issue the following command:

appl.sysRecIdSequence().suspendRecIds(tableNum(TABLENAME));

Tale a look also to the standard AccountingDistributionProcessor class, SuspenAccDistRecidAssignment method.

Till soon!

Sunday, September 16, 2018

How to avoid Retail Module configuration reset - Dynamics 365 for Finance & Operations LBD

Hi mates,

if in your LBD implementation the Retail Module disappear after a Deployment, here how to avoid it.

After a chat with Microsoft, to prevent DB sync from resetting the config keys (Retail in my case), issue the following command against the AxDB Database from sql server management studio:

INSERT INTO SQLSYSTEMVARIABLES (PARM, VALUE, IPARM, IVALUE) VALUES ('FirstSyncSuccess', 1, 20, NULL)

It seems that in the next months a new KB will be release in order to fix that.

In the next Deployments you can sleep peacefully that the Retail Module will be there again!

Till soon!