cancel
Showing results for 
Search instead for 
Did you mean: 

Warehouse code and warehouse name mismatch

Former Member
0 Kudos

Hi All,

We have upgraded from SAP B1 2007B to SAP 8.8.

After upgradation there is a mismatch of warehouse codes and warehouse names in inventory tab of item master screen.

In order to investigate the issue we did following things

Checked warehouse setup. Found Ok

We ran a query on oitm and owhs. Found Ok

still there is a mismatch in case of all items in GUI

This is not the case while adding an item.

Thanking you

Pradnya

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member541807
Active Contributor
0 Kudos

hi,

try to run this query

Select * from CINF

a field was added to the CINF table in SAP Business One. the name of the field is Companysta. please check the Value of this field

V (Valid) - successful upgrade

I (Invalid) - cannot log-on probably due to upgrade failure

U (Upgrading) - log-on is block since the database is currently being upgraded.

hope this will help you.

best regards.

Fidel

Former Member
0 Kudos

Hi,

It was a successful upgrade . The value in CompanySta field is V.

Thanking you

Pradnya

Former Member
0 Kudos

Hi,

You need query OITW to find the problem.

Thanks,

Gordon