MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Financials > Accounts Payable > Key Concepts and Procedures > Generating Installments > Maintaining Credit Terms

Maintaining Credit Terms

Although credit term definitions are stored on Reference File categories 223 and 247, you may only maintain the definitions through the Credit Terms Maintenance conversation in Accounts Payable.  Credit terms are identified by a two-character code and contain information on discounts, due dates, payment types, and installment payments. 

To maintain credit terms, select the option for Credit Terms Maintenance from the Accounts Payable menu.  The function select screen is displayed for you to enter the two-digit credit terms code that you wish to maintain and the transaction code (add, change, delete, inquire).  The figure below shows a sample of this screen.

WILLIAMS                       COMMON FEATURES                         1/13/93

 DSP01                     CREDIT TERMS MAINTENANCE             FUNCTION SELECT

                                                                               

                                                                               

                                                                               

                                                                               

                                                                               

                           Credit Term          BA                             

                                                                                

                           Transaction Code     A                              

                                                                               

                                                A - Add                        

                                                C - Change                     

                                                D - Delete                     

                                                I - Inquire                    

                                                                               

                                                                               

                                                                               

                                                                               

                                                                               

                                                                                

 F2=Command          F3=Exit             F4=Prompt                             

                                                                               

                                                                               

 

       Credit Terms Maintenance Function Select Screen

 

When you press Enter, the detail screen is displayed with the information defined for the credit term (for change, delete, and inquire) or with default values (for add).  The next figure shows the detail screen for the Credit Terms Maintenance conversation.

WILLIAMS                       COMMON FEATURES                         1/23/93

 DSP01                     CREDIT TERMS MAINTENANCE                      CHANGE

                                                                               

 Credit Term     BA                     Description   5 PMTS DUE ON 15TH       

 Total Number of Installments     5     Net Days/Date            0             

 Discount Percent                 .00   Net End of Month       N               

 Day/Date Qualifier             1       Delay Days              2              

 Discount Days/Date               0     Default Payment Type                   

 Discount End of Month          N       Installment Shift      15              

 From Date of Code              1                                              

                                                                               

 Accumulated Installments         5     100.00        Renumber by:       0     

                                                                               

 Seq    Num Inst    Pmt Type    Days    Percent                                

  10        1          CK        10      50.00                                 

  20        2          CK        10      25.00                                 

  30        2          CA        10      25.00                                 

  40        0                     0        .00                                 

  50        0                     0        .00                                 

  60        0                     0        .00                                 

                                                                               

 F2=Command          F3=Exit             F4=Prompt           F10=Function Select

 F18=Renumber        F22=End Tran                                              

                                                                               

 

                 Credit Terms Maintenance Detail Screen

 

As shown in the above figure, the credit term (BA) contains definitions for five installments (sequence number 10 will generate one installment and sequence numbers 20 and 30 will each generate two installments).  The Installment Shift field in the header portion is used to specify the day of the month on which all installments will be due.

On each detail line you can create a different installment definition by specifying the following information:

·     the number of installments to be generated based on the information on the detail line,

·     the payment type for each installment,

·     the minimum number of days between the due dates of each installment (the due date is calculated based on the value entered in the Installment Shift field and the value entered in this field),

·     the percentage of the total invoice to be paid by all of the installments (this percentage is divided by the number of installments to determine the total for each installment). 

Interpreting the Installment Detail Lines

The first detail line in the Credit Terms Maintenance Detail Screen creates one installment (number of installments) to be paid by check (payment type) with a due date at least 10 days after the invoice is created (number of days).  The installment from line one will be 50% of the total invoice (percent). 

The second detail line creates two installments to be paid by check with a due dates at least 10 days apart.  Each installment from line two will be 12.5% of the total invoice (25% divided by 2 installments = 12.5% each). 

The third detail line also generates two installments with due dates at least 10 days apart and pay a total of 12.5% of the total invoice, but these must be paid in cash.

For example, if you created an invoice on January 1, 1999 for $1,000 with the credit term described above, the following installments would be generated (see the following figure).

Installment Amount


Due Date

Payment
Type


Calculation Method


Calculation Explanation

$500

1/15/99

Check

50% * $1000 = $500

From the first detail line for the payment term, 50% of the total, due at least 10 days after the invoice date on the 15th.

$125

2/15/99

Check

12.5% * $1000 = $125

From the second detail line for the payment term, 12.5% of the total (25% divided by 2 installments), due at least 10 days after previous installment on the 15th.

$125

3/15/99

Check

12.5% * $1000 = $125

From the second detail line for the payment term, 12.5% of the total (25% divided by 2 installments), due at least 10 days after previous installment on 15th.

$125

4/15/99

Cash

12.5% * $1000 = $125

From the third detail line for the payment term, 12.5% of the total (25% divided by 2 installments), due at least 10 days after previous installment on 15th.

$125

5/15/99

Cash

12.5% * $1000 = $125

From the third detail line for the payment term, 12.5% of the total (25% divided by 2 installments), due at least 10 days after previous installment on 15th.

           Installment Calculation Table

 

The Invoice and DR/CR Memo Entry - Installment Detail Screen for an invoice generated using the credit terms discussed above is shown below.

WILLIAMS                       ACCOUNTS PAYABLE                USD     1/23/93

 DSP01                      INVOICE DR/CR MEMO ENTRY                     INSTALL

                                                                               

 Vendor          BCA00001    BCA MANUFACTURING                                 

 Paying Co/Loc   001 BRU     Document    IN  INV000000020                      

 Orig Co/Loc     001 BRU     Doc Date    01 01 99                              

 Credit Terms    BA          5 PMTS DUE ON 15TH                                

 Gross                    1,000.00                                             

                                                                               

 Ins  Installment Amt    Due Date  Pay Date  Pmt Type  Bank Code  Separate Pmt 

 001            500.00   01 15 99  01 17 99     CK        B1           N       

 002            125.00   02 15 99  02 17 99     CK        B1           N       

 003            125.00   03 15 99  03 17 99     CK        B1           N       

 004            125.00   04 15 99  04 17 99     CA        B1           N       

 005            125.00   05 15 99  05 17 99     CA        B1           N       

                                                                               

                                                                               

                                                                               

                                                                                

                                                                               

                                                                               

 F4=Prompt           F7=Header           F12=Comments        F13=Cancel Trans  

                                                                               

                                                                               

 

   Installment Detail Screen

 

Note:    For credit terms with installments, you may not enter values for the following fields on the header portion of the detail screen:  Net Days/Date, Discount Percent, Net End of Month, Day/Date Qualifier, Discount Days/Date, and Discount End of Month.  If you are not defining installments for the credit term, the Total Number of Installments Field must be zero.