airs-3860
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| airs-3860 [2020/03/05 15:53] – [TODO] kalaschnikow | airs-3860 [2020/03/11 12:11] (current) – [AIRS-3860 GR: Avoid Received Qty > Requested Qty] kalaschnikow | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== AIRS-3860 GR: Avoid Received Qty > Requested Qty ====== | ||
| + | |||
| + | [[https:// | ||
| + | [[https:// | ||
| + | [[https:// | ||
| + | ===== TODO ===== | ||
| + | Spec: | ||
| + | * This check can be enabled / disabled on customer legal entity level (by SupplyOn administrator) with configuration of | ||
| + | * Which POs? Options are " | ||
| + | * Only without UE reference? Options are " | ||
| + | |||
| + | 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** < | ||
| + | * **-** Implement validation of these two new flags in '' | ||
| + | * **-** Add columns to Agenda | ||
| + | * **-** Documentation of two new columns (where? | ||
| + | |||
| + | ===== Unit Tests ===== | ||
| + | |||
| + | * **+** OrderTypeTest | ||
| + | * **-** SMGoodsReceiptOverdeliveryValidatorSTATest | ||
| + | * **+** " | ||
| + | * **+** 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 | ||
| + | ===== Misc ===== | ||
| + | * Example of "comma separated value": | ||
| + | * Maybe the following statements can be useful for data migration (hopefully not): | ||
| + | <code sql> | ||
| + | UPDATE TORGANIZATION_SCD SET cPOTypesToRejectGROvrdlvry=' | ||
| + | UPDATE TORGANIZATION_SCD SET cRejectGROvrdlvryWithoutUEs=1 where CREJECTGROVERDELIVERY=1; | ||
| + | </ | ||
