Field settings
ITEM Record >VENDOR Record (Subsidiary is not supported) | |
|---|---|
Preference | Description |
VENDOR BILL - PURCHASE ORDER QUANTITY TOLERANCE | Enter the tolerance limit for the discrepancy between the quantity on the vendor bill and purchase order |
VENDOR BILL - PURCHASE ORDER AMOUNT TOLERANCE | Enter the tolerance limit for the discrepancy between the amount on the vendor bill and purchase order. |
VENDOR BILL - PURCHASE ORDER QUANTITY DIFFERENCE | Enter the difference limit for the discrepancy between the quantity on the vendor bill and purchase order. |
VENDOR BILL - ITEM RECEIPT QUANTITY TOLERANCE | Enter the tolerance limit for the discrepancy between the quantity on the vendor bill and item receipt. |
VENDOR BILL - ITEM RECEIPT AMOUNT TOLERANCE | Enter the tolerance limit for the discrepancy between the amount on the vendor bill and item receipt. |
VENDOR BILL - ITEM RECEIPT QUANTITY DIFFERENCE | Enter the difference limit for the discrepancy between the quantity on the vendor bill and item receipt. |
Expected behavior for 3-way matching
The tolerance limits can be defined on any of the following records: (Vendor, Item)
If the tolerance limit is defined on more than 1 of these records, the order of precedence is ITEM>VENDOR.
Matching between vendor bill and purchase orders will always be executed when one of the following is defined in either the vendor or item record:
VENDOR BILL - PURCHASE ORDER QUANTITY TOLERANCE
VENDOR BILL - PURCHASE ORDER AMOUNT TOLERANCE
VENDOR BILL - PURCHASE ORDER QUANTITY DIFFERENCE
Matching between vendor bill and item receipt will always be executed when one of the following is defined in either the vendor or item record:
VENDOR BILL - ITEM RECEIPT QUANTITY TOLERANCE
VENDOR BILL - ITEM RECEIPT AMOUNT TOLERANCE
VENDOR BILL - ITEM RECEIPT QUANTITY DIFFERENCE
If a tolerance preference is filled out, it will be validated. If more than one tolerance preference is filled out, all of them will be validated.
IF one or more validations return F then discrepancy within limits = FALSE ELSE discrepancy within limits = TRUE.
Discrepancy computation used
BILL - PO Discrepancy
ABS(PO Quantity - Bill Quantity) / PO Quantity
Bill - IR Discrepancy
ABS(IR Quantity - Bill Quantity) / IR Quantity
If the tolerance setting is null, it means that validation for that will not be executed. Entering zero means that an exact match is required.
Out of scope: Partial receipt and billing for partial receipt. (If you only need validation between the vendor bill and item receipt then only the IR-BILL tolerances must be filled out in the tolerance settings.
Upon saving an Item Receipt of a vendor bill where INFlow status = goods pending, the script will perform the IR to Bill matching.
1% is the minimum tolerance limit.
Limitations:
Manually creating a vendor bill from the item receipt does not trigger the vendor bill matching validation.
...