Collections

Collections are records with multiple linked taxes that you can link to transaction codes.

From the Configuration main menu, select Taxes and then select Collections. In this section, you can:

• Define Collections

• Link Taxes

• Define whether to support a full reverse calculation from gross to net.

By default, you can view all collections. The blue badge next to the collection indicates the number of taxes linked to the collection. The gray badge next to the blue badge indicates the inactive collections. Expand a collection to view the linked taxes. The warning image in front of a collection and tax indicates that this record does not support the full reverse calculation from gross to net, no matter if the general setting is active.

Updating General Settings to Support Full Reverse Calculation from Gross to Net

By definition, a tax calculation is always from net to gross. Depending on the configuration, it is sometimes not possible to calculate a reversal from gross to net. If you enter only gross values and want to ensure that a reverse calculation is always possible, activate the setting and only a valid configuration can be configured.

• Select the Actions button at the top of the screen and then select Update general settings.

• Select the Support full reverse calculation from gross to net check box to enable the service.

• Click Update.

• If collections exist that do not support the full reverse calculation from gross to net, an option to correct the collections appears.

• Select Correct records and all collections that do not support full reverse calculation are listed. Correct the records and update the general setting again. For more information, see: Linking Taxes below.

  Note:

  This setting is also available on Taxes.

Managing Collections

Use the following to search for a collection:

• Code, Description, and Tax: Enter the code or name of a collection or tax.

• Support full reverse calculation from gross to net: Select one of the three options. The default setting is All.

Click Search to get search results. Only records matching all the selected criteria appear. Click Reset to reset the search data and get the default display.

Adding and Editing Collections

Select the Add Collection button in the Tool bar to create a record. Use the pencil or More Actions icon on the right-hand side of each record to edit a collection.

• Inactive: Select this check box to set the collection to inactive. You cannot set a collection to inactive if it is linked to transaction codes. A message warns you to unlink first from the transaction code.

• Code: Enter a short code to identify the collection quickly. This field is required.

• Description: Enter the description of the collection. This field is required.

Click Submit and then select either Submit to create the record or Submit and Add Another to continue creating records. Click Update to save your edits on existing records.

Note:

The More Actions icon with the options to Edit the collection, Link Taxes, or use the Tax Test Calculation appears as soon as at least one tax is linked. Otherwise, the Edit icon appears.

Linking Taxes

Use the following when linking taxes:

• The first time you link a tax, expand the Collection and select the Link Taxes button in the middle of the screen or, if at least one tax is linked, select the More Actions icon on the right-hand side of each record and then select Link Taxes to link additional taxes.

• The Taxes screen opens, and you can search for a specific tax category or tax or expand the categories and taxes to view all details.

• Select the Link to Collection icon on the right-hand side of a tax to link it.

• Define the following fields:

  • Calculation Order: Define the order of the tax. By default, the order is set accordingly, for example, suppose you have five taxes linked and the next one you link has, by default, order six. You can change the order, for example, place the new linked tax to order three, and the order will be re-calculated. A warning appears if the order is not valid. This field is required.

  • Calculation Type: Define the type: Net, Sum, Gross, or Tax of the calculation. This field is required. The first linked tax has the default type Net, and the field is read-only. If the setting Support Full Reverse Calculation from Gross to Net is active, only valid types are shown. This field is required.

  • Based on: Link to an existing tax. The tax can only be linked to one with a lower calculation order. The field is empty and read-only for the first linked tax. If the setting Support Full Reverse Calculation from Gross to Net is active, only valid taxes are shown. This field is required when the Calculation Type is Sum, Gross, or Tax.

• Click Link to return to Collections or click Link and Link Another Tax to stay on Taxes and link another record.

  Note:

  For the first tax you link or edit, the fields are read-only as the defaults are mandatory. You cannot change the order to a higher one than the one you want to change is based upon, for example, a tax with order three is entered as based on for tax with order five. In this case, you cannot change the tax with order three to nine. A warning appears.

Deleting Collections

Expand the collection and select the Delete icon on the right-hand side of each linked tax. A message provides you with the option to Keep or Delete the record.

Testing Tax Calculations

The tax test calculation quickly checks whether the calculation of your linked taxes is correct.

• Select the More Actions icon on the collection level and select Tax Test Calculation. For further information, see Taxes, Testing Tax Calculations section.

• In addition to the calculation on taxes, you can view the Total per Tax that shows the entered date range and the summary per tax.