A/P Invoice Entry Screen

Sage 300 ERP

Home > Screen Guides > Transactions > Invoice Entry

A/P Invoice Entry Screen

Open Accounts Payable > A/P Transactions > Invoice Entry.

Click this button to open the Detail Accounts/Taxes screen, which lets you check or change the distribution code or the accounts to which you are distributing a selected detail.

You can also change tax classes for the particular detail line and indicate whether tax is included or excluded in the detail you are entering. If you are entering taxes manually, you can enter the tax base and the tax amount for the detail.

After entering a new invoice, credit note, or debit note, click this button to add the document.

Note: After adding a document, the button name changes to Save.

Click this button to recalculate the tax amount after you change the vendor tax class for the invoice.

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 arrow button beside the Batch Date field to display the calendar, use the Previous or Next button to display the required month, then click the date you want to use for the batch.

You can also use your mouse or the arrow keys on your keyboard to move from day, month, or year, and then type over the existing date.

Enter the number of an existing batch, or click the New New button button to create a new batch. In the field to the right, enter a description for the batch.

Notes:
  • Accounts Payable automatically assigns a number to each new batch, and to each entry you add to a batch, starting with 1.
  • The batch number is a permanent part of the information stored for each invoice, debit note or credit note, and it appears with the transaction on Accounts Payable reports, such as posting journals and the G/L Transactions report, if you use the option to use the numbers as the description or reference for general ledger transactions.
Tips:
  • Click the Zoom Zoom button button to open the Batch Information screen, which displays additional details about the batch.
  • You can use batch and entry numbers to trace transactions through the Accounts Payable system and, if you use the numbers as the descriptions or references for G/L transactions, into your general ledger (unless you consolidate the transactions during posting in Accounts Payable).

This field displays the number of entries in the selected batch.

This field displays the total for the batch.

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 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.

The vendor's currency and the exchange rate appear when you enter the vendor number in a multicurrency system. 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.

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.

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 button 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, type its number in the Entry field or choose the number from the Finder. To add a new entry, click the New button next to the Entry field.

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 option if the document you are entering is related to a contract that you manage in Sage 300 ERP and Job Costing.

When you select this option, additional fields appear in the detail section of the screen to let you enter the contract, project, category, and resource for each detail.

Note that a document can contain either job‑related details or non-job‑related details. You cannot mix details on the same document.

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 ERP to identify the invoice, credit note or debit note from which retainage is taken from.

This field appears only if Intercompany Transactions is activated for the company you are working with.

Click the Finder to select the originating company for this entry. When the entry is posted, an invoice will be created in the originating company's A/P ledger.

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.

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.

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.

Select this option if retainage applies to the document you are entering.

Notes:
  • This option appears only if you selected the Retainage Accounting option for your Accounts Payable system. For more information, see A/P Options Screen.
  • When you select the Retainage option in Invoice Entry, a Retainage tab appears where you specify how to process retainage for this invoice, debit note, or credit 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.

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, highlight the line and press F9, 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.

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.

If you selected the Job Details option for the invoice, debit note, or credit note, this field appears in the detail-entry section of the Invoice Entry screen and on the Detail Accounts Taxes screen.

The program displays the A/R item number used in the contract in Project and Job Costing. You can select a different A/R item number only for time and material projects, as follows:

  • On a standard contract, the program displays the A/R item number and unit of measure specified for the project resource category as the default. You can accept the item number or select another valid A/R item number.
  • On a basic contract, program displays the A/R item number and unit of measure specified for the project category. You can accept the item number or select another valid A/R item number.
  • If you change the A/R item number, the item number must be a valid item number in Accounts Receivable, and the unit of measure must be a valid unit of measure both for the new item number and the vendor’s currency.

Cost plus and fixed price projects do not use an A/R item number.

This field appears only for time and materials projects on job‑related invoices, debit notes, and credit notes. The billing currency is the customer's currency specified on the contract, and you cannot change it.

This field displays the billing rate for the specified resource (for standard contracts) or category (for basic contracts).

Notes:
  • This field appears only for job‑related invoices, credit notes, and debit notes.
  • You can change the billing rate only if the detail is billable (specified in the Billing Type field).
  • The billing rate cannot be negative.

This field appears in the detail-entry section of the Invoice Entry screen and on the Detail Accounts Taxes screen for job‑related invoices, debit notes, or credit notes. The billing type indicates to Project and Job Costing whether to bill the cost to the customer. For more information, see About Billing Types.

This field appears in the detail-entry section of the Invoice Entry screen and on the Detail Accounts Taxes screen if you selected the Job Related option for the invoice, debit note, or credit note.

Select or enter a category that you have assigned to the specified project in Project and Job Costing.

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.

This field appears in the detail-entry section of the Invoice Entry screen and on the Detail Accounts Taxes screen if you selected the Job Related option for the invoice, debit note, or credit note.

Select or enter a contract number for each detail. You can enter or select only contracts that are open or on hold. (You cannot process transactions to an account that is on hold, if it has never been opened.)

This is the date the expense was incurred. Accounts Payable displays the invoice date as the default for this field, but you can change it.

Type a description for the distribution line.

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

This field appears only if Intercompany Transactions is activated for the company you are working with.

Using the Finder, select the company that ultimately receives the entry made by the originating company. For example, Company B is the destination company where Company A pays an expense on behalf of Company B.

The destination company can be a single or multicurrency company, but, if single currency, it must have the same functional currency as the originator.

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.

The amount calculated for the detail line, before tax is added.

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 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.

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 on the detail entry table and on the Detail Accounts Taxes screen if you selected the Job Related option for the invoice, debit note, or credit note.

Select or enter a project for each detail.

You can enter or select only projects that are:

  • Assigned to the specified contract.
  • Open or on hold. (If a project that is on hold has never been opened, you cannot select it.)
  • Not closed to costs.

Use this field to enter a quantity for the detail, using up to 5 decimal places. (You can enter a negative quantity.)

The program calculates the detail amount based on the quantity and unit cost you enter. This information is used to update the actual extended cost for the contract, project, category, and resource in Project and Job Costing when you post the transaction.

This field appears on the detail entry table and on the Detail Accounts Taxes screen if you selected the Job Related option for the invoice, debit note, or credit note.

For details you are entering for standard projects, you must specify a resource that you have assigned to the project in Project and Job Costing. Select or enter the code for the resource for which the vendor is invoicing, such as an equipment code or a subcontractor code.

If you specified a basic project, you can enter anything you want in this field, or you can leave it blank.

The program uses the retainage percentage to calculate the retainage amount for a detail on an original invoice, credit note, or debit note.

You can enter a different retainage percentage in the Retainage Percentage (%) field. When you enter a new percentage, the program recalculates the retainage amount for the detail.

The retainage amount is the amount you can withhold for an original document or document detail until the end of the retention period, when retainage is due.

This field works differently depending on whether or not the document is job‑related :

  • For a document that is not job‑related :

    • 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.
    • The retainage amount is subtracted from the document amount (or the document total) to calculate the amount due.
  • For a document that is job‑related :

    • To calculate the retainage amount, the program multiples the extended detail amount (or the extended amount plus tax, if you include taxes in retainage) by the retainage percentage.
    • The retainage amount is subtracted from the detail amount to calculate the amount due.

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 program calculates the retainage due date (the date the outstanding retainage is due for invoicing) by adding the number of days in the retention period to the original document date. You can enter a different due date, if you want.

This field shows the tax on retainage calculated for a selected detail on an original invoice, credit note, or debit note.

The retention period is the number of days following the document date that retainage for the document detail will be due.

The program uses the retention period to calculate the due date for the retainage. When you change the retention period, the program recalculates the retainage due date, and vice versa.

This field appears only if Intercompany Transactions is activated for the company you are working with.

Select the appropriate route between the originating company and the destination company selected for this detail line. If the destination company for this detail is also the originating company, the route must be zero.

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.

Examples:
  • If the Undistributed Amount field contains a positive number, you have not distributed the total invoice. (If you used Calculate or Distribute as the tax entry method and tax is included, you must also distribute the tax amount.)
  • If the Undistributed Amount is a negative amount (with a minus sign or in parentheses), check to see whether you accidentally distributed the taxes.

Click the Totals button to see the document summary information, so you can find out where the mistake occurred.

Use this field to enter a unit cost for the detail. The program calculates the detail amount based on the quantity and unit cost you enter. This information is used to update the actual extended cost for the contract, project, category, and resource in Project and Job Costing when you post the transaction. and quantity to let the program calculate the detail amount for you.

This field appears in the detail-entry section of the Invoice Entry screen and on the Detail Accounts Taxes screen if you selected the Job Details option for the invoice, debit note, or credit note.

You must enter a unit of measure that is valid both for the specified item number and for the contract customer's currency.

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.

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.

If you are applying a debit note or a credit note to a specific document, the exchange rate used on the original document appears in this display‑only field.

The vendor's currency 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 in Common Services 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 Currency screens in Common Services. 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 type a valid rate type, or select one from the Finder.

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

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:

  • Use Original Document Exchange Rate. This method uses the same rate as the document you are processing.
  • Use Current Exchange Rate. This method uses the rate in effect when you process the retainage document to clear the outstanding retainage.

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.

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 in Common Services, 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 Currency screens in Common Services. 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 type a valid rate type, or select one from the Finder.

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

This column appears on the Invoice Entry Taxes tab only for original invoices, debit notes, and credit notes to which retainage applies. It shows the total amount of tax calculated for retainage for the document.

Retainage tax amounts are computed using the retainage tax base and the tax rate for each tax authority.

If you report tax for Accounts Payable As Per Tax Authority, and the tax authority reports tax when the retainage document is posted, Accounts Payable can compute the amount, or you can enter or distribute a retainage tax amount. If tax is reported when the original document is posted, however, the amount is zero.

Accounts Payable updates Project and Job Costing with retainage tax amounts when you post original documents. The tax amounts appear as committed costs in the Contract Maintenance screen in Project and Job Costing.

This field appears on original documents to which retainage applies. It shows the amount (before included taxes) used to calculate tax on retainage, if the tax will be reported when you post the retainage document.

Two factors determine when tax on retainage is reported:

  • Your choice for the Report Tax option for Accounts Payable (on the Retainage tab of the A/P Options screen):

    • At Time Of Original Document. If you select this option, Accounts Payable calculates and posts tax on retainage when you post the original document, regardless of the tax reporting options you select in Tax Services for the tax authority.
    • As Per Tax Authority. If you select this option, Accounts Payable respects the selection for the Report Tax On Retainage Document option for the tax authority.
  • The setting for the Report Tax On Retainage Option for the tax authority, in Tax Services.

    The tax authority may specify that no tax on retainage will be calculated (No Reporting), or that tax will be calculated and posted either when you post the original document or when you post the retainage document.

Note: A retainage tax base does not apply if tax on retainage is reported when you post the original document.

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 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:

  • Calculate. Select Calculate for the Tax Reporting option if you want Accounts Payable to calculate tax reporting amounts automatically using information you specify in the Tax Reporting Currency Rate section.
  • Enter. Select Enter if you want to enter tax reporting information manually for the document.

    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 Rates button to compute the exchange rate used to convert manually entered tax amounts to the tax reporting currency.

  • Distribute. Select Distribute if you want to enter total tax reporting information manually for the document, and have the program automatically distribute tax reporting amounts to the details.

    You can also click the Derive Rates 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.

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.

Note: This setting applies to the whole invoice. You can override this setting for single distribution lines on the Document tab.

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, then click the Go button 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 appears on the Terms tab of the Invoice Entry screen. The program 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.

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.

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, press the F9 key, 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.

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.

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 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 difference between the To Be Calculated amount less the Allocated Tax amount.

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 total amount of tax, less any tax that is recoverable or expensed separately, that you must distribute for the document.

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.

Examples:
  • If the Undistributed Amount contains a positive number, you have not distributed the total invoice. (If you used Calculate or Distribute as the tax entry method and tax is included, you must also distribute the tax amount.)
  • If the Undistributed Amount is a negative amount (with a minus sign or in parentheses), check to see whether you accidentally distributed the taxes.

Click the Totals button to see the document summary information, so you can find out where the mistake occurred.

Overview

Use the A/P Invoice Entry screen to:

  • Enter vendor invoices, credit notes, debit notes, and individual interest charges.
  • Enter prepayments with invoices.
  • Edit invoices, credit notes, debit notes, and invoices in batches created in Accounts Payable or imported from other accounting programs.
  • Add a new vendor or a new remit-to location during invoice entry or when editing an existing invoice.
  • Enter job‑related details that will update contracts and projects in Project and Job Costing.
  • Enter intercompany transaction details, if you use the Sage 300 ERP Intercompany Transactions (ICT) program to send transactions between companies.

    The following ICT fields appear only for ICT companies: Originator, Destination, and Route No.

  • Print a batch listing report for a selected batch. (Click File > Print Batch Listing Report > Print.)

Note: You can use the Quick Mode option on the Settings menu to copy many of the fields from the previous transaction or detail to a new transaction or detail, so you don't have to re-enter them. For more information, see Menu Commands.

Document Tab

Use this tab to:

  • Enter header information for the document.
  • Indicate that the transaction is related to a project you maintain in Sage 300 ERP and Job Costing, and enter job‑related information for each document detail.
  • Enter account distribution information for the document.
  • Edit or delete existing distributions.
  • Add a new vendor or a new remit-to location during invoice entry or when editing an existing invoice.
  • Indicate that the transaction is an intercompany transaction by selecting the originating company for the transaction (the originator), the destination company, and the route number of the transaction. For more information about intercompany transactions, see the Intercompany Transactions help.

    Note: Posting an ICT batch creates an A/P batch in the originating company's Accounts Payable ledger (for posting to vendor accounts), and creates an ICT G/L batch in the ICT company.

Optional Fields Tab

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

Use this tab to:

  • Check the optional fields used on a document.

    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.

  • Assign different optional fields to a document.
  • Check or change optional field values.

    Default values appear for 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 optional field values for the remit-to location appear on the Optional Fields tab.
    • If the remit-to location record and the vendor record use different optional fields, 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.

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 and on the Detail Accounts/Taxes screen 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 Fields Zoom Zoom button button 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 in Common Services.

For more information about entering invoice detail optional fields on invoices, see About Entering Optional Fields on Invoices.

Rates Tab

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.

Retainage Tab

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. Unless the document is job‑related , you can change these retainage factors for a particular document.

If the document is job‑related , you can change only the retainage rate and retainage terms on this tab. You enter job‑related retainage amounts, retention periods, and retainage due dates with each job detail.

Accounts Payable calculates and displays the retainage amount and retainage due date for the selected document. You can change these fields, whether or not the document is job‑related .

For more information about processing retainage, see About Processing Retainage in Accounts Payable.

Taxes Tab

Use this tab to:

  • Change the tax class and tax included settings for the specified tax group.
  • If you want to enter taxes manually, edit the tax base and tax amount fields.
Notes:
  • To change the tax authorities listed on this tab, you must select a different tax group on the Document tab.
  • To change the tax rates, you must use the Tax screens in Common Services.

Terms Tab

Use this tab to:

  • Specify the terms for the invoice, if they are different from those specified in the vendor record.
  • Edit multiple payment schedules that are calculated for invoices.
  • Override the discount base or discount amount calculated for an invoice.

A payment schedule is created only if the invoice terms code uses the Multiple Payment Schedule option.

Multiple Payment Schedules

Accounts Payable adds a Payment Schedule to the Terms tab if you assign a terms code that uses a multiple payment schedule (for a number of payments over a period of time such as six monthly payments).

The payment schedule divides the invoice total into the number of payments specified by the terms code. Each payment has its own due date, payment amount, and discount period, which is displayed on the Terms tab of the Invoice Entry screen. If you want, you can change any dates on the schedule, as well as decrease the number of payments (by making later payments blank).

You can use multiple payment schedules with Intercompany Transactions.

You can print payment schedules on batch listings if you select the Show Schedules option when printing listings of invoice batches from the Batch Listing screen.

Totals Tab

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.

Recoverable and Separately Expensed Taxes

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 Dist. Taxes button, Accounts Payable:

  • Removes (deducts) any recoverable portion of the tax from the tax distribution amount and assigns it to the tax recoverable account.
  • Removes (deducts) any portion of the tax which is expensed separately and assigns it to the tax expense account.

Related Topics IconRelated Topics