Solved

Ideal way to deactivate a part

  • 11 November 2021
  • 4 replies
  • 230 views

Userlevel 4
Badge +7

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?

icon

Best answer by Vimukthi Mahakumbura 11 November 2021, 16:53

View original

This topic has been closed for comments

4 replies

Userlevel 7
Badge +18

@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. 

Userlevel 7
Badge +21

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

Userlevel 4
Badge +7

Hi @Vimukthi Mahakumbura 

Custom event solved the issue. 

Thanks for the help!

 

Regards,

Malmee.

Userlevel 4
Badge +7

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.