How to enable Material IDs with leading "0" and letters?

[georgk]

Dear all,

we are integrating C4C with a third-party ERP system via a third-party middleware. The material IDs represent Strings that can take various forms.

Although the customer has guidelines about how material IDs should look like, they do have materials "violating" their rules. So in fact, there are no rules or defined formats for the material IDs.

Here are a few examples:

Material 1: GL-02 --> OK

Material 2: NCLA --> OK

Material 3: 0128457 --> leading "0" gets truncated, result is 128457 which is WRONG

Material 4: 85438746 --> OK

Material 5: G02W-545965463 --> OK

The only issue we have are materials with the leading "0". This leading "0" is truncated by C4C automatically, as we can't define a fixed length for the material IDs.

Is there a way to configure C4C to accept leading zeros for digits-only material IDs with variable length?

Thanks for your help and best regards,

Georg

[former_member198469 · Accepted solution]

Hi Georg,

Instead of manipulaing the internal ID you could use the external ID in the whole application.

You could try to map the ERP product ID with the external number of the C4C product and use in all C4C screens only the external product ID.

• Map ERP product ID with the external number of the C4C Product. The external number doesn't convert the ID and should keep the leading 0
• Hide the internal product ID in all C4C screens and display the external ID
• Double-ckeck if the external product id is available within the transactions (searches should include external number via the ID mapping)

For all reporting purposes you can include the data source 'FNDOIMB - object ID mapping' which contains internal and external product ID. By doing so you can report on product dimension.

Best regards,

Clemens