Dynamics Community Forum Thread Details

Pick locations is blank on completed work

Hi all,

I've already passed this problem to our IT department but they have apparently found the key issue and fixed it; but it still means we have thousands of stock trapped.

The problem is that we have alot of stock with negative values where the location is blank. Having looked at the transactions, it appears it stems from work where the pick location is blank. The work is completed otherwise successfully and the sales/transfer orders are invoiced.

This has happened to many of our lines, and we have been waiting over two months for a reply from our IT department to no success other than a shrug.

As this has no location, we cannot stock move, quantity adjust or otherwise get rid of the stock; Must enter a location popup is a rather annoying theme at this point.

The sales order are always in an invoiced state.

As an end user, is there anything that can be done our side. I have suggested going through inventory management and using the cleanup functions; although I guess they have aready tried this. I have little knowledge of the back end of AX, and know to keep well away from InventDim and InventSum possibilities.

I'm going to use my upcoming time off to dip into the complexities of AX, but that will still be very limited. I was given access to the test system to look at this issue, as I wouldn't have touched this on the live system.

Hope you all can help.

Hi Code,

Can you share the setup done on the Storage Dimension Group? Is a blank value allowed on the location according to the setup? If so, you can use a transfer journal to move the goods from the blank location to an actual location.

If blanks are not allowed, it would not be possible to correct it by a user. In that case, you have to create a copy of this environment and see if the next procedure can help:

- In SQL or using an x++ job, change the setting for the location to allow blanks (currently coding is preventing you to do it directly on the storage dimension group form)

- Then create the transfer journal and post it.

- revert the change to not allow blank values.

Test it carefully before doing anything in the production environment.

Quick Links