A/P Recurring Payables Screen

Sage 300 ERP

Home > Screen Guides > Vendors > Recurring Payables

A/P Recurring Payables Screen

Open Accounts Payable > A/P Vendors >  Recurring Payables.

Click this button if you want to create a manual invoice for a recurring payable.

Example: You might create an invoice manually if you accidentally delete an invoice from a recurring payable batch, or if you need to create an additional invoice for some other reason.

Enter the code for an existing recurring payable, or select it from the Finder.

To define a new record, type the code you want to use using up to 16 characters.

Tip: You can use the same recurring payable code for payables with different vendors, so you can create monthly RENT payables for one vendor, and quarterly RENT for another vendor.

You can specify a range of one or more codes when you create a batch of recurring payables.

Enter the number of the vendor for whom you are creating this recurring payable, or select the vendor from the Finder.

Tip: To see the address for this vendor, click the Zoom Zoom button button beside the field.

If you want to specify a remit-to address to use on invoices for the payable, use the Remit-to field on the Invoice tab.

For each detail you add, enter the amount of the detail in the Amount field, or edit the existing detail amount, if necessary.

The portion of the document total you distribute to details depends on whether tax is included in the price.

You can enter an optional comment with a selected recurring payable detail. For example, you might include a comment indicating that the invoice discount does not apply to a particular detail.

You can enter a comment for a detail in either of the following ways:

  • In the detail table, type a comment for the detail in the Comment column.
  • On the Detail Accounts/Taxes screen, type a comment in the Comment field for the current detail.

    Tip: Using the Detail Accounts/Taxes screen, you can see the entire comment you are entering without having to scroll.

Type a description for the distribution line.

The description from the distribution code record appears as the default description.

You use this option to specify whether a selected detail is subject to the invoice discount. For example, if you do not give discounts on freight charges, you can exempt a freight detail from the invoice discount.

To indicate that a detail is not discountable, you simply clear the Discountable option for the detail on the Detail Accounts/Taxes screen, or select No for the option on the detail-entry table.

A distribution code appears if the vendor record is set up to distribute details by distribution code, or if you used the Create Dist. button to create distributions from a distribution set.

Accept or change the distribution code, as needed.

You can also enter a distribution code if none appears, or leave the field blank, and then enter the general ledger account number.

Type the total amount to distribute to the details created by the distribution set.

This total does not have to be the full amount you need to distribute. For example, after creating distribution details for a distribution set, you may need to add distribution lines for general ledger accounts that are not included in the distribution set.

If you are using a distribution set, enter or accept a distribution set code.

If you are not using a distribution set, leave this field blank, and enter or select the distribution codes or G/L account numbers in the distribution list.

Enter, accept, or change the displayed general ledger account number, as needed.

For invoices that are not job‑related, Accounts Payable displays the account numbers for the distribution codes you specify. However, you can enter the general ledger account codes directly. You can also change the account number for a distribution line on the detail table on the Invoice Entry screen.

For recurring payables, you can change the account number on the Detail tab.

Note:

For job‑related documents, Accounts Payable displays accounts associated with the project or category in Project and Job Costing.

For most projects, the program displays the Work In Progress account for the specified category. For projects using accrual-basis as the accounting method, however, the program displays the Cost Of Sales account.

You can change the account only for:

  • Any time and materials project.
  • Projects that use the accrual-basis accounting method.

This field indicates whether optional fields are assigned to the document detail.

Notes:
  • If any invoice details optional fields are set for automatic insertion, the field is selected when you add a new detail to an invoice, credit note, debit note, or recurring payable.
  • If you use exactly the same optional fields in vendor records and on invoices, the program assigns the optional field values used in the vendor record to transaction details that you add in the Invoice Entry screen and the Recurring Payables setup screen.
  • You can accept or delete the optional fields that appear as defaults, and you can add other optional fields that you have set up for invoice details. You can also change the optional field values used in document details.
  • For job‑related details, if the invoice details optional fields used on an invoice detail are identical to those assigned to the contract project, Accounts Payable uses the optional field values from the contract project as default values for the details.
  • If you assign to a job‑related detail an optional field that is not assigned to the contract project, the program displays the default value for the invoice details optional field.

This field appears only if the vendor is subject to 1099 reporting (for a US vendor), or CPRS reporting (for a Canadian vendor).

Enter the amount of the document that is subject to 1099 or CPRS reporting.

This field appears only if the vendor is subject to 1099 reporting (for a US vendor), or CPRS reporting (for a Canadian vendor). 1099 forms are used in the United States, and CPRS reports are used in Canada.

Select the 1099/CPRS code that matches the type of purchase or payment you are making.

The 1099 codes correspond to the numbered boxes on the 1099 form.

For Canadian vendors, select code 3, Other Income.

The account set from the vendor record appears as the default in this field.

You can change the account set for a particular recurring payable record. If you use multicurrency, however, the new account set must use the same currency as the vendor's account set.

This field displays the vendor's currency when you enter the vendor number in a multicurrency system.

If the recurring payable uses the Maximum Amount expiration type, the program displays the sum of the unposted and posted total invoiced amounts from the Statistics tab.

If the recurring payable uses the Number Of Invoices expiration type, the program displays the sum of the unposted and posted number of invoices from the Statistics tab.

This description appears with the document information on the Invoice Batch Listing and the Invoice Posting Journal.

Specify whether to restrict invoices beyond a specific date, a maximum amount, or a specified number of invoices. Depending on your choice for the expiration type, you enter additional information about the recurring payable, as follows:

  • If you select Specific Date, you also enter an expiration date for the recurring payable. Accounts Payable does not create any invoices for the payable after its expiration date. The program warns you when it creates the final invoice before the recurring payable expires, so that you can update the recurring payable record, if necessary.
  • If you select Maximum Amount, you must also specify the maximum amount for the recurring payable. When you have invoiced the maximum amount, Accounts Payable creates no additional invoices for the payable.
  • If you select Number of Invoices, specify the number of invoices to process for the recurring payable. When the specified number of invoices has been created, Accounts Payable creates no additional invoices.
  • If you select No Expiration, Accounts Payable creates invoices indefinitely for the recurring payable.

You select this option if you want to prevent this payable from being used, but do not want to delete it.

If you select Inactive status, Accounts Payable displays the system date at the time, so that later you can find out when the record was made inactive.

You can reactivate the payable at any time.

Select this option if the recurring payable is for a project you are managing using Sage 300 ERP Project and Job Costing.

When you select the option, additional fields appear in the detail-entry table so that you can enter job‑related information.

When you post invoices generated for the recurring payable, Accounts Payable updates the specified contract, project, category, and (if required) the resource in Project and Job Costing.

This field displays the last date on which an invoice was generated for the recurring payable. You cannot change the date.

This field displays the last date on which a change was made to the recurring payable record.

Accounts Payable updates this field when you generate an invoice using the Create Recurring Payable Batch screen, or when you change the schedule for the recurring payable. You cannot change the date.

Note: The program uses the Last Generated date together with the schedule to determine when the next invoice should be generated.

You can enter a sales order number or other information in this field, or leave the field blank.

Tip: You can list documents by sales order number in Finders and for payment application, and you can use the number as the reference or description in G/L transaction batches.

You can type your company's purchase order number, if any, use the field for another purpose, or leave it blank.

Tip: You can list documents by purchase order number in Finders and when applying payments, and you can use the number as the reference or description in G/L transaction batches.

Specify the code for the kind of rate you want to use when converting non-functional amounts to functional currency. Examples of rate types might be "spot rate," "average rate," and "contract rate."

You must type a valid rate type, or select one from the Finder.

Rate types are defined using the Currency Rate Types screen in Common Services.

If necessary, you can select or enter a different name for the check and a different address to which you will send payment.

You can select a remit-to location that has been defined for the vendor, or use the Zoom Zoom button button beside the field or press F9 to open a separate screen in which you can enter a name and address for the document.

Enter the code for the schedule to assign to the recurring payable record, or select it using the Finder.

To set up a new schedule or modify an existing one, click the Zoom Zoom button button beside the field. You can use up to 15 characters to create a new code.

Note: You must have security authorization to maintain schedules in Common Services to add or modify an existing schedule.

For more information about schedules, see the System Manager help.

Enter the date on which the payable comes into effect.

Accounts Payable will create invoices only when the run date is between the start and expiration dates specified for the recurring payable.

The terms code is used to calculate the due date, discount period, and discount amount for the document.

Notes:
  • The vendor's default terms code appears when you enter the vendor number for the invoice, but you can change to any other terms code that is defined in Accounts Payable.
  • You can specify a terms code that includes multiple payments. For more information, see About Assigning Multiple Payment Schedules to Invoices.
  • You can change the due date, discount date, amount, and rate at any time until you post the invoice.

Any invoice optional fields that are set up for automatic insertion appear, along with their descriptions, as defaults on the Optional Fields tab.

You can add different optional fields, providing they are defined for invoices in the A/P Optional Fields screen. When you select an optional field code, the program displays the description from the optional field setup record.

You can delete optional fields that appear as defaults. However, if an optional field is required, do not delete it. You cannot add the transaction until you enter a value for the optional field.

Default values appear for invoice optional fields, as follows:

  • If you assigned the same optional fields to the vendor and remit-to location records as you defined for invoices, the optional field values for the remit-to location appear on the Optional Fields tab.
  • If the optional fields in the remit-to location record and the vendor record are different from each other, the optional field values from the vendor record appear as defaults for the invoice.
  • If an optional field is defined for invoices, but is not assigned either to the vendor or the remit-to location, the program displays the value specified for the optional field in the Optional Fields record.

You can change the value that appears for an optional field. If the optional field is validated, you must specify a value that is defined for the optional field in Common Services. If the optional field is not validated, you can select a value from Common Services or you can enter another value that is consistent with the type of optional field.

The description for the value appears automatically. You cannot change it.

This field is updated when you post an invoice for the recurring payable.

This field is updated when you post an invoice for the recurring payable.

This field is updated when you post an invoice for the recurring payable. You cannot change it.

This field is updated when you post an invoice for the recurring payable. You cannot change it.

This field is updated when you post an invoice for the recurring payable. You cannot change it.

This field is updated when you post an invoice for the recurring payable. You cannot change it.

This field is updated when you post an invoice for the recurring payable.

If the recurring payable uses Number of Invoices as the expiration type, the program uses this field, together with the [Unposted] Number of Invoices field, to determine if the limit has been reached.

Important! We recommend you change the entry in this field only when upgrading from a prior version. Editing the field does not affect the year-to-date total.

This field is updated when you post an invoice for the recurring payable.

If the recurring payable uses Maximum Amount as the expiration type, the program uses this field, together with the [Unposted] Total Invoiced field, to determine if the limit has been reached.

Important! We recommend you change the entry in this field only when upgrading from a prior version. Editing the field does not affect the year-to-date amount.

Accounts Payable updates this field when you generate or post an invoice for the recurring payable, providing a gauge of the number of open documents generated for the recurring payable code. When you post the invoice, the amount is transferred to the [Posted] Number of Invoices field.

If the recurring payable uses Number of Invoices as the expiration type, the program uses this field, together with the [Posted] Number of Invoices field, to determine if the limit has been reached.

Important! We recommend you change the entry in this field only when upgrading from a prior version.

Accounts Payable updates this field when you generate or post an invoice for the recurring payable, providing a gauge of the amount of open documents generated for the recurring payable code. When you post the invoice, the amount is transferred to the [Posted] Total Invoiced field.

If the recurring payable uses Maximum Amount as the expiration type, the program uses this field, together with the [Posted] Total Invoiced field, to determine if the limit has been reached.

This field is updated when you post an invoice for the recurring payable. You cannot change it.

Accounts Payable clears this field when you process year end.

This field is updated when you post an invoice for the recurring payable. You cannot change it.

Accounts Payable clears this field when you process year end.

Specify one of the following methods for entering tax amounts for the recurring payable:

  • Calculate. Accounts Payable calculates tax amounts for you.

    If you select this tax entry method:

    • You do not enter tax amounts. Accounts Payable calculates them for you.
    • You use the Tax Included column to specify whether taxes are included or excluded in the tax amounts.
    • Check the tax classes. If they are incorrect, use the Finder to select the correct classes.
  • Enter. You manually enter all tax amounts for the recurring payable.

    If you select this tax entry method, enter the total amount of each tax for the recurring payable on the Tax/Totals tab, and then enter the amount of tax for each detail on the Detail Accounts/Taxes screen. (Select a detail on the Detail tab and then press F9, or click the Account/Tax button.)

    Note: The sum of the tax entered for all the details for a tax authority must equal the total amount you enter for the authority on the Tax/Totals tab.

  • Distribute. You enter the total tax amount for each tax authority manually, and Accounts Payable automatically prorates the tax to the details.

    If you select this tax entry method, enter the total amount of each tax for the recurring payable on the Tax/Totals tab.

Note: If a tax does not appear on the Tax/Totals tab, you likely selected the wrong tax group for the document.

The tax group you specify on the Tax/Totals tab of the Recurring Payables screen determines which tax authorities appear on the tab.

Tax authorities are the taxing bodies, such as federal, state, county, provincial, or municipal governments, that levy taxes in the areas where your company buys products.

If your business has a head office and branch offices, different taxes may apply in the different geographical locations.

This is the amount (before included taxes) used as the base for calculating tax for each tax authority.

If you select Calculate, you cannot change the tax base.

If you select Enter or Distribute as the tax entry method for the Tax Base, you can enter the amount on which tax is based for the document.

If you select Calculate as the entry method for the tax amount, and select Distribute or Enter for the tax base, Accounts Payable uses the tax base you enter to calculate the tax amounts automatically.

Enter a tax group. For more information, see About Tax Groups.

Select Yes if taxes charged by the authority are included in the prices for the detail you are entering. The default setting comes from the vendor record.

You can override this setting for single distribution lines on the Detail Accounts/Taxes screen. (Select the detail on the Detail tab, and then click the Account/Tax button.)

The tax class of each tax authority usually indicates a taxable or non-taxable status for your business or the goods you are purchasing.

Tax classes occasionally indicate the tax rate as well. A typical set of classes might be: 1=taxable at rate 1; 2=taxable at rate 2; and 3=non‑taxable. The default tax class comes from the vendor record.

This setting applies to the whole invoice. You can override this setting for single distribution lines on the Detail tab or on the Detail Accounts/Taxes screen.

Overview

Use the A/P Recurring Payables screen to:

  • Create records for standard invoices you receive from your vendors. A recurring payable can be for a single item such as rent, or for a standing order or service that is almost identical from month to month. Recurring payables are identified by code as well as by vendor number, so you can generate a batch of a single invoice type.
  • View statistics for invoices created for the recurring payable.
  • Manually create an invoice for a recurring payable, if necessary.

You can also include recurring payables in the Reminder List, so that System Manager can remind a specific user, or all users, to process the payables when they become due. For more information about reminders, see the System Manager help.

Detail Tab

The Detail distribution tab on the Recurring Payable setup screen lets you:

  • Enter the details of the recurring payable.
  • Open a separate Detail Accounts/Taxes screen to enter distribution and tax information for the detail.
  • To open the detail Accounts/Taxes screen, highlight the detail line, and then click the Acct/Tax button.

  • Lets you view estimated tax amounts for each payable detail (if you selected Calculate or Distribute as the tax entry method for the Tax Amount and Tax Base fields on the Tax/Totals tab).

You assign a distribution code or general ledger payable account, and enter a description and amount for each detail line in the recurring payable record.

Invoice Tab

This tab lets you specify the following information for the recurring payable:

  • The starting date.
  • The expiration type, and, depending on the type you specify:

    • The expiration date, if there is one.

      The Create Recurring Payable Batch screen does not create invoices for payables unless the creation date is between the start date and the expiration date.

    • A maximum amount that you will pay for the recurring payable, if there is a maximum.
    • A maximum number of invoices. (If an invoice would cause the amount invoiced to date to exceed the maximum, Accounts Payable does not create the invoice.)
  • Assign a schedule to set the frequency of payable invoices.
  • Select a remit-to location for the payable, if needed.
  • Assign payment terms and tax information for the payable.
  • Enter a description and the purchase order number, if any.

Optional Fields Tab

Note: This tab appears only if you use Sage 300 ERP Transaction Analysis and Optional Field Creator and you have defined invoice optional fields.

Use the Optional Fields tab to assign optional fields to a document.

Recurring payables use the same optional fields as invoices.

Accounts Payable displays any optional fields set up for automatic insertion on invoices. It also displays default values for the invoice optional fields, as follows:

  • If you assigned exactly the same optional fields to the vendor and remit-to location records as you defined for invoices, the program displays the optional field values from the remit-to location on the Optional Fields tab.
  • If the optional fields in the remit-to location record and the vendor record are different from each other, the optional field values from the vendor record appear as defaults for the invoice.
  • If an optional field is defined for invoices, but is not assigned either to the vendor or the remit-to location, the program displays the value specified for the optional field in the Optional Fields record.

You can change the values that appear, or add other optional fields defined for Accounts Payable invoices. If an optional field is validated, you must specify a value that is defined for the optional field in Common Services. If the optional field is not validated, you can select a value from Common Services or you can enter another value that is consistent with the type of optional field.

Statistics Tab

Use the Statistics tab to:

  • View the number and amount of posted and unposted invoices created for the recurring payable. You can edit these fields to include historical amounts.
  • View the year-to-date number and amount of invoices created for the recurring payable. Accounts Payable updates these amounts when you post the invoices, and you cannot change them.
  • View information about the last invoice posted for the recurring payable, including the date, amount, invoice and entry numbers, as well as the batch number and posting sequence of the batch that contained the last invoice.

Tax/Totals Tab

Tax/Totals tab displays for the recurring payable:

  • The tax group and tax authorities. The tax group assigned in the vendor record appears as the default for the recurring payable, but you can change it, if necessary.
  • The vendor tax class. The vendor tax class is also assigned in the vendor record. However, for many tax authorities, the tax class varies depending on the purpose of the goods or services being purchased. You can change the tax class, if necessary.
  • Estimated tax amounts, if tax is calculated for the recurring payable.

    You specify how tax is to be calculated for the recurring payable using the Tax Amount and Tax Base fields.

  • Whether tax is included in the total for this document.

    You can change the Tax Included option only if the Allow Tax in Price option is selected for the tax authority in Tax Services.

Note: There is no exchange rate information tab on this tab because the exchange rates are unknown for the recurring invoice. The only rate information you enter is the rate type on the Invoice tab.

Related Topics IconRelated Topics