Setting Up Tax Information for Accounts Payable Version

Contents

This topic discusses:

Links to related topics:

Search Online Doc
Current Release Notes

Overview

The Accounts Payable Tax feature handles taxes -- including use taxes -- for invoices. A tax group contains multiple tax rates and their associated GL accounts. For example, a tax group may contain state, city, and local tax rates, all applicable to invoices from a particular vendor. Supply Chain calculates taxes for invoice lines using a tax group. When invoices are approved, taxes are posted to organizations' tax expense and liability accounts

The AP Tax feature must be enabled before the system can calculate taxes.

Some hospitals need to order items for locations that are in different cities, and different cities may have different tax rates. Because tax is determined based on where product ships to, not where it is ordered from, an invoice may be out of balance when it is created. To accommodate this need, you can set a AP tax rate for a department, and require tax to be calculated at the department rate in situations where the jurisdiction for the department is different from the organization, and tax is different. Similarly, you can set tax rates for asset locations, where the asset location may be in a different geographical area, compared to the organization. Tax can also be set up for vendor AP locations, if needed.

This topic describes the setup steps and summarizes how to use the tax feature in Accounts Payable.

Security

To access organization, department, or asset location data, the organization, department, or asset location must be included in your data profile. Additionally, for any asset location, you must have permission to maintain the asset location record. See "Restricting Users from Editing Asset Location Records."

Your assigned role's "APTables" security object must be set to Modify, Create, or All for you to edit AP tables.

Setup Checklist

Creating Tax Rates

You can create tax rates, and then assign the rates to tax groups, which you also create.

To create a tax rate record

  1. From the Materials Management or Accounts Payable main Contents, select Tables > Tax Rates.
    The list of tax rates appears (Figure 1), or No Data if no tax groups exist.

Figure 1 - List of Tax Rates

  1. Click New.
    The new Tax Rate panel appears (Figure 2).
    Use this panel to give the new tax rate an identifier -- enter a Tax Rate Code and Description -- and set the percentage in the Tax Rate field.

Figure 2 - Creating a New Tax Rate

  1. Click Save.
  2. Click Submit.
    The tax rate is available to assign to a tax group, if you wish.

Creating Tax Groups

To set up tax group names and distribution methods

  1. From the Materials Management or Accounts Payable main Contents, select Tables > Tax Groups.
    The list of tax groups appears (Figure 3), or No Data if no tax groups exist.

Figure 3- List of Tax Groups

  1. Click New.
    The new Tax Group panel appears (Figure 4).
    Use this panel to give the new tax group an identifier.

Figure 4 - Creating a New Tax Group

- Pro-rate allocates the tax expense proportionally to accounts for goods lines and for taxable charge lines.
- Single GL Account allocates the entire tax expense to one account.

  1. Click Save.
  2. Click Submit.
    The Tax Group Rates panel appears (Figure 5).

To include tax rates in tax groups

  1. The Tax Group Rates panel provides several options.

Figure 5 - Adding a New Tax Rate to a Tax Group

Figure 6 - New Tax Rate for a Group is Automatically Selected

Figure 7 - Adding an Existing Tax Rate to a Tax Group

  1. Click Save and Submit.
    The panel (Figure 7A) displays the total tax rate in the Total Tax Rate field. This value sums the tax rates for the tax group.

Figure7A - Tax Group Rates Totaled

To associate each tax rate with an organization's GL accounts

Note: The tax accounts must exist in each organization's Chart of Accounts before you can assign them to tax rates.

  1. From the Tax Rate list (Figure 1, Figure 6 or Figure 7), next to a tax rate, select GL Accounts.
    No Data appears for a tax rate that is newly created. (Otherwise, a list of GL accounts already assigned to the tax rate would appear.)
  2. Click New.
    The Tax Rate GL Edit panel appears (Figure 8). This panel contains fields for the GL expense and liability accounts associated with the tax rate.

Figure 8 - Associating a Tax Rate with a General Ledger Account

  1. Select the Organization.
  2. Click the prompt to select a GL account for the Sales and Use Tax Expense.
  3. Similarly, select an account for Use Tax Liability.
  4. Click Save.
  5. Click Submit.
    The system returns to the GL Accounts list.
  1. Click Refresh. The GL Accounts list appears with the tax rate account included.
  2. Click X in the upper right corner to close the window.
    The system returns to the Tax Rates list.

To enable AP taxes for an organization

  1. From the Accounts Payable main Contents, select Tables > Organizations. A list of organizations appears.
  2. Locate the organization of interest on the list.
  3. Next to the organization, click the edit icon (), or select Menu > Edit.
    The Organization edit panel appears.
  4. Click the AP Information tab.
    The AP Information panel appears (Figure 9).

Figure 9 - Organization AP Information Panel

  1. Select the field AP Tax Enabled (Figure 9, purple box).
  2. If a tax group has been created to use as the organization's default, click the prompt next to the box for Default Tax Group and select the tax group.
  3. You can also select Freight Taxable if you are using Sales Tax Exception processing. See the subsequent discussion.
  4. Click Save.
  5. Click Submit.
    The system displays the Organization list.

Set Up AP Tax for a Vendor AP Location

  1. From the Materials Management or Accounts Payable main Contents, select Vendors > Vendors.

  2. On the Quick Click menu, select AP Locations.

  3. Enter the Vendor No in the box and click Go. The AP locations for the vendor appear.

  4. Next to the appropriate AP location, click the edit icon (), or select Menu > Edit.
    The AP Location Edit panel appears (Figure 10).

Figure 10 - Vendor AP Location Panel

  1. Select the Default Tax Type for the vendor AP location. Options are: Sales taxable, Use taxable, Non-taxable.
  2. Select a Default Tax Group for invoices from the vendor AP location.
  3. When you have finished , click Save.
  4. Click Submit.
    The system returns you to the list of the vendor AP locations.

Set Up AP Tax at the Department Level

The AP Info panel (Figure 11) on the department record "switches on" a tax requirement and tax calculations for invoices associated with the department.

Note: Tax is calculated at the department level only when the Separate PO by Department field is enabled.

Figure 11 - Setting AP Tax at the Department Level

Since you can also specify AP tax to be calculated at the vendor, asset location, and organization level, ERP follows a hierarchy in determining which tax group to apply to an invoice. The way ERP decides what tax group to use is discussed below.

This feature is available for PO invoices including EDI 810 invoices.

Set up AP tax for an asset location.

The asset location's AP Info panel (Figure 12) "switches on" a tax requirement and tax calculations for invoices associated with the asset location.

To enter AP tax data for an asset location:

  1. From the Materials Management main Contents, select Tables > Asset Locations. A list of asset locations appears.
  2. Locate the asset location on the list. Click the edit icon, or select Menu > Edit.
    The Asset Location edit panel appears.
  3. Select the AP Info tab (new in this release).
  4. To require the calculation of tax on invoices for the asset location, select AP Tax Enabled.
  5. Select a Default Tax Group.

Figure 12 - Setting AP Tax at the Asset Location Level

Since you can also specify AP tax to be calculated at the vendor, department, and organization level, ERP follows a hierarchy in determining which tax group to apply to an invoice. The way ERP decides what tax group to use is discussed below.

This feature is available for PO invoices including EDI 810 invoices.

How ERP identifies the correct tax rate to use to calculate AP tax

When a department, asset location, organization, or vendor requires AP tax to be calculated, ERP checks whether a tax rate has been specified on the AP Info tab or on the vendor AP location Main tab. If so, the application uses it. If not, ERP checks other possible tax settings in hierarchical order until tax is found.
The order the application uses to search for a AP tax rate is the following:

Tax for Department:
The hierarchy is: Vendor AP Location > Department > Asset Location > Organization.
For invoices with a departmental Ship To location that are "separate PO by department" and "direct delivery," the Default Tax Group on the department's AP Info tab is used to calculate taxes unless the vendor AP location specifies a tax group.

If no tax data exists at the department level, ERP checks the asset location associated with the department for tax data. Finally, if no tax data exists for the asset location, ERP looks at the organization to determine if it has tax information.

When no tax information is available anywhere in the hierarchy, a message appears directing the user to enter tax information (a Default Tax Group).

Tax for Asset Location:
The hierarchy is: Vendor AP Location > Asset Location > Organization.

For invoices with the asset location as the Ship To location, if the vendor AP location contains tax data, ERP uses the vendor data to calculate taxes. Otherwise, ERP uses the tax specified for the asset location. Finally, if no tax data exists for the asset location, ERP looks at the organization to determine if it has tax information.

When no tax information is available anywhere in the hierarchy, a message appears directing the user to enter tax information (a Default Tax Group).

The attached images summarize the way AP tax settings will work when this feature is implemented.

Note: Non-PO Invoices use the hierarchy AP Location > Organization.

Automatic Calculation of Freight Tax

When an invoice is created, the system generates a distribution detail line for freight if a freight account is defined on either the asset location (for a PO invoice) or on the Organization record (for all types). The system first checks the asset location then the organization to determine if a freight account exists. When the freight account is present, a distribution detail line is automatically created for the account with a zero dollar line amount. It is up to the user to enter an amount if needed; otherwise, if the value is still zero when the invoice is submitted, the line is removed .

When you are using Sales Tax Exception processing, the new Freight Taxable field on the organization record, when selected, sets the Taxable flag on the freight distribution detail line. Tax is not calculated unless a line amount is provided.

To automatically calculate sales tax on freight charges, select the field Freight Taxable on the organization record's AP Information panel (Figure 9, red box).
The path to the organization record is: Materials main Contents > Tables > Organization > edit.

Notes

Invoices

In calculating taxes for invoices, the system first looks at the vendor AP location record for tax information.

Receipt exceptions

Inter-organization transfers

In the case of inter-organization transfers, the system creates the General Ledger transaction for the transfer of tax expense. This happens even if the GL accounts for the two organizations are the same. This way, the GL entry can be tracked.

The tax liability is not transferred, however. If tax processing is enabled for Materials Management, tax liability for an item is recorded when the receipt for the item is processed. The tax liability, therefore, remains in the original organization, since that organization pays the invoice and records the tax liability offset.

Process Flow for Determining the Applicable AP Tax