MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Financials > Accounts Payable > Key Concepts and Procedures > Three-Way Matching > Setting Up Your Matching Environment

Setting Up Your Matching Environment

For matching to occur, you must define the Accrued Purchase Receipts account as both a statistical and financial account.  If the account is set up as a financial account only, an error message will be displayed when you request matching.

In order to perform automatic matching, you must define a record on Reference File category D39 (A/P Match Information) for each company/location in which automatic matching will be performed.  If you do not define a record on D39, a manual matching environment will be defaulted for the company/location.

On category D39, you must define whether automatic matching is allowed in the invoice entry and maintenance conversations, the quantity and amount tolerance limits for a successful match, and the processing to be performed if a tolerance is exceeded during matching (either a warning or placing the invoice on hold for review).  For example, if you have a receipt for 100 items and an invoice for 10 items and you match the invoice to the receipt for 10 items, you will not generate a variance (since 90 are left on the receipt to match to another invoice); however, you will probably exceed the tolerance and cause the invoice to be put on hold.  In order to exceed the tolerance you must exceed the tolerance percent you set up on category D39.  A sample screen for category D39 is shown in the following figure.

 WILLIAMS                       COMMON FEATURES                         6/05/97

 DSP01                    REFERENCE FILE CATEGORY D39                   INQUIRE

                                                                               

                   Category Name          AP MATCH INFORMATION                 

                                                                               

                                        CO(3) LOC(3)                           

                   Category Key         001BRU                                 

                                                                               

                                                                               

            WARNING/CRITICAL         AUTO MATCH - ENTRY                         

       Data        W                       N                                   

                   X                       Y                                   

                                                                               

            AUTO MATCH - MAINT       QTY TOLERANCE %    AMT TOLERANCE %        

       Data        N                       000               000               

                   Y                       NND               NND               

                                                                                

            TOLERANCE PROCESS        MATCH QC RECEIPTS     QC PROCESS          

       Data        H                       Y                   B               

                   X                       Y                   X               

                                                                               

 F2=Command          F3=Exit             F9=Inquiry          F10=Function Select

                                                                                

         Screen Sample for Category D39

 

Note:    If you set either of the automatic match flags (Auto Match - Entry or Auto Match - Maint) to Y, you may only perform automatic matching in that conversation, manual matching will not be available.

In addition, you will need to set the Match flag on Reference File category 200.  A sample of Reference File category 200 is shown in the following figure.  If you do not use management accounting, set the Match flag to "AP."  If you do use management accounting, review the "Accrual and Matching in a Management Accounting" key concept in this manual.

WILLIAMS                            COMMON FEATURES                     2/15/96

 DSP01                        REFERENCE FILE CATEGORY 200               INQUIRE

                                                                               

                   Category Name           AP SYSTEM DEFAULTS                  

                                                                                

                                        BLANK KEY                              

                   Category Key                                                

                                                                               

                                                                               

            NET/GROSS   REQUIRE AUTH   INT DOC PROCESSING   MATCH              

       Data     G            N                I              AP                

                X            Y                X              XX                

                                                                               

            INVOICE   DEBIT MEMO   CREDIT MEMO  LAST MAINT DATE                

       Data   IN          DR            CR            Y                        

              XX          XX            XX            Y                        

                                                                               

            CTL FISCAL NUM   DRAFT PROC   DSP OPEN ITEMS ONLY   DSP INST       

       Data       B              Y                N                Y           

                  X              Y                Y                Y           

                                                                               

 F2=Command          F3=Exit             F9=Inquiry          F10=Function Select

         Screen Sample for Reference File Category 200