Table of Contents

Picklist proposal

See the Stock allocation algorithm section for information about the rules of creating picklist proposals.

1. Disallowed locations

Stock on some locations is not allowed to use for creation of pick list proposals.
This includes:

  • Can be lined up locations linked to a production line
  • Input location of a production line
  • The production line
  • Special locations linked to a warehouse
  • Moveable locations
  • Locked locations (Cycle count)
  • All locations linked to a WA location

There is a view that is used to get those locations: PMX_DISALLOWED_LOCATIONS_FOR_PICKING

This view used a table with cached data: PMX_CDLP
This table contains the following data:

  • Can be lined up locations linked to a production line
  • Input location of a production line
  • The production line
  • Special locations linked to a warehouse
  • Moveable locations
  • All locations linked to a WA location

The query that is used: 

 SELECT "PMX_OSEL"."Code" FROM "PMX_OSEL" WHERE "PMX_OSEL"."TypeCode" IN (N'PRODLINE', N'MOVLOC')
 UNION  SELECT "PMX_OSPL"."InputLocationCode" FROM "PMX_OSPL" WHERE "PMX_OSPL"."InputLocationCode" IS NOT NULL
 UNION  SELECT "PMX_OSPL"."PickToLocationCode" FROM "PMX_OSPL" WHERE "PMX_OSPL"."PickToLocationCode" IS NOT NULL
 UNION  SELECT "PMX_CBLU"."CanBeLinedUpLocationCode" FROM "PMX_CBLU"
 UNION  SELECT "PMX_OSWH"."StorLocLogCar" FROM "PMX_OSWH" WHERE "PMX_OSWH"."StorLocLogCar" IS NOT NULL
 UNION  SELECT "PMX_OSWH"."StorLocRetItem" FROM "PMX_OSWH" WHERE "PMX_OSWH"."StorLocRetItem" IS NOT NULL
 UNION  SELECT "PMX_OSWH"."StorLocLostAndFound" FROM "PMX_OSWH" WHERE "PMX_OSWH"."StorLocLostAndFound" IS NOT NULL
 UNION  SELECT "PMX_OSWA"."InputLocationCode" FROM "PMX_OSWA" WHERE "PMX_OSWA"."InputLocationCode" IS NOT NULL
 UNION  SELECT "PMX_OSWA"."InputWithBoxLocationCode" FROM "PMX_OSWA" WHERE "PMX_OSWA"."InputWithBoxLocationCode" IS NOT NULL
 UNION  SELECT "PMX_OSWA"."OutputLocationCode" FROM "PMX_OSWA" WHERE "PMX_OSWA"."OutputLocationCode" IS NOT NULL
 UNION  SELECT "PMX_OSSL"."Code" FROM "PMX_OSSL" WHERE "PMX_OSSL"."BlockStockFromBeingUsedOnProposal" = N'Y'

The cached table is filled when the add-on or fat client is started.

The locked locations are retrieved when running the view, because this information can change a lot.

2017/06/12 11:11 · csuhaa

2. Shelf life calculation

In order to calculate the shelf life of an item for a particular customer & shipping address, the systems evaluates the shelf lives that can be found at different places. The first matching shelf life will be taken into account, according to the following priority:

  • shelf life defined in the sales order line (RDR1.U_PMX_SHLF column)
    • Note: Produmex WMS does not support negative shelf life values.
  • shelf life defined on the item master data for the customer code and country code
  • shelf life defined on the item master data for the customer code
  • shelf life defined on the item master data for the country code
  • shelf life defined for the customer code and country code (@PMX_CSSL user table)
  • shelf life defined for the customer code (@PMX_CSSL user table)
  • shelf life defined for the country code (@PMX_CSSL user table)
  • shelf life defined on the item master data (OITM.U_PMX_SLID field)
2017/06/12 11:13 · csuhaa