Skip to main content

Hi Community,

When a part is deactivated from the inventory Including sales and purchasing part, system shouldn't allow transactions for the respective part, so can someone suggest the ideal way to deactivate a part from the inventory?

@Malmee Amunugama I would connect a Part Status like this to the Inventory Part. 
When I try to create transactions, it stops me with an error. 

 

If not, you could also use a custom event for this. 


Hi @Malmee Amunugama ,

 

If you want the sales part to disable automatically when you make an inventory part inactive you would need to create an event and action which is triggered when the inventory part state changes to inactive.  In the event action you would need to write the plsql code to change the sales part to inactive.

 

Regards,

William Klotz


Hi @Vimukthi Mahakumbura 

Custom event solved the issue. 

Thanks for the help!

 

Regards,

Malmee.


Hi William,

 

Hi @Malmee Amunugama ,

 

If you want the sales part to disable automatically when you make an inventory part inactive you would need to create an event and action which is triggered when the inventory part state changes to inactive.  In the event action you would need to write the plsql code to change the sales part to inactive.

 

Regards,

William Klotz

 

Thank you for the insight!

 

Best Regards,

Malmee.