State code error

[Former Member]

Hello,

We have an error with our state codes. Both Manitoba and Minnesota have the code MN. The correct postal code for Manitoba is MB. When I go to the states table to change it, it will not let me change the code, only the name. If I try to remove the MN row from the table I get the error: Cannot remove; state is used in shipping address table (CRD1) [Message 80089-2]

Please let me know if there is a way around this.

Thank you.

[Former Member · Accepted solution]

Hi.......

System is behaving perfectly.

If your State is linked to any BP ship to address then it must not allow you to remove it.

You have to delink it from address. and then try to change or remove......

for finding Address linked with this state code please run this Query.

Select * from CRD1 T0 where T0.State='MN' 

This report will give you all the BP linked to

Regards,

Rahul

[Former Member]

Run a query first to check what code you have now:

SELECT * FROM OCST WHERE CODE LIKE 'm%'

You need to create MB first if there is no such code.

[Former Member]

SAP Business One 8.8 (8.80.234) SP: 00 PL: 16

I will try the suggested fix.

Thanks!

[Former Member]

Hi,

Welcome you post on the forum.

What is your B1 version and PL? I think the default table for 2005 and 2007 has the correct code as MB.

Thanks,

Gordon