The unique identifier of the brands (amBrand) does not correspond to the existing ones

  • KM03792578
  • 26-Mar-2021
  • 26-Mar-2021

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

Customer mentioned that when they try to create a brand, an identifier (BarCode) is automatically generated, this identifier that is generated is already assigned to a brand.

Question

Customer mentioned that when they try to create a brand, an identifier (BarCode) is automatically generated, this identifier that is generated is already assigned to a brand.

Answer

Customer mentioned that when they try to create a brand, an identifier (BarCode) is automatically generated, this identifier that is generated is already assigned to a brand.
We mentioned that the BarCode field in amBrand is filled in by a counter, amBrand_BarCode. If you are getting values that are already in use, one of two things has happened: Either the counter was reset to a lower value or they are not using the correct counter. I would ask them to check the default value in the amBrand.BarCode field and make sure I am using the amBrand_BarCode counter. And also check the value of that counter and make sure it is high enough to be higher than all existing values in that field in the database.