Receipt of Purchase Order by amp99049

VIEWS: 59 PAGES: 5

More Info
									                                                                                        State of Wisconsin                                                                             3/26/2008

                                                                    Integrated Business Information System (IBIS)
                                                                     e8515097-dc64-4fdd-95d1-7ca36c29a0cd.xls

        Rule ID   Description                                            Long Description
B = Basic Match Rule Control delivered in PeopleSoft
   S = Suggest using (IBIS Team opinion)
   R = Recommend using (based on DWD model)
                                    System
B     RULE_S100 Invalid Match Control ID                                 Invalid Match Control ID
B     RULE_S110 Credit Adjustment Quantity > PO Matched Quantity         RTV/Credit Adjustment Quantity is greater than the PO Matched Quantity
B     RULE_S111 Credit Adjustment Amount > PO Matched Amount             RTV/Credit Adjustment Amount is greater than the PO Matched Amount
B     RULE_S120 Credit Adjustment Quantity > Receiver Match Qty          RTV/Credit Adjustment Quantity is greater than the Receiver Matched Quantity
B     RULE_S121 Credit Adjustment Amount > Receiver Match Amount         RTV/Credit Adjustment Amount is greater than the Receiver Matched Amount
B     RULE_S122 Credit Adjustment Quantity > Receiver Match Qty          RTV/Credit Adjustment Quantity is greater than the Receiver Matched Quantity
B     RULE_S123 Credit Adjustment Amount > Receiver Match Amount         RTV/Credit Adjustment Amount is greater than the Receiver Matched Amount
B S RULE_S200 Invalid PO ID exists not set for match                     Invalid PO ID exists but not set for matching.
B S RULE_S201 Invalid Receiver exists but not set for matching.          Invalid Receiver exists but not set for matching.
B R RULE_S210 Invalid PO Status                                          Invalid PO Status
B     RULE_S300 Invalid UOM conversion for PO                            Invalid UOM conversion for PO
B     RULE_S400 Invalid currency exchange rate for PO                    Invalid currency exchange rate for PO
B     RULE_S500 Invalid UOM conversion for Receipt                       Invalid UOM conversion for receipt
B     RULE_S600 Invalid currency exchange rate for Receipt               Invalid currency exchange rate for receipt
B     RULE_S700 Invalid Global exchange rate conversion error            Invalid Global exchange rate conversion error
                                 Data Accuracy
                                                                         No available receipts (not matched, not on hold, and not canceled) were found for the purchase order specified on the
B   R 100         No receipts found                                      voucher line
    S 120         Pay terms not = PO pay terms                           The payment terms code on the purchase order does not equal the payment terms code on the voucher
    R 130         Vendor/Loc not = PO Vendor/Loc                         The vendor or vendor location on the purchase order does not equal the vendor or vendor location on the voucher
    S 140         Voucher item not = PO item                             The item on the voucher line does not equal the item on the purchase order line
      150         Inspection required but not completed                  The item ordered requires inspection but inspection has not been completed
    S 160         Vendor/Loc not = Receiver Vendor/Loc                   The vendor or vendor location the voucher does not equal the vendor or vendor location on the receipt
    S 170         Voucher item not = receiver item                       The item on the voucher line does not equal the item on the receiver line
                                Merchandise
                                                                         Compare the total voucher merchandise amount (gross amount less miscellaneous charges and tax) to the total
                                                                         merchandise amount on the POs less any previously matched amounts. Include amount tolerances from the rule, if any,
        200       Merch amt = PO merch amt with rule amt tol             when comparing the amounts
                                                                         Compare total voucher merchandise amt (gross amt less miscellaneous charges and tax) to the total merch amt on the POs
        210       Merch amount = PO merch amt with rule % tol            less any previously matched amts. Include percent tolerance from the rule, if any, when comparing the amts
                                                                         Compare the total voucher merchandise amount (gross amount less misc. charges and tax) to the total merchandise
                                                                         amount on the receipts less any previously matched amounts. Include amount tolerances from the rule, if any, when
        220       Merch amount = recv merch amt with rule amt tol        comparing the amounts)


                                                                         For non PO receipts, compare total voucher merchandise amt (gross amt less misc. charges and tax) to total merch amt on
        221       Merch amt = non PO recv merch amt w rule amt tol       the non PO receipts less any previously matched amts. Include amt tolerances from the rule, if any, when comparing amts

                                                                     C:\Docstoc\Working\pdf\e8515097-dc64-4fdd-95d1-7ca36c29a0cd.xls                                                      Page 1
                                                                                          State of Wisconsin                                                                            3/26/2008

                                                                      Integrated Business Information System (IBIS)
                                                                       e8515097-dc64-4fdd-95d1-7ca36c29a0cd.xls

       Rule ID       Description                                           Long Description
B = Basic Match Rule Control delivered in PeopleSoft
   S = Suggest using (IBIS Team opinion)
   R = Recommend using (based on DWD model)
                                                                           Compare total voucher merchandise amt (gross amt less misc. charges and tax) to the total merch amt on the receipts less
       230           Merch amount = recv merch amt with rule % tol         any previously matched amts. Include percent tolerances from the rule, if any, when comparing the amts
                                                                           For non PO receipts, compare total voucher merchandise amt (gross amt less misc. charges and tax) to total merch amt on
                                                                           the non PO receipts less any previously matched amts. Include percent tolerances from the rule, if any when comparing
       231           Merch amt = non PO recv merch amt w rule % tol        amts
                                                                           Compare total voucher merchandise amt (gross amt less misc. charges and tax) to the total merch amt on the POs less any
       240           Merch amount not = PO merch amt with rule amt tol     previously matched amts. Include amt tolerance from the rule, if any, when comparing the amounts
    For 250 - 321, would not use all; pick PO, non PO, and receiver match rule corresponding to the type of tolerance implemented. (non PO = direct pay)
                                                                            Compare the voucher line amount to the PO line schedule amount less any previously matched amounts. Include amount
B   S 250            Line amount not = PO line amt with PO amt tol          tolerances from the PO, if any, when comparing the amounts
                                                                            Compare the voucher line amount to the PO line schedule amount less any previously matched amounts. Include percent
B   S 260            Line amount not = PO line amt with PO % tol            tolerances from the PO, if any, when comparing the amounts
                                                                            Compare the voucher line amount to the receipt line amount less any previously matched amounts. Include amount
B   S 270            Line amount not = recv line amt with PO amt tol        tolerances from the PO, if any, when comparing the amounts
                                                                            Compare the voucher line amount to the receipt line amount less any previously matched amounts. Include percent
B   S 280            Line amount not = recv line amt with PO % tol          tolerances from the PO, if any, when comparing the amounts
                                                                            Compare the voucher line amount to the PO line schedule amount less any previously matched amounts. Include amount
    S 290            Line amount not = PO line amt with rule amt tol        tolerances from the rule, if any, when comparing the amounts
                                                                            Compare the voucher line amount to the PO line schedule amount less any previously matched amounts. Include amount
    S 300            Line amount not = PO line amt with rule % tol          tolerances from the rule, if any, when comparing the amounts
                                                                            Compare the voucher line amount to the receipt line amount less any previously matched amounts. Include amount
    S 310            Line amount not = recv line amt with rule amt tol      tolerances from the rule, if any, when comparing the amounts
                                                                            For non PO receipts, compare the voucher line amount to the non PO receipt line amount less any previously matched
    S 311            Line amt not = non PO recv line amt w rule amt tol     amounts. Include amount tolerances from the rule, if any, when comparing the amounts
                                                                            Compare the voucher line amount to the receipt line amount less any previously matched amounts. Include percent
    S 320            Line amount not = recv line amt with rule % tol        tolerances from the rule, if any, when comparing the amounts
                                                                            For non PO receipts, compare the voucher line amount to the non PO receipt line amount less any previously matched
    S 321            Line amt not = non PO rec line amt with rule % tol     amounts. Include percent tolerances from the rule, if any, when comparing the amounts
                                                                            Current voucher quantity plus previously matched voucher quantities, if any, greater than PO line schedule quantity.
    R 330            LTD vchr qty greater than PO qty with receipt tol      Include quantity received percent over, if any, from the PO when comparing the values
                                                                            Current voucher line amount plus previously matched voucher line amounts, if any, greater than PO line schedule amount.
B      340           LTD vchr amt greater than PO amt with PO amt tol       Include amount tolerances from the PO, if any, when comparing the values
                                                                            Current voucher line amount plus previously matched voucher line amounts, if any, greater than PO line schedule amount.
B      350           LTD vchr amt greater than PO amt with PO % tol         Include percent tolerances from the PO, if any, when comparing the values
                                                                            Current voucher line amount plus previously matched voucher line amounts, if any, greater than PO line schedule amount.
       380           LTD vchr amt greater than PO amt with rule amt tol     Include amount tolerances from the rule, if any, when comparing the values



                                                                       C:\Docstoc\Working\pdf\e8515097-dc64-4fdd-95d1-7ca36c29a0cd.xls                                                     Page 2
                                                                                            State of Wisconsin                                                                             3/26/2008

                                                                         Integrated Business Information System (IBIS)
                                                                          e8515097-dc64-4fdd-95d1-7ca36c29a0cd.xls

      Rule ID       Description                                              Long Description
B = Basic Match Rule Control delivered in PeopleSoft
   S = Suggest using (IBIS Team opinion)
   R = Recommend using (based on DWD model)
                                                                             Current voucher line amount plus previously matched voucher line amounts, if any, greater than PO line schedule amount.
      390           LTD vchr amt greater than PO amt with rule % tol         Include percent tolerances from the rule, if any, when comparing the values
                                                                             Current voucher quantity plus previously matched voucher quantities, if any, greater than receipt line quantity. Include
      400           LTD vchr qty greater than receipt qty with PO % to       quantity received percent over, if any, from the PO when comparing the values
                                                                             Current voucher line amount plus previously matched voucher line amounts, if any, greater than receipt line amount.
B     410           LTD vchr amt greater than rec amt with PO amt tol        Include amount tolerances from the PO, if any, when comparing the values
                                                                             Current voucher line amount plus previously matched voucher line amounts, if any, greater than receipt line amount.
B     420           LTD vchr amt greater than recv amt with PO % tol         Include percent tolerances from the PO, if any, when comparing the values
                                                                             Current voucher line amount plus previously matched voucher line amounts, if any, greater than receipt line amount.
      450           LTD vchr amt greater than recv amt w rule amt tol        Include amount tolerances from the rule, if any, when comparing the values
                                                                             Current voucher line amount plus previously matched voucher line amounts, if any, greater than receipt line amount.
      460           LTD vchr amt greater than rec amt with rule % tol        Include percent tolerances from the rule, if any, when comparing the values


      470           Line price not = PO price with PO price amt tol          Compare voucher price with PO price. Include price amount tolerances, if any, from the PO when comparing the values


      480           Line price not = PO price with PO price % tol            Compare voucher price with PO price. Include price percent tolerances, if any, from the PO when comparing the values


      490           Line price not = PO price + rule amt tol                 Compare voucher price with PO price. Include price amount tolerances, if any, from the rule when comparing the values


      500           Line price not = PO price with rule % tol                Compare voucher price with PO price. Include price percent tolerances, if any, from the rule when comparing the values
                                                                             Compare voucher price with receipt price. Include price amount tolerances, if any, from the rule when comparing the
      510           Line price not = receipt price with rule amt tol         values. (non-PO Receipt)


      520           Line price not = receipt price with rule % tol           Compare voucher price with receipt price. Include price percent tolerances, if any, from the rule when comparing the values
                                                                             Compare voucher quantity with PO line schedule quantity. Include quantity received percent over, if any, from the PO when
    R 550           Line qty not = PO line qty with PO received % tol        comparing the values
                                                                             Compare voucher quantity with associated receipt quantity. Include quantity received percent over, if any, from the PO
    R 580          Line qty not = recv qty with PO received % tol            when comparing the values
                               Non-Merchandise
      700          Freight not allowed                                       PO freight terms = paid by seller but voucher includes freight cost
                  Organization Limits and Global Tolerances
    S 800          Small dollar purchase; match automatically                For small amount purchases, automatically match the voucher
      810          Cost exception less than minimum rule tol                 Ignore exceptions when the exception amount is less than the cost of processing the exception
      811          Cost exception less than min rule tol non PO recv         For non PO receipts, ignore exceptions when the exception amount is less than the cost of processing the exception
                                                                             Match when voucher line amount greater than or equal to PO line amount - rule under amount and less than or equal to PO
      820           Global Amount Tolerance                                  line amount + rule over amount



                                                                         C:\Docstoc\Working\pdf\e8515097-dc64-4fdd-95d1-7ca36c29a0cd.xls                                                      Page 3
                                                                                         State of Wisconsin                                                                            3/26/2008

                                                                     Integrated Business Information System (IBIS)
                                                                      e8515097-dc64-4fdd-95d1-7ca36c29a0cd.xls

      Rule ID       Description                                           Long Description
B = Basic Match Rule Control delivered in PeopleSoft
   S = Suggest using (IBIS Team opinion)
   R = Recommend using (based on DWD model)
                                                                       Match when voucher line amount greater than or equal to PO line amount - rule under % and less than or equal to PO line
      830           Global Percent Tolerance                           amount + rule over %
                                   Standard
      Note - these rules are pre-PS 8.9; PS 8.9 added the numbered rules to provide more flexibility - you will see some duplication; for e.g., 100 = R500, 330 = V200
                                                                       The voucher extended price exceeds the purchase order extended price plus or minus (+/-) the extended price tolerance,
      RULE_E100 Extended Price Tolerance                               and the tolerance is not equal to (<>) 0.
                                                                       The voucher extended price exceeds the purchase order extended price plus or minus the extended price percentage
      RULE_E200 Extended Price % Tolerance                             tolerance, and the tolerance does not equal 0.
                                                                       The voucher extended price does not equal the purchase order extended price when the extended percentage and price
      RULE_E250 Voucher Ext Amt <> PO Ext Amt ( No Tolerances)         tolerances are 0.
      RULE_H100 Voucher Pay Terms <> PO Pay Terms                      The payment terms code on the purchase order does not equal the payment terms code on the voucher.
      RULE_H200 Voucher Vendor/Loc <> PO Vendor/Loc                    The vendor on the purchase order does not equal the vendor on the voucher.
      RULE_H400 Voucher Vendor/Loc <> Receiver Vendor/Loc              The vendor on the voucher does not equal the vendor on the receipt.
      RULE_I100 Inspection Required but not Complete                   The item ordered requires inspection but inspection has not been completed.
      RULE_L100 Voucher item <> PO item                                The item on the voucher line does not equal the item on the purchase order line.
      RULE_L200 Voucher item <> Receiver item                          The item on the voucher line does not equal the item on the receiver line.
                                                                       The voucher price does not equal the purchase order price when the unit price percentage and price amount tolerances are
      RULE_P100 Voucher Unit Price <> PO Unit Price (No tolerance)     0.
                                                                       The price percentage tolerance does not equal 0, and the voucher price (converted to the purchase order UOM) does not
      RULE_P400 Voucher Unit Price <> PO Unit Price + % Unit Tol       fall within the purchase order price range (calculated using price percentage tolerance).
                                                                       The unit price tolerance does not equal 0, and the voucher price does not fall within the purchase order price range
      RULE_P500 Voucher Unit Price <> PO Unit Price + Unit Tol         (calculated using unit price tolerance).
                                                                       The Matching process could not find any receipts for the purchase order specified on the voucher line that were available for
      RULE_R500 No receipts found                                      matching (for example not matched, not on hold, and not canceled).

                                                                          The Matching process found receipts for this purchase order that were available for matching (for example not matched, not
      RULE_R600 No receipt found, but unmatched ones exist                on hold, and not cancelled) but could not make an association to the voucher line using any of the receipt aware criteria.
      RULE_R650 Voucher line amt > Sum of received amount                 Voucher line amt > Sum of associated receiver line amt (Amount Only Matching)
      RULE_R651 Voucher line amt > Sum of received amount                 Voucher line amt > Sum of associated receiver line amt (Amount Only Matching)
                                                                          The total quantity received (including across all voucher lines and previously matched receivers) exceeds the accepted
      RULE_R900 Total voucher received quantity > Accepted Qty            quantity on the receiver
                                                                          The total quantity received (including across all voucher lines and previously matched receivers) exceeds the accepted
      RULE_R901 Total voucher received quantity > Accepted Qty            quantity on the receiver
      RULE_R950 Voucher Quantity greater than Assoc. Receipt Qty          The quantity on the voucher line exceeds the remaining unmatched quantity on the associated receipt(s).


      RULE_R951 Voucher Quantity greater than Assoc. Receipt Qty          The quantity on the voucher line exceeds the remaining unmatched quantity on the associated receipt(s). (non-PO Receipt)



                                                                      C:\Docstoc\Working\pdf\e8515097-dc64-4fdd-95d1-7ca36c29a0cd.xls                                                     Page 4
                                                                             State of Wisconsin                                                                           3/26/2008

                                                          Integrated Business Information System (IBIS)
                                                           e8515097-dc64-4fdd-95d1-7ca36c29a0cd.xls

      Rule ID       Description                               Long Description
B = Basic Match Rule Control delivered in PeopleSoft
   S = Suggest using (IBIS Team opinion)
   R = Recommend using (based on DWD model)
                                                              The receiving percentage tolerance does not equal 0, and the total quantity vouchered (including previously matched
      RULE_V200 Life to Date Voucher Qty > PO Qty             vouchers) exceeds the quantity on the purchase order plus the allowed over-receiving quantity
                                                              The extended price tolerance and the extended price percentage tolerance are 0, and the total amount vouchered (including
      RULE_V300 Life to Date Voucher Amount > PO Amount       previously matched vouchers) exceeds the amount on the purchase order.
                                                              The extended price percentage tolerance is not 0, and the total amount vouchered (including amounts on previously
      RULE_V400 Life to Date > Sched Amt + % ext tol          matched vouchers) exceeds the purchase order amount (calculated using extended price percentage tolerance).
                                                              The extended price tolerance is not 0, and the total amount vouchered (including amounts on previously matched vouchers)
      RULE_V500 Life to Date > Sched Amt + ext amt tol        exceeds the purchase order amount (calculated using extended price tolerance




                                                          C:\Docstoc\Working\pdf\e8515097-dc64-4fdd-95d1-7ca36c29a0cd.xls                                                    Page 5

								
To top