Question

Anyway to link specific inventory lot to specific customer ?

  • 16 July 2021
  • 1 reply
  • 78 views

Badge +1

Hello all,

 

Is there anyway to link specific inventory lot to specific customer ?

 

For example,

Inventory Part : ABC

Lot : 123456

To be link with customer code 123456 only

 

And can be invoiced only to this customer.

I’m thinking about  to use Availability Control ID to handle, but it doesn’t seem to solve the problem.

 

Thank you.


This topic has been closed for comments

1 reply

Userlevel 7
Badge +28

Look into assigning a W/D/R number instead (Waiver, Deviation, Rejection).  Assigning this value tags the part or lot with a unique identifier, then you could begin to restrict the movement on this basis.  You would need an event at some point in the Reservation or Picking process to detect whether the W/D/R value was connected to the correct customer. 

I agree, Availability Code won’t do what you want.  W/D/R might work.  You might also have to use a custom field and possibly a custom table to provide the allowed connections of the customer to product, but then still would need a check of the order to make sure it is valid before invoicing.