A/P Payment Entry Screen
About Creating Payment Batches Automatically
About Entering Optional Fields on Payments
About Entering Prepayments Using the Payment Entry Screen
If the option to allow adjustments in payment batches is selected on the A/P Options screen, you can click this button to adjust a payment. For more information, see Writing Off Small Differences During Payment Entry.
Click this button to clear the A/P Payment Entry form in order to create a new payment batch.
Click this button to clear the A/P Payment Entry form in order to create a new payment entry.
Click this button to delete the entry that is currently displayed in the Payment Entry screen.
Note: If you delete a payment for which the check has already been printed, Accounts Payable voids the check.
Click this button to view the history of an invoice, credit note, or debit note while applying a payment or credit note. For more information, see Viewing Document History when Applying a Payment or a Credit Note.
Click this button to apply payments to job‑related invoices. For more information, see A/P Project and Job Costing Apply Details Screen.
Click this button to print checks for the payment batch that is currently displayed, and then post the batch.
For information about posting multiple batches, see Posting a Range of Batches.
Click this button to print a check for a payment. For more information, see Printing a Single Check When You Pay a Vendor.
Click this button to view and edit currency and exchange rates.
If you select the Filter Documents option, you specify (in the Document Type, Order By, and Starting fields) how to filter documents in the table. After specifying how to filter documents, click the Refresh button to refresh the information shown in the table.
If you edit a payment you applied previously, click this button to record your changes.
Click this button to open the Tax Withheld screen, where you can view the total tax withheld for invoices in the entry.
This button appears only if you select Payment or Apply Document in the Transaction Type field.
Click this button to void a check. For more information, see Voiding a Printed Check.
The vendor's account set appears as the default in this field, but you can change the account set to another one that uses the vendor's currency.
Note: You cannot specify an account set for apply transactions, for miscellaneous payments that have no vendor number, or for adjustments you make in Payment Entry.
This field is available if you select Prepayment as the transaction type.
Enter the date on which you want the payment activated. This is the date from which they are included when calculating amounts due for payment.
Prepayments are not used to calculate account balances or amounts due to vendors (when you use the Create Payment Batch screen) until they reach their Activation dates.
This field is available if you selected Payment as the transaction type.
You use it to record a credit for goods that you have returned, for which the vendor has not yet sent you a credit note. For more information, see Entering an Advance Credit for Goods You Return.
The invoice to which advance credit is applied will appear as if it is fully paid. However, because the advance "credit" is actually a separately numbered debit document, it reflects the true unpaid balance in the vendor account, until you record the "real" credit note.
This field is available if you select Prepayment as the transaction type.
Select how you want to identify the document for which you are entering the prepayment.
You can identify it by its document (invoice) number, by the sales order number, or by the purchase order number. An additional field appears if you choose to apply by purchase order, listing all the existing POs posted for the vendor.
Specify a default method for allocating partial payments to details on job‑related invoices that use different contracts, projects, and categories:
- Top Down. Select this method to apply payments automatically to invoice details, beginning with the first detail on an invoice, until the payment is fully applied.
Note: If you use this method to apply a payment to an invoice that uses a multiple payment schedule, you may have to adjust the amounts manually. For invoices that use a multiple payment schedule, it is preferable to prorate the payment by amount.
- Prorate By Amount. Select this method to apply payments proportionately to all invoice details, depending on their relative amounts.
Enter the invoice number, PO number, or sales order number for the invoice you are prepaying (depending on your choice for Document Type). This number is used to identify the invoice to which you are applying the prepayment.
Specify the bank on which you are writing the checks for the batch.
Initially, this field displays the default bank code specified on the Transactions tab of the A/P Options screen, but you can change it.
- You must specify a default bank code on the A/P Options screen before you can enter and save information and transactions in payment batches.
- You define bank codes for your company in Bank Services.
- If you are starting a multicurrency batch, you also specify the currency for the batch and the rate at which to convert amounts in the batch to the functional (home) currency.
- You can use only one bank and one currency per batch. The bank you select must be set up to accept the currency you want to use for the batch.
This is usually the date on which the batch was created.
The program uses the batch date as the default document date for new documents you add to the batch.
Accounts Payable displays the session date as the default batch date when you create a new batch. You can type a different date in the field, or select a date using the calendar. (Click the button beside the Batch Date field to display the calendar.)
You can change the batch date any time before you post the batch, provided the Ready To Post option is not selected for the batch.
Once the batch is posted, the batch date becomes part of your audit trail. You use it to select batches to print on the batch listing and batch status reports.
Enter the number of an existing batch, or click the Create New Batch button to create a new batch. In the field to the right, enter a description for the batch.
Tip: Click the Details link to view more information from the record.
This display-only field lists the total number of entries and the total amount of the selected batch.
This field appears only in multicurrency ledgers.
Specify the currency code to use for the batch. You can pay vendors in any currency, but all the transactions you enter in a single payment batch must be in the same currency.
You can change exchange rate details for a batch. For more information, see A/P Batch Information Screen (Payment Entry).
Accounts Payable assigns a document number for payment, miscellaneous payment, and prepayment transactions.
The assigned number uses the prefix and next sequence number specified on the Numbering tab of the A/P Options screen, and you cannot edit the document field.
For Apply Document transactions, you enter the document number of the prepayment or credit note you want to apply in this field.
If you select the Filter Documents option, use this field to specify the type of documents you want to choose from when applying payments.
After specifying information in this field, click the Refresh button to refresh the information shown in the table.
This field displays the name of the person who entered the transaction.
To create a new entry, click the Create New Entry button.
To work with an existing entry, specify its number in the Entry Number field.
The entry number identifies the payment entry on batch listings and posting journals. You can also include this number in transactions you send to the general ledger (if you do not consolidate transactions).
Entry numbers are assigned sequentially by the program.
Enter additional information to include with a transaction (for example, an EFT transaction number).
Note: This field appears for payments, prepayments, miscellaneous payments, and apply document transactions.
Select this option to enable the ability to list documents in the table at the bottom of the screen by type, order, and starting date. If you select the Filter Documents option, the table shows more information about the vendor's documents, including information from any unposted payments that you have already applied.
It is faster to enter a document number directly if you have a lot of vendor documents, or if you know the number of the document to which you are applying the invoice, prepayment, or credit note.
Select this option if you are adding a prepayment or a miscellaneous payment for a contract you administer using Sage 300 Project and Job Costing.
If you are entering a miscellaneous payment, the program replaces the columns in the payment application table with job‑related columns that let you identify a specific contract, project, category, and resource from Project and Job Costing for which you are making this payment.
If you are entering a prepayment, click the Jobs button to open a separate Project and Job Costing Application Details screen that lets you identify the contract, project, category, and resource.
The Optional Fields check box indicates whether optional fields are assigned to the currently selected payment. If you marked any payment optional fields for automatic insertion, the field is selected when you add a new payment entry.
For more information, see Changing Optional Fields.
If you select the Filter Documents option when applying payments, use this field to specify the order by which to list the vendor's documents.
The default order for this field is set in the Default Order of Open Documents field on the A/P Options screen.
After specifying information in this field, click the Refresh button to refresh the information shown in the table.
When you order by Due Date, the list begins with the document with the earliest (oldest) due date. If you enter a starting due date in the Starting field, the list omits any documents with earlier due dates.
When you order by Order Number, all the documents issued with a particular sales order number are displayed together, beginning with the lowest sales order number or the sales order number you specify in the Starting field.
When you order by PO Number, all the documents issued with a particular purchase order number are displayed together, beginning with the lowest purchase order number or the purchase order number you specify in the Starting field.
This field appears if you specify a Payment Code that has a payment type of Other.
Use this field to specify the alternate account code. A description of the specified account is displayed in the Other Account Description field.
Accounts Payable displays the amount of the payment transaction in the bank currency, letting you quickly identify payments and check amounts when reviewing or editing entries.
Accounts Payable uses this date to:
- Assign the payment to aging periods on reports.
- Calculate any payment discount.
- Report the number of days to pay.
If you are recording a check that you have already issued, enter the date from the check.
If you are printing a check from Accounts Payable, this is the date that will appear on the check when you print it.
If you are entering an Apply Document transaction, the Payment Date field is not available. Accounts Payable assigns the date of the document being applied.
This date appears as the Document Date in the Vendor Activity screen and on reports that include payments and apply document transactions.
You can enter the following types of transactions:
- Payment. Select this type to record a check to pay outstanding transactions. You can print the check from Payment Entry or enter the number of a previously written check.
- Prepayment. Select this type to record a check written as a prepayment. You can print the check from Payment Entry or enter the number of a previously written check.
Prepayments pay for a purchase before you are invoiced for it. When you enter and post the invoice, Accounts Payable automatically applies the prepayment.
- Apply Document. Select this type to apply a posted prepayment or credit note against an invoice, debit note, or interest charge.
- Miscellaneous Payment. Select this type to issue a check to a person or company for which you have not set up a vendor record. You enter the distribution details of the purchase in the same way as you enter them for an invoice.
The posting date is used to record the date the document was applied to another transaction and when it is actually posted to General Ledger. It does not affect the determination of the discount or the days to pay statistics.
The field to the right displays the fiscal year and period to which the transaction will be posted. You cannot change this field except by changing the posting date.
- The default posting date that appears depends on your selection for the Default Posting Date option on the A/P Options screen.
- If you consolidate G/L transactions, the posting date for consolidated entries is the last date of the fiscal period.
Enter an optional reference for the distribution.
This reference appears with the distribution in the General Ledger batch, if the Posting Sequence-Batch option is selected for the G/L Detail Reference field on the G/L Integration screen, and you do not consolidate general ledger transactions during posting.
This field changes based on what you select in the Order By field. For example:
- If you select Document Number in the Order By field, the "starting" field is named Starting Document Number and you can enter any text consistent with document numbers.
- If you select Due Date in the Order By field, the "starting" field is named Starting Due Date and you must enter information in date format. Also, a calender is available that you can use to select a date.
Enter the number, amount, or date of the first record you want to see in the list of the vendor's open documents. Leave the field blank to start with the first outstanding document.
After specifying information in this field, click the Refresh button to refresh the information shown in the table.
Tax groups specify the authorities that tax the vendor and assign the vendor's tax classes in each authority. (Tax classes determine the specific classification for a tax, such as which rate is applied or whether the vendor is exempt.)
The vendor's tax group appears in the field when you enter the vendor number. You can assign a different tax group, or you can change the tax information for the document on the Document Totals screen. You can also change the detail tax class or tax included status for any of the detail lines you enter with the document.
To change the tax rates for a tax authority, however, you must use the Tax Services screens.
In multicurrency ledgers, if you change the tax group to one that uses a different currency than the vendor, you can choose whether to let the program calculate the tax reporting amount, and you can change the tax type, rate date, and exchange rate for the tax reporting currency.
The program displays the total tax calculated or entered for all the details and tax authorities used on the document.
This field shows how much of the selected prepayment or credit note has not yet been applied to the vendor's account in the detail entry table. Use it to check that you have applied as much of the prepayment or credit note as you intended.
Note: If you have a multicurrency ledger, the unapplied amount is in the vendor's currency—as are the invoices to which you are applying the prepayment or credit note. The exchange rate in effect is the rate that you entered with the prepayment or credit note. You cannot change it at this time.
The field shows the amount you have applied using the table on the Payment Entry screen, unless you are entering a prepayment.
In multicurrency ledgers, the payment amount is converted from the vendor currency to the bank currency using the exchange rate information on the Rate Override screen. To change the exchange information for a selected payment, open the Rate Override screen by clicking the Rates button at the bottom of the Payment Entry screen.
If you are entering a prepayment, you use this field to type the amount you are prepaying. If you have a multicurrency ledger, enter the amount in the vendor currency—not in the bank currency. The amount is converted to the bank currency for the check amount, using the rates shown on the Rate Override screen.
Use this field to specify the account to which to post the payment.
If you selected Cash as the payment type, use this field to select the necessary cash account code.
This is the language for printing the amount of the check in words only. All other text on the check or advice comes from the check report screen.
If you are recording a manual check that you issued earlier, enter the check number in this field.
If you are printing the check from Accounts Payable, you do not enter a number. Bank Services assigns the check number when you print the check.
Check numbers must be unique for each bank.
The payment code specified in the vendor record appears as the default in this field. (If none exists in the vendor record, Accounts Payable displays the default payment code specified on the A/P Options screen.)
You can change the code if you want to use a different method of payment for this entry.
If you select a code that uses a Cash payment type, enter the cash account from which to disburse the payment. If you do not enter a cash account, Accounts Payable credits the bank account.
If you select a code that uses a Check payment type, fill in the following fields:
- Print Check.
- Check Number (if recording a manually written check; you cannot enter a number if you selected Print Check).
- Check Language (for printing the amount only; edit the check form to change other aspects of the check).
Select this option if you want to print the check using the Accounts Payable program.
If you are recording a manual check you have already issued, do not select this option. You must enter the number of the manual check in the Check Number field. (If Accounts Payable prints the check, it assigns the check number when you print the check.)
Accounts Payable treats a check with a number as printed once you save it. This means that you cannot edit the check later unless you zero the Check Number field and select the Print Check option.
This field displays the description of the selected remit-to location.
This is the person or company name that will appear on the check.
You can enter another name or select a remit-to location (if the vendor has alternative payment addresses).
Click Details on the menu beside the field to view or change the remit-to information.
This column displays the amount of an adjustment you entered to the document in this payment batch. You cannot change the amount in this column.
You can enter adjustments in payment batches if the option to allow adjustments in payment batches is selected on the A/P Options screen.
After saving the transaction, you adjust the document by highlighting the line to which you are applying the payment, and then clicking the Adjust button
Type the amount you want to apply to the selected document.
Accounts Payable automatically applies the full outstanding amount when you select the document, but you can change the amount.
You cannot enter an amount that is greater than a document's outstanding or pending balance.
If you are applying a prepayment or credit note, you cannot apply an amount that is greater than the total for the document you are applying.
Use the Apply column to select documents to which to apply the payment, prepayment, or credit note.
Select Yes for each document you want to pay.
If another transaction has been applied to the document in another unposted batch or entry, you see Pending in the Apply column.
This column displays the current balance in the document in the vendor's account. The amount is calculated from the transactions that have been posted to the account, and does not include pending (unposted) transactions.
Enter an optional description for the distribution.
This description appears with the distribution in the General Ledger batch, if the Posting Sequence-Batch for the G/L Description Field option is selected on the G/L Integration screen and you do not consolidate general ledger transactions during posting.
This column shows the amount of the discount that is available for the document, if any. You cannot change this amount and you cannot enter a larger discount amount in the Discount Taken field.
You can change discount amounts using the Control Payments screen.
This column lists the discount dates that were assigned to the documents when they were posted to Accounts Payable. If no discount applied to the document, the discount date is the same as the document date.
When you choose to list documents by their discount dates, the list begins with the document with the earliest (oldest) discount date. If you enter a starting discount date in the Starting field, the list omits any documents with earlier discount dates.
Use this column to enter the amount of any discount that applies to the document.
You can take a discount on a document, even if the applied amount is zero.
If the discount period has expired, this field will show zeros.
You can change discount amounts using the Control Payments screen.
If the vendor record is set up to create document details by distribution code, the distribution code from the vendor record appears as the default in this field. You can change the distribution code.
If no distribution code appears, you can skip this field, and enter a general ledger account number instead.
The Document Date column lists the dates that were entered with the documents.
When you choose to list documents by their document dates, the list begins with the document with the earliest (oldest) date. If you enter a starting document date in the Starting field, the list omits any documents with earlier dates.
The Document Number column shows the numbers of outstanding documents that you can pay at this time, or to which you can apply a prepayment or a credit note.
This column lists the due dates (or when applying prepayments, the activation dates) that were assigned to the documents when they were entered into Accounts Payable.
If the vendor record is set up to create document details by general ledger account, the account number from the vendor record appears as the default in this field.
If the vendor record specifies a distribution code, the general ledger account for the specified distribution code appears as the default.
You can change the general ledger account.
Enter the vendor's invoice number.
This field appears if you use Sage 300 Project and Job Costing.
The field indicates whether a document is job‑related or not. (The program sets the entry in this field; you cannot change it.)
When you apply a payment to a job‑related document, the Jobs button becomes available, letting you open the Project and Job Costing Apply Details screen where you can change the apply method or the allocations for particular document details.
This column displays the document balance net of the current unposted applied amount, adjustment, and/or discount.
This column displays the sales order number, if any, that was entered with the document.
This column displays the original document total.
This column displays the payment number for the corresponding document. This payment number is 1 unless the document contains a multiple payment schedule, then it is the number for the particular payment.
This column displays the total amount of unposted adjustments that have been entered for the document in any other unposted entries or payment batches.
This column displays the total amount of discounts taken for the document in other unposted entries in payment batches.
This column displays the total of any payments that have been applied to the document in other unposted batches or entries.
The pending balance shown for a document is the amount that the document balance would be if all pending transactions were posted to it. You cannot edit this field. You can change the pending balance only by changing the pending amounts that have been applied to the document.
You cannot apply an amount to a document that is greater than its pending balance.
This column displays the purchase order number, if any, that was entered with the document.
Tax groups specify the authorities that tax the vendor and assign the vendor's tax classes in each authority. (Tax classes determine the specific classification for a tax, such as which rate is applied or whether the vendor is exempt.)
The vendor's tax group appears in the field when you enter the vendor number. You can assign a different tax group, or you can change the tax information for the document on the Document Totals screen. You can also change the detail tax class or tax included status for any of the detail lines you enter with the document.
To change the tax rates for a tax authority, however, you must use the Tax Services screens.
In multicurrency ledgers, if you change the tax group to one that uses a different currency than the vendor, you can choose whether to let the program calculate the tax reporting amount, and you can change the tax type, rate date, and exchange rate for the tax reporting currency.
The amount that you have withheld for an invoice to be remitted to tax authorities on behalf of the vendor.
Double-click this field to open the Detail Tax Withheld screen, where you can view the tax withheld for each tax authority for the invoice.
This field shows a value for an invoice only if the Apply field is set to Yes for the invoice.
This field displays the total tax calculated or entered for all the details and tax authorities used on the document.
- A/P Batch Information Screen (Payment Entry)
- A/P Detail Taxes Screen (Miscellaneous Payments)
- A/P Detail Tax Withheld Screen
- A/P Document History Screen
- A/P Document Tax Screen
- A/P Miscellaneous Adjustment Entry Screen
- A/P Project and Job Costing Apply Details Screen
- A/P Rate Override Screen
- A/P Remit-To Location Information Screen (Payment Entry)
- A/P Tax Withheld Screen
- Adding a Payment Batch
- Applying a Payment or Credit Note to a Job‑Related Invoice
- Applying a Posted Prepayment or a Credit Note
- Applying Prepayments and Credit Notes Using the Payment Entry Screen
- Applying a Payment
- Displaying an Existing Payment to Apply or Edit
- Distributing Miscellaneous Payment Details
- Entering a Cash Invoice or Miscellaneous Payment
- Entering an Advance Credit for Goods You Return
- Entering and Applying a Payment
- Partially Paying a Job‑Related Document
- Prepaying a Vendor
- Printing a Single Check When You Pay a Vendor
- Printing Checks for a Batch of Payments
Overview
Use the A/P Payment Entry screen to:
- Start new payment entries and enter the general information for a check—such as the type of payment entry, the vendor number, the name on the check, the check date, and whether you are recording information for a check that is already issued or printing it from Accounts Payable.
Note: The fields that appear on the Document section of the A/P Payment Entry screen depend on the type of transaction you are entering.
- Record payments to vendors who are not defined in your Accounts Payable system, such as payments of C.O.D. charges.
- Apply payments to projects you maintain in Sage 300 Project and Job Costing, and allocate partial payments to different contracts and projects listed on the invoice.
- Enter and optionally print checks for vendors to pay outstanding invoices or cash invoices, or to prepay vendors.
- Enter and optionally print miscellaneous checks.
- Apply previously posted prepayments or credit notes to posted invoices and debit notes.
- Import payment batches from non-Sage 300 programs.
- Edit system-generated payment batches (generated by the A/P Create Payment Batch screen).
- Enter adjustments to invoices you are paying in the A/P Payment Entry screen.
- Print a batch listing report for a selected batch.