error: the customer - reference combination already exists

Question

is there a way to bypass this error when entering a customer reference number on the product-customer tab? I need to be able to enter the same code for multiple customers on the same product. I cannot seem to find a setting anyplace. 
 thanks 
 Christine

Nick Brown CPiO · Accepted Answer

Hi Christine, the restriction comes from the index on the ITMBPC table which does not allow duplicates of the BPCNUM and ITMREFBPC fields. 
 The reason for the index is some of the Sales functions, such as Sales Orders allow you to enter the line details using the Customer Product or, via the action button on the Product field performing a search of existing Customer Product codes. 
 If the customer does not have their own reference for the product or it is not known, then the field should be populated with your product reference. Leaving the field blank would only work for one product customer reference (per customer), any other products for that customer with no reference would then be classed as a duplicate and so not allowed.

GerkoT3T · Answer

Hi Christine. The value is not mandatory so you could leave it blank. If this is not relevant to you then you are stuck because the rule is hardcoded.

Sage X3

error: the customer - reference combination already exists

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING