Hide Warehouse For all users at Organization

(0) Share

Report

Posted on by Community Member

Dears,

I want to hide/block some old closed warehouses form all users. I don't want to delete them as I don't want to use query too.

Any suggestion?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Community Member on at

Like (0)

Report

Sorry I'm not that much expert, If I add this column to the invent location table how that will reflect at the other forms?, Sure I need to write some codes but where?. Can you give more details?

Was this reply helpful? Yes No
Suggested answer

Hichem.Chekebkeb 3,371 on at

Like (0)

Report

The best solution for your case is to use Policies (Record level security)

Technet explains it very well: https://msdn.microsoft.com/en-us/library/aa570084.aspx

You can find additional articles over net.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you, But as I told you I don't want to use query, that will affect on the future when we get new warehouses. As this may affect the other organization is in't?.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

you can do that with standard AX functionality without write any codes as the following go

to product information management /released products/ select your product/manage inventory tab

and site specific order setting.

you can stop this site for this product on (sales /purchase/inventory)

just click override checkbox and tick stop

Was this reply helpful? Yes No
Suggested answer

Andrew Xu 3,877 on at

Like (0)

Report

Where do you want to hide?

If you want to hide them at the form InventLocation, you just need to overwrite the method init() of datasource InventLocation with following code,

public void init()

{

super();

this.query().dataSourceName('InventLocation').addRange(fieldNum(InventLocation, InventLocationId)).value(queryNotValue('Your warehouse Id'));

}

If you want to hide them in the drop down list when user is selecting warehouse, you need to modify the code in lookup method to exclude them, just like the code above.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Andrew Xu thanks, Yes that what I want but only work with one ID can you assist for multiple ranges?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have to do the same for the rest of forms right?

Was this reply helpful? Yes No
Verified answer

Andrew Xu 3,877 on at

Like (1)

Report

For multiple warehouses,

this.query().dataSourceName('InventLocation').addRange(fieldNum(InventLocation, InventLocationId)).value('!WarehouseId1, !WarehouseId2, !WarehouseId3');

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you that awesome, can you tell me more about the lookup methods?

Was this reply helpful? Yes No