About Accounts Payable Optional Fields
About Batch Processing in Accounts Payable
Click this button to recalculate the tax amount after you change the vendor tax class for the invoice.
Click this button to distribute batch details in the detail table of the document tab.
This button appears if you are entering tax reporting amounts manually or distributing tax reporting amounts to invoice details.
After entering the taxes and tax reporting amounts for the tax authorities, click this button to calculate the exchange rate implicit in converting manually entered taxes from the vendor currency to the tax reporting currency.
Click this button to prorate the tax you enter manually to the invoice details.
Note: You cannot prorate a tax amount to an authority that uses an exempt tax class.
When editing an invoice, credit note, or debit note, click this button to save your changes.
You use the batch date as part of your audit trail and to select batches to print on the batch listing and batch status reports. The batch date is also used as the default document date when you create a new document.
Accounts Payable displays the session date as the default batch date when you create a new batch, but you can change it.
To select a date using the calendar, click the calendar icon and specify the desired date, or enter it manually into the field.
Specify the number of an existing batch, or click the Create New Batch button to create a new batch.
Click the Inquiry link to view more information from the specified record.
This field displays the name of the person who entered the transaction.
This field displays a description of the selected batch. If you have created a new batch, use this field to enter a description of up to 60 characters.
This field displays the total for the batch.
This field displays the number of entries in the selected batch.
The account set from the vendor record appears in this field as the default.
You can change the account set for a particular transaction. If you use multicurrency, however, the new account set must use the same currency as the vendor's account set.
For credit notes and debit notes, you can enter the number of the document to which the note applies.
If the note applies to several invoices, or is issued on account (for example, as a purchase volume rebate), you do not enter an invoice number here. You apply the credit note or debit note later, in the Payment Entry screen.
When you select an apply-to document in multicurrency ledgers, you will also see the exchange rate at which the document was posted. You would normally enter the credit note or debit note at the same exchange rate.
This field displays the currency code associated to the specified vendor record.
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.
The document date sets the default due date and discount period, if any, for an invoice. It also sets the aging date from which invoices, credit notes, and debit notes are aged on reports. (You can choose whether to age credit notes and debit notes by document date or treat them as current transactions. Invoices are always aged by date.)
You can also print posting journals by document date.
To select a date using the calendar, click the calendar icon beside the Document Date field.
The document number is the number on the invoice, debit note or credit note you received. You can add standard prefixes to each document (such as INV, NCR, NDR, INT) so they will be grouped on combined listings.
You can use a document number only once for a vendor.
You can also print posting journals by document number.
Enter the total amount of the document, including taxes.
If you know only the amount net of taxes, you can enter that amount, but you must then perform some additional steps. For more information, see Entering an Invoice.
You use the Invoice Entry screen to enter the following kinds of documents: invoices, credit notes, debit notes, and interest invoices.
If you use retainage accounting and you selected the Retainage option for the invoice, you can also enter retainage invoices, retainage credit notes, and retainage debit notes.
You can add all document types to a single batch, or use separate batches for each type.
Accounts Payable assigns an entry number to each new entry you create. An entry number identifies the sequence in which an entry was added to a batch and, along with the batch number, forms part of the audit trail for the transaction.
To select an existing entry for editing or deleting, specify its number in the Entry field. To add a new entry, click the Create New Entry button.
If you delete an entry, you cannot reuse its number.
You can enter a description for the entry in the field to the right. This description appears with the document information on the Invoice Batch Listing and the Invoice Posting Journal.
Select this field if you want to put an invoice, debit note, or credit note on hold. (You can also put specific documents on hold using Control Payments.)
When you post the invoice batch, Accounts Payable does not apply any matching prepayments if either the prepayment or the invoice has an On Hold status. In addition, you cannot post credit notes or debit notes if either the credit (or debit) note or the specified Apply-To document is on hold.
To apply a payment, debit note, or credit note to a document that is on hold when using the Create Payment Batch screen, you must first remove the On Hold status using the Control Payments screen. You can always apply the document manually in Payment Entry, without removing the hold, if you want.
On retainage invoices, debit notes, and credit notes, Accounts Payable sets the On Hold status used on the original document as the default.
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.
This is the term used in Sage 300 to identify the invoice, credit note or debit note from which retainage is taken from.
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 when applying payments, and you can use the number as the reference or description in G/L transaction batches.
Use this field to specify the date that a selected document is posted to General Ledger. The posting date also determines the year and period to which the transaction is posted.
Accounts Payable uses posting dates, rather than document dates, to select open documents for revaluation, so that exchange adjustments are posted to the correct fiscal year and period.
The default posting date that appears can be the document date, the batch date, or the session date, depending on the selection for the Default Posting Date option on the A/P Options screen.
Note: If you consolidate G/L transactions, the posting date for consolidated entries is the last date of the fiscal period.
If necessary, you can select or enter a different name for the check and a different address to which you will send payment.
Click the Inquiry link to view more information from the specified record.
You can also enter a new record in the information screen reached through the Inquiry link.
Select this option if retainage applies to the document you are entering.
After distributing taxes, you should have distributed all document amounts, and the Undistributed Amount field should show zeros.
If the Undistributed Amount field does not show zeros, you have distributed either more or less than the total amount of the invoice, credit note, or debit note.
Identifies the vendor to whose account you will post the document. The vendor number determines the vendor, payment address, the default tax group, the payment terms, and whether the vendor is subject to 1099/CPRS reporting. In multicurrency systems, the vendor number also specifies the currency of the document.
Accounts Payable displays the fiscal year and period to which the document will be posted.
Accounts Payable automatically displays the fiscal year and period that contains the date you enter in the Posting Date field. You cannot change this field except by changing the posting date.
This field displays the description of the specified G/L account.
If you use Distribute or Enter as the tax entry method, use the Distribute Tax button to distribute to the distribution lines the taxes you enter on the Taxes tab. If you use Enter as the tax entry method, you can edit the Allocated Tax column to redistribute the tax, if necessary.
If you select Calculate as the tax entry method, you cannot directly edit tax amounts for distribution lines, but you can change tax classes. To change the tax class for a distribution line, click the Line Number field, then click the Edit icon and make the changes in the screen that appears.
If you select Calculate or distribute as the tax entry method, you must distribute all of the invoice amounts before you use the Distribute Taxes button to calculate and distribute tax amounts.
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.
Accounts Payable lets you enter a comment with each detail on an invoice, credit note, or debit note. For example, you might include a comment indicating that the invoice discount does not apply to a particular detail.
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 Distribution 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.
The amount calculated for the detail line, before tax is added.
Enter, accept, or change the displayed general ledger account number, as needed.
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.
This is the total amount—purchases and tax—that is being distributed to the general ledger account specified by this distribution line.
If tax was included in the distribution amount, this column indicates the amount of tax that was included.
This field indicates whether optional fields are assigned to the document detail.
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.
A description of the optional field is displayed in the Optional Field Description column.
Default values appear for invoice optional fields, as follows:
The description for the value appears automatically in the Value Description field. You cannot change it.
If an optional field is a required field, it must contain a value before you can save an entry.
The Value Set field indicates Yes if Accounts Payable has already set a value—including an acceptable blank—for the field.
You use the Rates tab to change the rate type, rate date, and exchange rate for an entry that is not in the functional currency. You cannot change the currency type.
The vendor's currency code and the exchange rate appear when you enter the vendor number in a multicurrency system.
If you need to change the tax group for a multicurrency vendor, you must select another tax group that also uses the vendor's currency.
This is the exchange rate currently in effect for the specified currency and the displayed rate type and rate date. You can change the rate, if necessary.
Accounts Payable uses the Currency Rates tables to select a rate that matches the rate type and date.
Enter a rate date. This is the date you want to use for selecting the currency exchange rate.
Tip: You maintain exchange rates by date in the Sage 300 Currency screens. If you update exchange rates daily, the rate date will provide the rate in effect on the date you specify.
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 specify a valid rate type, as defined using the A/P Currency Rate Types screen.
The program uses the retainage percentage to calculate the retainage amount.
You can enter a different retainage percentage in the Retainage Percentage (%) field. When you enter a new percentage, the program recalculates the retainage amount.
To calculate the retainage amount, the program multiples the document amount (or the document total, if you include taxes in retainage) by the retainage percentage. You can enter a new retainage amount, if necessary. When you enter an amount to replace a calculated amount, the program recalculates the retainage percentage.
The retainage amount is subtracted from the document amount (or the document total) to calculate the amount due.
Specify the method the program will use to determine the exchange rate for the retainage document when you eventually process it:
You can use different terms for retainage documents (used to invoice for outstanding retainage) than you used for the original document from which the retainage was taken.
The program displays the code specified for retainage terms in the vendor record, but you can change the retainage terms for a document, if you want.
A description of the selected terms code displays in the Terms Code Description field.
This field appears in the Tax Reporting Currency Rate section on the Taxes tab if the tax group you specified for the document is different from the vendor's currency.
The program displays the currency code for the tax group, and you cannot change it.
Accounts Payable uses this exchange rate to calculate the tax reporting amount in the tax reporting currency.
The program displays the exchange rate specified for the tax reporting currency, rate type, and rate date, but you can change the rate.
Enter a rate date. This is the date you want to use for selecting the currency exchange rate.
Tip: You maintain exchange rates by date in the Sage 300 Currency screens. If you update exchange rates daily, the rate date will provide the rate in effect on the date you specify.
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 specify a valid rate type, as defined using the A/P Currency Rate Types screen.
If you selected Enter as the tax entry method, enter the amount of each tax that is listed on the invoice. If a tax does not appear on the tab, you likely selected the wrong tax group for the document.
If you selected Calculate as the entry method for the tax amount and Distribute or Enter for the tax base, the program uses the tax base you enter to calculate the tax amount automatically.
The tax group you specify on the Taxes tab of the A/P Invoice Entry screen determines which tax authorities appear.
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 to calculate tax for the tax authority.
Note: On original documents to which retainage applies, if the tax on retainage will be reported when you post the retainage document, this is the amount before tax (or the cost, depending on the tax authority) less retainage.
If you select Calculate for the tax base, you cannot change the amount that appears in the Tax Base field.
If you select Enter or Distribute for the tax base, you can enter the amount on which tax is based for the document.
If you select Calculate for the tax amount and Distribute or Enter for the tax base, the program 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 on the invoice you are entering. The default setting comes from the vendor record.
This setting applies to the whole invoice. You can override this setting for single distribution lines on the Document tab.
This field appears only if the tax group you specify for the invoice does not use the vendor currency.
You can select:
The sum of the detail amounts must equal the totals you enter for each tax authority. However, you do not need to enter tax amounts manually for the details. You can enter the total tax amounts for the document, and then click the Distribute Taxes button to distribute the total tax amounts to the details.
You can also click the Derive Rate button to compute the exchange rate used to convert manually entered tax amounts to the tax reporting currency.
You can also click the Derive Rate button to compute the exchange rate used to convert manually entered tax amounts to the tax reporting currency.
This field appears only if the currency for the tax group specified for the document is different from the vendor's currency.
This field shows the tax amount converted to the tax reporting currency specified for the tax authority (in Tax Services).
This field appears only if the tax group uses a different currency than the vendor currency.
It shows the amount of tax to be reported on tax tracking reports for all the tax authorities listed on the invoice.
This is the total tax amount for the document, including recoverable or separately allocated tax.
If you selected Enter or Distribute as the tax entry method for the tax amount, this field displays the total amount of taxes that you entered on the Taxes tab.
If you selected Calculate and clicked the Calculate Taxes button, this field shows the tax amount calculated by Accounts Payable.
This is the amount due for the particular payment. The amount for each payment is calculated from the percentage that is specified in the terms code. You can change payment amounts as needed, but the total of all payments in a schedule must equal the invoice total.
The As Of Date is the date from which the terms are calculated. Accounts Payable automatically displays the document date, but you can type another date.
For example, if the first payment is not due for six months (so you would consider the first invoice date as six months from today), you would add six months to the As of Date to recalculate the schedule dates.
This is the amount of the discount you can take if payment is made by the discount date. While the discount period is in effect, the discount amount is displayed for the payment when you are applying payments to the invoice (in Payment Entry).
This field displays the document amount as the default, but you can change it.
The program multiples the discount base by the discount percentage to determine the discount amount.
This is the date by which payment must be made to qualify for the early payment discount. The dates are calculated only if the terms code includes discount information, but you can enter discounts in an individual multiple payment schedule, if you want.
This is the percentage amount of any discount that is permitted by the terms code assigned to an invoice. If the invoice includes a multiple payment schedule, a separate discount percentage is assigned for each payment. You can change the discount percentages at any time until you post the invoice.
This is the due date for the particular payment. It is used to age outstanding payments on Overdue Payables and Aged Cash Requirements reports. You can change due dates at any time until you post the invoice.
Each of the payments in a multiple payment schedule is assigned a number. You specify the payment number when applying payments or entering adjustments to an invoice with a multiple payment schedule.
The terms code is used to calculate the due date, discount period, and discount amount for the document.
If you selected Distribute or Enter as the tax entry method, click the Distribute Tax button to distribute to the distribution lines the taxes you enter on the Taxes tab. If you use Enter as the tax entry method, you can also edit the Allocated Tax column to redistribute the tax, if necessary.
If you select Calculate as the tax entry method, you cannot directly edit tax amounts for distribution lines, but you can change tax classes. To change the tax class for a distribution line, highlight the line, click the Edit icon and then make the changes in the screen that appears.
If you select Calculate or Distribute as the tax entry method, you must distribute all of the invoice amounts before you use the Distribute Taxes button to calculate and distribute tax amounts.
This field shows the early payment discount calculated for this invoice, based on the information entered on the Terms tab. This amount is subtracted from the Document Total in calculating the Net Payable amount.
If the terms code for the invoice includes a multiple payment schedule, Accounts Payable displays the sum of the early payment discounts available.
This field displays the total amount of the document, including prepayment and discount amounts.
This field shows the amount of the invoice that has been prepaid. This amount is subtracted from the Document Total in calculating the Net Payable amount.
The program displays the amount payable on the invoice, less any discount. This amount does not change when you add a prepayment.
This field shows the amount of tax that you can recover from the tax authority. It is not expensed, but is assigned to the tax recoverable account you specified for the tax authority in Tax Services.
This field shows the amount of any tax that you expense separately. Accounts Payable assigns it to the separate tax expense account you specified for the tax authority in Tax Services.
This field shows the total amount of taxes for the invoice. This amount is subtracted from the Total Distribution Net Of Tax in calculating the Document Total.
This field shows the sum of the invoice details, before taxes.
This field shows the total tax amount for the document, including recoverable or separately allocated tax.
If you selected Enter or Distribute as the entry method for the tax amount, this field displays the total amount of taxes that you entered on the Taxes tab.
If you selected Calculate and clicked the Calculate Taxes button, this field shows the tax amount calculated by Accounts Payable.
After distributing taxes, you should have distributed all document amounts, and the Undistributed Amount field should show zeros.
If the Undistributed Amount field does not show zeros, you have distributed either more or less than the total amount of the invoice, credit note, or debit note.
Use the A/P Invoice Entry screen to:
Use this tab to:
Note: This tab appears only if you have defined optional fields for Accounts Payable invoices.
Use this tab to:
Accounts Payable displays the optional fields that you set up for automatic insertion on invoices, but you can change them or add other optional fields defined for Accounts Payable invoices.
Default values appear for optional fields, as follows:
Automatically inserted invoice optional fields appear on the Invoice Entry Optional Fields tab when you add new documents.
Automatically inserted invoice details optional fields are associated with each detail line. The Optional Fields indicator field on the detail table shows whether optional fields are used with a particular detail.
To add, edit, or delete invoice detail optional fields, select the detail, then click the Optional Field to open a separate Optional Fields screen that lets you change the optional field information for the detail.
If an optional field uses validation, you can select only entries that are defined for the optional field.
For more information about entering invoice detail optional fields on invoices, see About Entering Optional Fields on Invoices.
Note: This tab appears only if you use multicurrency accounting, and you are entering a document for a vendor that does not use the functional currency.
Use this tab to change the rate type, rate date, and exchange rate for converting the document amount from the vendor's currency to the functional currency.
Note: This tab appears if you select the Retainage option on the Document tab.
Use this tab to specify how to process retainage for this invoice, debit note, or credit note.
The program displays the retainage percentage, retainage rate, and the retainage terms from the vendor record. You can change these retainage factors for a particular document.
Accounts Payable calculates and displays the retainage amount and retainage due date for the selected document.
Use this tab to:
Use this tab to:
A payment schedule is created only if the invoice terms code uses the Multiple Payment Schedule option.
Use this tab to see the amount of recoverable tax, separately expensed tax, and allocated tax, and to see why an invoice has an undistributed amount.
The Totals tab displays the total tax amount on the invoice for each taxing authority, as well as current totals for the document in two summaries: an invoice summary and a tax summary.
The tax authority record in Tax Services specifies whether a particular tax is recoverable or expensed separately. For example, the GST in Canada and VAT in many other countries are recoverable taxes and are not distributed with invoice totals.
When you click the Distribute Taxes button, Accounts Payable: