Validating Imported Records

The Toolkit checks the following in Review and Post to determine if a record is valid or not:

1. There must be a valid quantity
2. PTPARTS.PA_BARACODE must equal PZ_PCODE
3. PTLOCATION.PL_BARCODE must equal PZ_LCODE
4. If PZ_LCODE2 is not empty, PTLOCATION.PL_BARCODE must equal PZ_LCODE2
5. For "Count" or "Add" record types:
   • PZ_TCOST must be greater than 0
   • If PZ_TCOST and the Parts Cost type (PTPARTS, PA_CMET_TY) is "Average", the cost will come from PTPARTS.PA.AVECOST. Otherwise, the cost will come from PZ_COST.
6. For "Remove" record types:
   • If PZ_LCODE must be filled, PTINV.PT_QTY must be greater than PZ_QTY
7. For "Transfer" record types:
   • PZ_LCODE2 must be filled
8. For "Receive" record types:
   • PZ_PO must be filled and match a PTPO.PO_NUMBER, and
   • There must be a detail record matching the part, and
   • The PO and PTPODETAIL.PD_PQTYREM must be greater than or equal to PZ_QTY

     Any other record type is invalid.