Creating Manual Invoices Version

Contents

This topic discusses:

Links to related topics:

Search Online Doc
Current Release Notes

Overview

The Financials system lets you create and process manual invoices. Creating a manual invoice has parallels with creating an invoice from a purchase order. This section explains how to enter manual invoices.

You can create manual invoices only from Accounts Payable. Two methods exist:

Many sites require approval of invoices. You can set up approvers in ERP and design the approval flow for your invoices as suits your operations. Details are in the topic Invoice Approval Processing. Also, in the Process Flows section of the online help The Approval Process for Invoices, Check Requests, Requisitions, and Vendors: Setup and Flow may be useful.

Financial Reporting Fields

Your site may be set up to use Financial Reporting Fields in various parts of the application. Similarly, you may also be using Project Codes and Fund Codes.

Financial Reporting Fields, along with Project Code and Fund Code let you generate reports on non-account code fields. For example, your site might define Physician as a financial reporting field. Users could then select the physician associated with a manual invoice, for example.

If financial reporting fields are used by your site, the tab Fin Reporting appears on the manual invoice panels. (Otherwise, this tab does not appear.) You can enter field values on the tabbed panel.

Details are in Using Financial Reporting Fields in ERP.

Security

To access organization, department, or asset location data, the organization, department, or asset location must be included in your data profile.

Your assigned role's "Invoicing" security object must be set to Create (minimally) for you to create manual invoices.

Manually Create a New Invoice from the Invoices List:

  1. Locate the vendor's copy of the invoice.
  1. From the Accounts Payable main Contents, select Invoices > Invoices.
    The Invoices list appears.
  2. Click New. A panel for entering the invoice's header information appears.
    Follow the subsequent steps for creating the invoice.

Entering Information on Invoice Panels

The first panel for entering invoice information is the Create Invoice panel (Figure 1).

  1. Enter or select information for the fields on this panel.

Fields containing an asterisk (*) are required.
Be sure to check fields on both tabs -- Invoice and Approval -- for fields that you may need to complete.

Figure 1 - Creating a Manual Invoice: Header

Header Panels: Invoice and Approval

Below are details for invoice fields.

Organization

 

The Organization specified in your Current Setting appears in the field. Click the prompt to select a different organization. You can select any organization in the list. (The list shows all organizations defined in your user profile.)

Vendor Number Click the prompt to select the vendor number for the invoice's vendor.
Invoicing Location The system populates this field with the Vendor AP Location. You can select a different AP Location, if needed.
Invoice Number. Enter the invoice number from the copy of the invoice. The Invoice Number can have a maximum of 30 characters.
Invoice Date Enter the date from the invoice.
Invoice Received Date If your organization tracks invoice received dates, enter the date when the invoice arrived for processing.
Invoice Total

Enter the total dollar amount of the invoice.

If you also work with purchase order invoices, notice that a manual invoice has no Taxable Amount field.

PO Number

A purchase order number associated with the invoice, if any.

Period

The period on the invoice. When you create an invoice group, the period and year that you enter are the defaults for all the invoices in the group, regardless of how any invoice was created (e.g., manually, with a PO, etc.). Invoices created in another period cannot be added to the group.

Year

The year. Normally, defaults to the current year. If the invoice is created as part of an invoice group, however, the period and year for the invoice group are the defaults for all the invoices in the group, regardless of how any invoice was created (e.g., manually, with a PO, etc.). (Invoices created in another year cannot be added to the invoice group.)

Description A description of the invoice.
Distribution Profile

A Distribution Profile contains pre-built charge lines for charges such as freight, postage, etc. If the vendor has an associated Distribution Profile, the system populates this field. You can also select a profile from the prompt.

The AP tables contain your site's Distribution Profiles, if any have been set up. See Set Up Charge Types and Distribution Profiles for details.

Default 1099 Code

The relevant 1099 code, if any.

Default Project Code

The identifier of the default project, if any, associated with the invoice. The default Project Code is the Project Code specified on the Vendor record (if any).

Default Fund Code

The identifier of the default fund, if any, associated with the invoice. The default Fund Code is the Fund Code specified on the Vendor record (if any).

Invoice Group ID An identifier for the invoice group.
If you select an invoice group, the system verifies that the organization has the invoice group.
If not, an error message appears when you click Submit. In that case, change either the organization code or the invoice group identifier.
Payment Terms Initially set to the vendor AP location's default values, but you can select new payment terms from the prompt.
Invoice Due Date

The date when payment is due, as stated on the invoice.
For credit invoices, the system defaults the Invoice Due Date to the Invoice Date.

Discount Terms

Initially set to the vendor AP location's default values, but you can select new discount terms. You can also select the tabs: Invoice > Discount to specify new discount schedules. The system allows up to three discount schedules.
Discount Date

The date through which a discount can be taken on the invoice.

Tax Type

Notice that the invoice in Figure 1 has a Tax Type of "Sales taxable."
A Tax Type is defined for each AP location. Options are: Sales taxable, Use taxable, Non-taxable. The system populates the Tax Type field from the tax information in the vendor AP location record.

Initially, the system shows the Tax Type as specified in the organization record. When you select a Vendor /AP Location using the prompt, the system populates the tax fields based on both the organization and vendor / AP Location records. If you key in the Vendor and AP Location manually, and the AP location is sales or use-taxable, the Tax Type and Tax Group fields default to the AP location's tax settings.

On manual invoice with a default of Sales Taxable or Use Taxable, if the system finds no default Tax Type or Tax Group, the Tax Type /Tax Group fields are not completed.

Before you can process tax charges, AP must be enabled for taxes. See Setting Up Tax Information for Accounts Payable.

Tax Group

(Also see Tax Type)

A Tax Group contains a group of related taxes, tax expense and liability accounts for each tax in the group, and a distribution method. If the invoice is taxable, and you have enabled tax processing for AP, the system calculates the tax for each goods line using the Tax Group settings.

Taxes can be distributed two ways:

Pro-rated - The total tax amount is distributed among accounts for the goods lines. The amount distributed is proportional to each goods line's percentage of the total amount.

Single GL Account - The total tax amount is posted to a single account.

Inter-Org Distribution Allowed

When checked, an invoice can be distributed among different organizations in a multi-organization environment.

Payment Method

Specifies the payment method to be used. The payment method is inherited from the Vendor AP Location record. The Payment Method can be overridden when a payment is created.
Methods are:

  • ACH - Automated Clearing House. Creates an export file for payments in the ACH format.
  • Check - Creates a check-formatted export file
  • Credit Card - Creates credit-card payments.
  • Local Check - This option appears for sites with Integrated Payment Exports.
    With this option, you can designate an invoice for local payment, so that it is not included in a payment run for integrated payments.

The payment completion process automatically clears invoice payments whose payment method is Credit Card or any of the ACH types.

Approval tab:

Direct Approver

 

A single individual responsible for approving invoices. Click the prompt to select the approver for the invoice.
You can select a Direct Approver or an Approver Group, but not both.
Note: Your organization may require that you enter either a Direct Approver or Approver Group for manual invoices. If required, and you fail to enter either a direct approver or approver group, Accounts Payable displays an error message.

Approver Group A group of users who approve invoices. The group has been set up in the system.
Invoices are routed within the group based on the amount of each invoice, and each group member's approval dollar limit.
In the routing process, an invoice's Total is compared to each approver's Maximum Approval Limit to determine if the approver needs to review the invoice.
Each member of an approver group can approve or reject invoices up to his/her dollar limit.
Note: Your organization may require that you enter either a Direct Approver or Approver Group for manual invoices. If required, and you fail to enter either a direct approver or approver group, Accounts Payable displays an error message.
Approval Needed By Date The date by which approval of the invoice is needed.
Approval Notify Action For users who create invoices, this field specifies how the user should be notified when an invoice has been approved or rejected by the person or approver group responsible for approvals.

If the user does not wish to be notified, the setting is No Notification.

Your User Profile has the default setting for notification. This field overrides the default.

If you wish to change your default Notify Action, select an action from the prompt (...). The choices are:
No Notification (default)
email on Approve
email on Reject
email Approve or Reject
.
The email options send the user email to the address specified in the email Address field (on the General tab).
Distribution Review Direct Approver

The approver with the authority to balance and approve unbalanced distribution lines on a manual invoice that has been reviewed and approved by a distribution review approver group.

This person cannot be the same as the Direct Approver.

Distribution Review Approver Group Users designated to review distribution lines on a manually created invoice. If an individual distribution review approver group member balances and approves the distribution lines on the invoice, it will bypass the distribution review direct approver.
Exception Clearing Notify Action For users who create invoices, the user profile field Invoice Exception Clearing Notify Action specifies (by default) how the user should be notified when an invoice exception has been cleared.

Figure 2 is a manual invoice header with several fields completed. Notice that the Payment Terms and the Discount Terms are initially set to the vendor's AP location defaults (red arrows). You can change the Payment Terms and Discount Terms by selecting new values from the prompt.

Figure 2 - Manual Invoice Header with Vendor Entered

  1. Click Submit.
    The invoice distribution panels appear (Figure 3).

Figure 3 - Invoice Distribution Lines Panel

The next task is to create lines on the Distribution Lines panel. The invoice in Figure 3 (with a total amount of $390.86) will have three lines for items, and a charge line.

Create Lines for Goods

  1. On the Distribution tab, click the prompt next to GL Account to select an account for the line amount.
  2. Enter the dollar amount for a line in the Amount field.
  3. When you enter a financial account in the GL Account field, the application sets the Line Type automatically to Goods.
    (You can change the Line Type value manually for financial accounts.)
  4. Enter a Description of the line.
  5. If relevant, select a 1099 Code.
  6. If the distribution line has a Project Code and/or Fund Code, enter or change the values in those fields.
  7. Click Save.
    The line appears under Invoice Distribution Lines. Invoice distribution lines are initially sorted according to the account type, with lines for financial accounts at the top.

    Figure 4 shows two lines added to the invoice, and a third line in the process of being added.

Figure 4 - Entering Goods Lines on a Manual Invoice

  1. Click Save.
    The Invoice Total, Distributed Amount, Tax Amount, and Difference (in the upper right) are updated (Figure 5).

Figure 5 - Entering the Invoice's Last Goods Line

Create Statistical Distribution Lines

You can enter statistical GL account information on an invoice from the Distribution tab, just as you enter financial accounts for goods or charges. Statistical accounts can also be entered on Check Request detail lines. (See the Check Request topic.) Invoices with statistical account distribution lines can be imported. (See Import Invoices into Financials.)

Statistical recurring invoice distribution details are not currently supported.

To build a statistical distribution line:
  1. On the Distribution Lines > Distribution tab, click the prompt next to GL Account to select an account for the line amount (See Figure 6).
    - Enter statistical in the Account Class field, and click Enter.
    A list of statistical accounts appears.
    - Select the account of interest.

Figure 6 - Entering an Invoice Distribution Line for a Statistical Account

When you select a statistical account for a distribution line, the application sets the Line Type to Statistical. The application will not let you change the Line Type when the GL Account field contains a statistical account. If you key in statistical account segments manually, you will need to set the Line Type to Statistical manually.

  1. Enter the amount for the statistical distribution line in the Amount field.
  2. Enter a Description of the line.
  3. Click Save.
    The line appears under Invoice Distribution Lines. Invoice distribution lines are initially sorted according to the account type, with lines for statistical accounts on the bottom.

Restrictions for Statistical Account Lines: An invoice cannot contain only statistical account lines. It must also contain lines for financial accounts.

Amounts for Statistical Account Lines

Amounts for statistical account lines are not added to other distributed totals for an invoice. When you balance an invoice with lines for statistical accounts, the value(s) that you entered in the Amount fields for each statistical distribution line are accumulated in the Statistical Amount field on the invoice header (Figure 7).

Figure 7 - The Statistical Amount Field on an Invoice Header

Notes on Transactions for Statistical Accounts

Accrued Receipts
Accrued Receipts Summary
Accrued Receipts Summary2
AP Reconciliation Report
AP Reconciliation Report - All Periods
AP Reconciliation Report - Summary
Payment Expense Accounts.

GL Export Report
GL Export Summary Report
GL Transactions MM and AP.

Invoice Activity
Invoice Activity Summary
Invoice Match Header.

Entering Charge Distribution Lines

A distribution profile may be associated with the invoice vendor. If so, the system automatically creates distribution lines as specified in the distribution profile. Also, if your organization has a General Ledger account specified for Freight and/or Other (in the Organization record), the system will pre-build distribution lines for those categories on the invoice. (If you don't use the lines, they are automatically deleted when you click Finish Now.) Otherwise, if the invoice has no appropriate pre-built lines for charges (as in Figure 1), you need to create the lines yourself.

To build a charge line, enter charge line information on the Distribution tab in the same way that you entered goods lines:

    1. Select the GL Account for the charges.
    2. Enter the line Amount from the vendor's invoice.
    3. Select a Line Type; e.g., Charge.
    4. Enter a Description of the line.
    5. Enter 1099 Code, Project Code, and/or Fund Code values, if needed.
    6. Click the prompt next to Charge Type to open the Charge Types list (Figure 8).
    7. Select a Charge Type.

Figure 8 - List of Charge Types

Each charge type assigns charges to general ledger accounts according to a specified Distribution Method. The distribution methods are:

Pro-rate - Allocates charges to each goods line's account in proportion to the total goods amount. On the invoice, you do not need to enter a GL account for the charges since they will be spread among goods accounts when the invoice is approved.
Spread Evenly - Allocates an equal amount of the charges to each goods line when the invoice is approved.
Single GL Account - Allocates the total charge amount to one GL account. Instructions for identifying the account are below.
Manually - You must select the GL account for the charge on the invoice.

  1. Click Save.
    The Invoice Total, Distributed Amount, and Difference are updated again (Figure 9).

Figure 9 shows the invoice with a freight charge of $16.36 entered as a freight charge with Charge Type "Freight on Board." Because the distribution method for the Charge Type is "Pro-rate," $16.36 will be distributed among the goods lines in proportion to each line's contribution to the total amount. The distribution of the charges occurs when the invoice is approved. (You will not see charges added to goods lines amounts as you are entering charges.)

Figure 9 - Manual Invoice with Charge Line, Balanced

When your invoice is balanced, the Difference field (top right) is zero. You can complete the invoice by clicking Finish Now, or click Finish Later to come back to the invoice another time.

Using Scanned Invoices

When you receive a paper copy of an invoice, you can scan it into your network and have it sent directly to Accounts payable. Scanned invoices are delivered to the system via Pulse. Once in the system, the scanned file can be used to create an invoice. When you create an invoice, you can attach the scanned file as a document.

Each user who works with invoices needs a network folder -- an "inbox" -- for scanned invoices that are picked up by Pulse and uploaded to Accounts Payable. Panels in Accounts Payable provide access to scanned invoices for each user of this feature. Panel menus provide actions such as creating a new purchase order invoice or manual invoice. Scanned invoices used to create an invoice can be attached to the Invoice Documents panel.

Several steps are involved in configuration of this feature. Pulse uses the file type Scanned Imports which must be enabled. Also, you may wish to make the feature available only for particular organizations and users. Your scanner must also be capable of outputting scans in Adobe Acrobat .pdf format.
Important: Call the Help Desk for assistance with setup.

To display and work with scanned invoices:

  1. Check with your system administrator to ensure that Pulse (the "gateway") and your "inbox" for scanned invoices are set up and enabled.
  2. On your network scanner, follow the usual procedures for creating and saving scans (e.g., you may need to log in).
  3. Scan the invoice as an Adobe Acrobat file (.pdf format).

Figure 10 - The Unprocessed Scanned Invoices List

  1. From the Accounts Payable main Contents, click Invoices > Unprocessed Scanned Invoices.
    The panel displays uploaded scanned invoice file names.

To create a manual invoice from a scanned file:

Creating a manual invoice follows the usual steps. See the previous discussion "Entering Information on Invoice Panels." Below is a summary.

  1. On the Unprocessed Scanned Invoices panel (Figure 10) (Accounts Payable > Invoices > Unprocessed Scanned Invoices),

Figure 11 - Create Manual Invoice Header Form

  1. Using the open copy of the scanned invoice for reference, complete the invoice header information, as usual.
  2. Click Submit.
  3. Referring to the scanned invoice, enter the invoice lines and any distribution information.
  4. When you are finished, click Finish Now. If you use invoice approvals, the invoice routes for approval.

To add the scanned document to the invoice you created:

  1. On the Unprocessed Scanned Invoices panel (Figure 10) (Accounts Payable > Invoices > Unprocessed Scanned Invoices), locate the scanned invoice of interest.
  2. Click Menu > Attach to Existing Invoice
    A panel appears for you to identify the existing invoice (Figure 12).

Figure 12 - Selecting an Invoice for a Scanned Document

  1. Next to the Invoice No field, click the down arrow to select the invoice.
    The selection prompt appears.
  2. Use the prompt to open the Invoices list and select the invoice.
    The invoice number appears in the Invoice No field.
  3. Click Submit.

The scanned invoice disappears from the Unprocessed Scanned Invoices panel and moves to the Processed Scanned Invoice panel (Accounts Payable > Invoices > Processed Scanned Invoices).

Figure 13 - Displaying a Scanned Invoice Document Attached to an Invoice

Copying a Manual Invoice

With Financials: Accounts Payable, you can copy a manual invoice.

To copy a manual invoice:

  1. From the the Accounts Payable main Contents, select Invoicing > Invoices.
  2. Locate the manual invoice that you want to copy using Search, or scroll the list.
  3. Select Menu > Copy. The invoice matching header appears; the fields are editable.
  4. Enter an Invoice Date, change the Invoice Number to the new number, and complete or edit other fields as needed.
    The Invoice Number can have a maximum of 30 characters.
  5. Click Submit. The invoice detail lines appear.
  6. Enter information in the detail lines, or edit the copied information.
  7. Click Finish Now or Finish Later.

Viewing an Approved Manual Invoice

Once an invoice is completed and approved, you can review it to see how the system distributed amounts for goods, charges, and tax to accounts.

To inquire on an invoice:

  1. From the Accounts Payable main Contents, select Invoice > Invoices.
    The Invoices list appears.
  2. Enter the invoice number in the Position To box.
  3. Click Go.
    The invoice appears appears at the top of the list.
  4. In the row for the invoice, click Menu > Inquiry, or click the i.
    The Inquiry panel appears.
  5. Click the Distribution tab to see how amounts are distributed to accounts.
    Figure 14 is an example, using the invoice shown in Figure 9.

Figure 14 - Inquiry on a Manual Invoice

In Figure 12, the red box contains the goods lines from the invoice. The blue box displays the charges. Since the distribution method for the Charge Type is "pro-rate," the charge lines are distributed among the goods lines, and posted to the goods account (001-000-00-0008). (The account happens to be the same for each goods line, but the accounts could differ.)

The items on the invoice are taxable. The Tax Group for the invoice is 7% Tax. (Figure 3). This tax group contains two tax rates: "NC STATE 5.000%" and "NC FOOD 2.000%." Both tax rates are applied to each goods line, and the tax amount is written to the goods accounts, in this case: 001-000-00-0008. You can view the tax lines under the charge lines in Figure 12.

Invoices Created from Check Requests

Check requests are user-initiated requests for invoice payment. These requests contain information that populates a manual invoice within Accounts Payable. Invoice Number, Invoice Date, Invoice Total, Vendor, and Pay To data can be entered on a check request, as well as check total and distribution detail amounts. When information on the check request is complete, and the check request is balanced and approved, AP staff can create an invoice from the check request and submit it for payment.

An approval workflow allows each check request to be reviewed by a single “direct” approver or routed to several approvers in an approver group. Every department that uses check request processing can identify a direct approver or approver group on its department record.

Several setup steps are necessary if you wish to use check requests. Also, check request users must have the appropriate security settings in the check request role objects. Check request data is also governed by users' data profiles.

If the Check Request feature is enabled for your site, and you have the appropriate permissions:

Check requests are explained in detail in the online documentation topic "Check Request Processing."

Documents Attached to Invoices

Documents can be attached to invoices. The documents can be viewed, added, or deleted when editing or inquiring on an invoice.

Documents Containing Electronic Protected Health Information (ePHI)
If you do not have ePHI access, and the "Contains ePHI Data" checkbox is selected, you cannot view a document. When you click the arrow to open the document, the Insufficient Authority message appears. For more information, see Securing Electronic Protected Health Information (ePHI).

For Bill Only documents, if the checkbox has previously been selected for "Contains ePHI Data," then only the Administrator can change the status of the document and select or unselect the "Contains ePHI Data," checkbox. This checkbox remains locked for everyone else.

To view and work with an invoice's documents:

  1. On the Invoices list, locate the invoice of interest.
  2. Next to the invoice, click i for inquiry (or, if the invoice is available for editing, click the pen icon ).
  3. Click the Documents tab. The Invoice Documents panel appears (Figure 15).
    A list of documents for the invoice is displayed, if any have been uploaded.

Figure 15 - The Documents Panel for an Invoice: Inquiring on the Invoice

To add a document to an invoice:

  1. Click the Documents tab when editing or inquiring on the invoice.
  2. Click New.
    The Invoice Document Create panel appears (Figure 16).
  3. Enter a name in the Document Name field.
    The name displays on the Invoice Documents panel when the document is uploaded.

Figure 16 - Adding a Document to an Invoice

  1. Click Browse.
    The Microsoft Windows Choose File panel appears.
  2. Locate and select the file for the document that you wish to upload and add.
    When you select the file, Windows populates the File name: field on the Choose File panel.
  3. Click Open (on the bottom right of the Choose File panel).
    The document path and file name appear in the Document to Upload field on the Invoice Document Create panel.
  4. Click Submit.
    A message tells you that the document is uploaded.
  5. Click the back button or close the tab to close the message.
  6. Click Refresh.
    The document appears on the Invoice Documents panel (Figure 15).