Solved

FSM - Change Product on Completed Request

  • 6 August 2020
  • 3 replies
  • 69 views

Userlevel 3
Badge +8

Is is possible to switch the product on a request / Task after it is completed (with part usage, non part usage done)?

 

When we attempt to do so, we cant remove the old product from the request. The error states that it cannot be moved since it is tied to part need, usage & NPU.

 

The way around is it we update all those values with the new request unit ID via SQL DB Query. Is there a more user appropriate way for people to do this day to day vs manipulating the database -

icon

Best answer by Lee Pinchbeck 6 August 2020, 10:16

Hi @jbernardo,

There would be no out of the box way to allow this as the restriction is in place to maintain the integrity of the data and history in the system. 

You may be able to have custom code put in place to make the other required data changes when an attempt to change the product is made so that you do not need to do a SQL DB query but this would need to be carefully done to ensure the data integrity is maintained.

Kind regards,

Lee Pinchbeck

View original

3 replies

Userlevel 5
Badge +10

Hi @jbernardo,

There would be no out of the box way to allow this as the restriction is in place to maintain the integrity of the data and history in the system. 

You may be able to have custom code put in place to make the other required data changes when an attempt to change the product is made so that you do not need to do a SQL DB query but this would need to be carefully done to ensure the data integrity is maintained.

Kind regards,

Lee Pinchbeck

Userlevel 3
Badge +6

You need to be using an exchange type line code also make sure your part becomes product flag is set; also make a decision on if its a controlled part . Then its a matter of what you choose to have happen if you dealing with subcomponents. 

Userlevel 1
Badge +3

Only with configuration,  when request_unit more than 1 record prompt user do you want to update all usages and burn a user def. then if set do a mass update on the records

Reply