AIRS-3860 GR: Avoid Received Qty > Requested Qty

(Jira) AIRS-3860 GR: Avoid Received Qty > Requested Qty
(Confluence) AIRS-3860 GR: Avoid Received Qty > Requested Qty
(Gerrit) AIRS-3860 GR: Avoid Received Qty > Requested Qty

Spec:

• This check can be enabled / disabled on customer legal entity level (by SupplyOn administrator) with configuration of
  • Which POs? Options are “CALLUP”; “Other”
  • Only without UE reference? Options are “Yes”;“No”

This means:

• + Add two columns to tOrganization_SCD
  • cPOTypesToRejectGROvrdlvry (VARCHAR containing semicolon separated list of PO types)
  • cRejectGROvrdlvryWithoutUEs (INTEGER containing boolean)
• + Add two fields to Organization model
  • + Decide what is to do with invalid entries
• + Add code to DAOImpl
  • + read
  • x write (not necessary)
• - Implement validation of these two new flags in SMGoodsReceiptOverdeliveryValidatorSTA
• - Add columns to Agenda
• - Documentation of two new columns (where?)

• + OrderTypeTest
• - SMGoodsReceiptOverdeliveryValidatorSTATest
  • + “global” flag (validateOverdelivery_Overdelivery_Reject() / _DontReject())
    • + false
    • + true
  • + RejectGrOverdeliveryOnlyWithoutUes
    • + true
      • + with Ues → Dont Reject
      • + without Ues → Reject
    • + false
      • + with Ues → Reject
      • + without Ues → Reject
  • + orderTypesToRejectGrOverdelivery
    • + with both types configured
      • + positive
    • + with one type configured
      • + positive
      • + negative
    • + with no types configured
      • + positive

• Example of “comma separated value”: cPOAlertOnStatus
• Maybe the following statements can be useful for data migration (hopefully not):

UPDATE TORGANIZATION_SCD SET cPOTypesToRejectGROvrdlvry='CALLUP,OTHER' WHERE CREJECTGROVERDELIVERY=1;
UPDATE TORGANIZATION_SCD SET cRejectGROvrdlvryWithoutUEs=1 WHERE CREJECTGROVERDELIVERY=1;