Wednesday, March 11, 2020

D365FO Number sequence in powerapps

In below example, i used to fetch next purchase order number from D365FO.

This is not an actual program, just for an entity reference details.

Set(GlbNumberSequenceFormat, LookUp(SequenceTables,NumberSequenceCode="Purc_162",Format));
Set(GlbNextNumber, LookUp(SequenceTables,NumberSequenceCode="Purc_162",Next));
Set(GlbNextPurchaseOrderNumber,Replace(GlbNumberSequenceFormat,6,6,Text(GlbNextNumber,"000000")));

No comments:

Post a Comment