You’re offline. This is a read only version of the page.
Hello,
I would like to ask what is the easiest way to migrate number sequence codes in D365 FO with 3 segments (Company, Constant, Alphanumeric)? (1st question)
I am straggling with specific field "ANNOTATEDFORMAT". When you export data entity "number sequence code" into excel, the mentioned cell contains Tabulators and Enters (new lines) as it is visible when copy-pasted to Word.
I know combination alt-enter for new line in a cell, however I am not aware of key combination for Tab, as just simple Tab sends you to next cell. Does anybody know? (2nd question)
I know that if I would use only only field FORMAT in data entity "Number sequence code" without ANNOTATEDFORMAT, even though it would look the same as if I would use ANNOTATEDFORMAT (Company-> Constant-> Alphanumeric) and import it. The Company and Constant would merge together forming only Constant, so the ANNOTATEDFORMAT would be only Constant-> Alphanumeric, which is not desired result.
I have found a way by using Excel function CHAR() and ASCII table, where character 9 stands for Tab and 13 for Enter. By series of these functions you can achieve those Tabs and Enters in one excel cell. And after import I would get the desired result, where ANNOTATEDFORMAT would be Company-> Constant-> Alphanumeric . However I am still wondering, if there is a better way/format how I could import number sequence codes into D365 FO. I don't know, if I am missing something, whether different format can be used, of there is a completely different and better way for import of number sequences. Does anybody have experience with it? (3rd question)
Thank you all in advance
Live long and prosper
Share
Report
All responses (
Answers (
451
