Merging customers and getting error code

[conlee7]

Hi,
I am trying to merge 2 customers. One is a US customer and one is Canadian. I have outstanding invoices for both of them. When I try to merge them I get the error message.. Error changing number/code! Error Code=127

Can you tell me what this means and how I merge them?? Thank you..

 

[ettienne]

Error 127 = duplicate key.
Version & service packs?

 

[ettienne]

I missed that one is US and the other is Canadian, do the customers have the same currency?

 

[conlee7]

5.5A (Sage Accpac 100 ERP) (Build 42) (Product Update 4)

No not the same currency.. but merging to Canadian.

 

[ettienne]

You cannot combine customers with different currencies.

 

[conlee7]

Sorry after double checking they are both Canadian Currency. I just assumed one was US because of the address.

 

[ettienne]

Which table was it on when it failed?
You can also print the audit log.

 

[conlee7]

I printed the error... it says

Customer Number Change Error Log

A/R Selected Customers Error changing number/code! Error Code = 127

 

[ettienne]

Duplicate key
You have to figure which record is causing the problem.

 

[conlee7]

I do not understand what a duplicate key is..

 

[Jay Converse]

This is a known problem. Delete all the records in ARSLCUS with a database editor, or run a statement with only one customer selected.