Generating Symbolic Number at the time of Syndication

[Former Member]

Hi! All

I have the following user requirement:

The Material number in one of the client system is in the following format-

70000-00001, which is a symbolic number. There are already 54000 records in that particular system. These records needs to be cleaned by MDM and then syndicated back to the respective system with the number being generated in the same format ie. symbolic number and also if any record is added further, it should generate the number in the ascending order. For Eg. 70000-00001, 70000-00002, 70000-003, etc.

Please suggest me the best possible solution. Thanks in advance for the same.

With Best Regards,

Devendra Pandey

[Former Member]

hi,

if you have AUTO ID field in the main table. It will generate number for each record in the ascending order only.

for example:

700000-00001 for this record the auto id is 001 .

when ever you are syndicating, you can use Cust Items property in the syndicator ( concatenation of two fields).

you can set custom delimiter for custom items.

EX:

1.create a custom item( ex: custom number ), in that custom tab, you can create the formula, click on that formula,

2.select the fields, you want to concatinate, ( in our example: material number and auto ID,), this custom filed you find in the source items.

3.map this Concatinated field to Destination item.

4.and you can synicate

hope this may help you,

Regards,

Srinivas