Renaming Blank Location Code

akerstiens

Hello everyone!

I have a client who has been a Navision user for over 10 years now. Back in the ealier versions the system would allow a blank location code #-o , however they have upgrade top NAV 3.7a

What I would like to do is rename this blank or null instance to a real name, to me this would be the cleanest way to so becuase it would run through the database and modify all the tables it needs to making everyone happy :-)

When I try to name the location I am coming up against an error stating "You can not rename the old vale of the field because it is '')

Has anyone come across this?

Thank you in advance!

Aaron Kerstiens

Savatage

I don't believe you can't rename blank to something else.
You could create an update report to go thru whatever tables you need to and fill in the field.
It will have to be done in a bunch of places and I understand that simply changing blank and having the system run thru everything sounds very easy.

Don't forget to test before going live.

ara3n

Use developer toolkit to find all the tables that have relationship with location. Write a report to modify all the blanks to the new code.
I wish Nav by default didn't allow Code when part of primary key not be blank, unless you specifically allowed it through a property.

Be careful when you are updating the records, mainly on sales line and purchase line. Also I always check in Inventory Setup. Location mandatory. that way this won't happen to transactions.

akerstiens

Thank you for your feedback!!
This is a challenging issue for sure; I think I might have come up with another solution that might be able to do the trick. I am considering using the transfer journal to move the stocked items to a named warehouse. Then make the default location equal to the new warehouse. Then find a solution on how to deal with open PO's.

ara3n

Good luck. For open PO you can wait till your fully receive/invoice them and then transfer them Once everything is in history, you can fix the data.

sneha

I have one question in this topic. My client using 5.0Sp1 (Native). Somehow “Location Mandatory” was not turned ON in the Inventory Setup; as a result some entries get posted with an empty location code. Now, Can I turn ON the “Location Mandatory” to avoid the future transactions without having a Location Code?

ara3n

Yes.

sneha

Thank you for your immediate reply!

In our case, we have very less ILE quantities with Status OPEN and Location Code = ‘’. I am thinking, below process would be better rather than changing the Location Code manually.
1. transfer (location transfer) the quantity from empty location to New Location
2. And then Turn ON the “Location Mandatory” on Inventory Setup.

ara3n

Yes. That would work as well.