Disable warehouse

[Former Member]

Hi all,

In B1, can we disable a warehouse? Meaning to say, the user cannot pick up any transactions in that particular warehouse. Is there such feature in B1? I would not want the user to use that warehouse for some reason.

Thanks.

[Former Member · Accepted solution]

Hi Harith,

There is no such function in the system yet. One work around we tend to use is to use a formatted search behind the WH column in the table in the order. The search would change the WH code if a looked one is selected.

SELECT

Case

When $[ $38.24.0 ] = '01' Then '02'

Else $[ $38.34.0 ]

End

This example applies to cases when you want to lock WH with code "01". You can customize this a bit if neededas per your needs.

Regards,

Varun

SAP Business One Forum Team.

Edited by: Varun Kumar on Nov 27, 2008 9:00 PM

Edited by: Varun Kumar on Nov 27, 2008 9:01 PM

Edited by: Varun Kumar on Nov 27, 2008 9:01 PM

[Former Member]

Harith,

In the item master data --> inventory data tab --> warehouse rows grid --> Locked column.

you just tick locked column refer to a certain warehouse that it is not allowed to use

John

[Former Member]

Hi John,

Thank you for your reply. Does this apply to all the items? Or do i have to tick in each of the items? It look like i have to tick in each of the item.

Thanks.

[former_member186095]

Harith,

you could use item and warehouseinfo templates DTW to lock the warehouse for all items

Rgds,

[Former Member]

Hi Harith,

You are right. This option needs to be activated for each item. What you can do to speed up the process is to use DTW to update the item master records - to lock a particular warehouse for all item codes.

However keep in mind that this will not help for newly created items in case you want to lock a warehouse indefinetly. This can be used if you want to lock warehouse temporarily, for stocktake etc.

If you need to do this indefinetly and if your GL a/c set up is by warehouse, another workaround is possible -

1. Create dummy GL accounts for all the essential a/c to be assigned to a warehouse.

2. Link the dummy accounts to the warehouse.

3. Put these GL accounts on hold indefinetly.

This way even if user uses the warehouse the posting will not go thru and the system will prompt error. This again is restricted to the scenario where use use GL accounts by warehouse set-up for items.

Hope it helps.

Regards,

Hamsa

[Former Member]

Dear Hamsa,

Thank you for your prompt reply. Yes you are correct. My concerned was to do stock take. Anyhow, thank you very much for your concern.

Thanks.

[Former Member]

Hi Hamsa,

How you will put GL accounts on hold indefinetly?

[Former Member]

Hi Poonkodi,

From the chart of accounts window, click on the account details button. In this window, there is an option to put GL accounts on hold. You specify the end date to be 31.12.99.

Regards,

Hamsa

[Former Member]

Hi Hamsa,

Thanks.