Skip to main content

Hi All,

 

I am looking for some confirmation on a question(s).

 

Situation:

For both CPO/Shipment and WO we can create ‘Pick Lists’. But it seems that - although they are both called ‘Picklists’ - they are not the same. 

We already notice this with the Pick List numbering which does not seem to follow in order. CO/Shipment picklist can be a high number, but the WO picklist is a low. And if you create first a WO picklist and get for example ‘5’, then a CO/Shipmennt picklist could be ‘1256’ and again a WO picklist that would be ‘6’ (following on 5). So it seems they follow different incremental values.

 

It also shows on ‘Picked Pick List lines’, where the ‘Source Ref’ = ‘WO’ cannot be selected, there is only ‘Customer order’ / ‘Project Deliverables’ / ‘Shipment Order’ / ‘Purchase Receipt Return’.

 

Pick by Choice only seems to work on CO/Shipment Picklists, not on WO picklist.

 

 

 

So questions:

  1. Am I right that these are 2 totally different  sets of tables?
  2. If so, would it not have been more transparant if we would have used different names (for example not use just ‘Pick List’ but call it ‘WO Pick Lists’ so that this is more clear.
  3. Is it also possibel to use pick by choice on WO Picklists?
  4. If not, is does on the roadmap somewhere? Or is it the IFS intention to bring these 2 pick lists together into 1 table?

 

Best Regards

Roel Timmermans

​@Timmermans Roel I’m commenting to bump this post up in the charts as I’m also curios if anyone from IFS will leave a reply on this.

I did a bit of research and debbuging and what I found is the following: 

In Oracle there are 3 sequences (DB Object responsible for incrementing and providing an id).

   INVENT_PICK_LIST_NO_SEQ → CO/Shipment Picklist
   PICK_LIST_NO_SEQ → Maintenance Material Requisition Picklist → the one generated from WO 
   SO_PICK_LIST_NO → Shop Order Picklist

Indeed, it would be interesting if IFS could consolidate all of this into a single Picklist table and maybe adding a new column for Picklist_Type: Shipment / WO / SO.

Pick by Choice only works for Picklists originating from Shipment. No idea if there are any plans on extending this functionality to the other picklist types. 

Thanks Marcel! A consolidated Picklist Table would indeed be an interesting development.

Reply


Terms & ConditionsCookie settings