Setting Up Materials Tax Information in Materials Management Version

Contents

This topic discusses:

Links to related topics:

Search Online Doc
Current Release Notes

Overview

The Materials Management Tax feature allows you to apply estimated state, city, and county taxes to requisitions and purchase orders. The Materials Management 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 materials 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.

When materials tax is calculated and an invoice is sales taxable, a debit entry to the Tax Liability account is created when the invoice is approved. When materials tax is calculated and an invoice is use taxable, no entries are created for either the Tax Expense Account or Tax Liability Account. (Materials tax is calculated when the field Calculate Tax For Materials Transactions on the Organization record is selected.)

This topic describes the setup steps and summarizes how use the tax feature in Materials Management.

Security

To work with any asset location, the asset location must be included in your data profile. Additionally, you must have permission to modify records for the asset location. See "Restricting Users from Editing Asset Location Records."

The ability for any user to view, change, and create values in tables is controlled by the role object "Tables." The security setting to create or copy an organization must be Create, or All. To edit an existing organization record, the setting must minimally be Modify.

The ability to create or edit asset locations is controlled by the role object "MMTables." To create or copy an asset location, the minimum setting is Create.

See Work with user roles for details on roles and role objects.

Requisitions and Purchase Orders

The system calculates estimated sales tax amounts when requisitions or purchase orders are created. Tax amounts are calculated using the actual line amount, and then summed for the entire requisition or PO.

How the Current Tax Rate is Retrieved

A general discussion of how ERP retrieves the correct tax rate is below. Here is a summary.

Requisitions

Note: The supplying asset location and supplying organization on the requisition may be different from the Department's default supplying asset location and default supplying organization.

Purchase Orders

Receipts

Issues

Setup Checklist and Summary of Steps

Estimated tax costs for a taxable item are calculated when requisitions and purchase orders are created.
– The system keeps the taxable status of items for all asset locations within a taxable organization synchronized. If you change the taxable status of an item, the system sends a message warning that the change will affect all asset locations.
– The tax expense for inventory adjustments is calculated when an item is designated as taxable.

Set Up Materials Tax for an Organization:

  1. From the Materials Management main Contents, select Tables > Organizations. A list of organizations appears.
  2. Locate the organization on the list. Click the edit icon (), or select Menu > Edit.
    The Organization edit panel appears.
  3. On the Main tab, select the box labeled Calculate Tax For Materials Transactions.
  4. If you want Materials Tax to print on purchase orders for taxable items, select Print Tax on Purchase Orders. (Figure 1).

Figure 1 - Edit / Create an Organization Main Panel

Figure 2 - The Taxable Flag Set by Default on a Requisition's Non-File Line

  1. Click the Sales Tax tab to display the Sales Tax panel (Figure 3).
    The Sales Tax panel defines an organization's defaults.

Figure 3 - Organization Sales Tax Panel

  1. Enter information in the fields on the Sales Tax panel as needed.
  1. When you have finished entering information, click Save.

  2. Click Submit. You are returned to the Organizations list.

Set Up Materials Tax at the Departmental Level

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, the invoice may be out of balance when it is created. For example, a hospital in Sacramento orders supplies to be shipped directly to a department that is located in San Diego. The application calculates the tax at the organization level (Sacramento), but the vendor has calculated the tax at San Diego because that is where it it is sending the order.

You can set a tax rate for a department or an asset location, and require tax to be calculated at the department/asset location rate in situations where the jurisdiction for the department (or asset location) is different from the organization, and tax is different.

Department-level tax is only calculated for departments with the Separate PO field set to "yes." The Taxable field for non-file items defaults to "selected" when the department requires tax, and also requires Separate PO by Department.

To enter tax data for a department:

  1. From the Materials Management main Contents, select Requisitioning > Departments. A list of departments appears.
  2. Locate the department of interest on the list. Click the edit icon (), or select Menu > Edit.
    The Department edit panel appears.
  3. On the General tab, select the box labeled Calculate Tax For Materials Transactions. (Figure 4, red arrow).
    Note: The initial setting of this field (for new departments, and at implementation) matches the setting of the same field on the Organization record.

Figure 4 - Setting the Materials Tax Flag for a Department

  1. Select the Sales Tax tab to display the Sales Tax panel (similar to Figure 3).
  2. Enter information in the fields on the Sales Tax panel as needed. You may enter State, City, or County tax rates and accounts. The default value of these fields is "blank."
  3. When you have finished entering information, click Submit. You are returned to the Departments list.

Set Up Materials Tax at the Asset Location Level

In situations where a medical center handles ordering in one jurisdiction for asset locations in different jurisdictions, you can define tax at the asset location level consistent with tax rates locally.

Figure 5 - Setting the Materials Tax Flag for an Asset Location

To display tax data for an asset location:

Note: You cannot edit an asset location record unless your data profile contains the asset location. You must also have permission to maintain the asset location. See "Restricting Users from Editing Asset Location Records."

  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. On the Main tab, select the box labeled Calculate Tax For Materials Transactions. (Figure 5, red arrow).
    Note: The initial setting of this field (for new asset locations, and at implementation) matches the setting of the same field on the Organization record.
  4. Select the Sales Tax tab to display the Sales Tax panel (similar to Figure 3).
  5. Enter information in the fields on the Sales Tax panel as needed. You may enter State, City, or County tax rates. Default accounts are populated by ERP.
  6. When you have finished entering information, click Submit.
  7. Click Submit. You are returned to the Asset Locations list.

Set Up Tax for Vendor Buy-From Locations

A vendor buy-from location can also be assigned tax data.

To enter tax data for a vendor buy-from location:

  1. From the Materials Management main Contents, select Vendors > Vendors.
  2. On the Quick Click menu, select Buy From Locations.
  3. Enter the Vendor Name in the box and click Go.
    The buy-from locations for the vendor appear.
  4. Next to the buy-from location of interest, select Menu > Sales Tax.

    If tax information exists for Materials Management, the Sales Tax Rates list appears.
    This list shows each organization for which tax data are established for the vendor buy-from location.
    - Click the edit icon or select Menu > Edit next to an organization to edit sales tax data.

    If no tax rates are established for any organization, No Data appears.
    - Click New. The Buy From Location Sales Tax edit panel appears, similar to Figure 3.
  1. Select the Organization from the prompt.
  2. Select the appropriate Tax Rate Code for State, City, and/or County, as appropriate, from the prompts.
  1. When you have finished entering information, click Save.
  2. Click Submit. You are returned to the Sales Tax Rates list.
  3. Click Refresh to see the organization and the rates listed.

Order of Processing Materials Tax

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

Purchase Orders - No direct delivery

Purchase Orders - With direct delivery

How ERP decides if a non-file line on a PO is taxable

Tax is calculated at the department level only when the Separate PO by Department is specified for the department's PO.
Separate PO by Department = Yes, and...
- Calculate Tax for Materials Transactions for the department is Yes (checked): the Taxable field defaults to enabled for non-file purchase order lines. (Figure 6 displays the Taxable field on a non-file PO line edit panel.)
- Calculate Tax for Materials Transactions for the department is No (not checked): the Taxable flag defaults to disabled for non-file PO line edit panel.

Figure 6 - The Non-File Edit Line on a Purchase Order

Requisitions

- Stock items: Requisition's supplying asset location > supplying organization
- Non-stock, non-file, or direct delivery items: Primary Vendor Buy From Location > Department > Asset Location > Org

How ERP decides if a non-file line on a requisition is taxable

Figure 7 - The Non-File Edit Line on a Requisition

To specify that an item is subject to tax:

  1. On the Current Settings, set the Asset Location field to the correct asset location.
  2. From the Materials Management main Contents, select Inventory > Item Inventory.
  3. On the Quick Click menu under I would like to..., select Edit.
  4. Enter the item number in the Item No box and click Go. The Item Inventory edit panel appears (Figure 8).

Figure 8 - Item Inventory Edit Panel

  1. On the Item Definition tab, in the right column, select the Taxable box.
  2. Click Save or Submit. You get a message such as:

Warning! Changing the item's "Taxable" status also changes the taxable status for this item in all Asset Locations for Organization [name of organization]. Press OK to continue and change item(s), or CANCEL to return.

  1. Click OK if you wish to continue. The taxable status of the item is changed.

Notes

If an item is designated as taxable, the system calculates the tax expense for...

The tax liability for taxable items on a purchase order receipt equals the inventory transaction's Adjusted Value times the current tax rate, using the rules for determining the tax rate. The system debits the Sales Tax Expense account(s) and credits the Sales Tax Liability account(s). The actual tax liability for a purchase order line can be different from the estimated tax liability if the tax rate, or tax status of the item or organization has changed.

For organizations that use receipt exceptions, the system calculates the actual tax liability only when a receipt exception is cleared.

Similarly, for invoice exceptions, the system calculates the tax liability when invoice exceptions for a PO are cleared, and adjustment receipts are processed.

In the case of inter-organization transfers, the system creates the General Ledger transaction for the transfer of tax expense, 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. 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.

If the source and target asset locations have different tax rates, the system uses the source asset location's tax rate(s).

For credit purchase orders, the system determines if the organization and item are taxable, and reverses the tax liability General Ledger accounts, as follows:

– The system calculates the estimated taxes, according to the process outlined previously.

– The system creates general ledger transactions for the reversal of the tax liability by crediting Sales Tax Expense accounts and debiting Sales Tax Liability accounts.

Process Flow for Determining the Applicable Materials Tax