Previous  Next          Contents  Index  Navigation  Glossary  Library

Using Sales Tax Rate Interface

Running Sales Tax Rate Interface

You must invoke the Sales Tax Rate Interface program from the Run Tax Rate Interface window to transfer sales tax records from the Receivables tax interface table into the Receivables tax location and tax rate tables.

Report Submission Parameters

Parameter Possible Values
Review or Upload Load All Data in Tax Interface
Load Changed Data Only in Tax Interface Table
Review Tax Interface Data
Print Format Print All Detail
Print Summary Only
Print Warnings in Detail
Senior Location Enter a value from the first segment of your Sales Tax Location Flexfield structure containing the sales tax rates you want to upload or review. For example, if your structure is State.County.City then you would enter the State that contained the rates you want to upload or review. If you leave this parameter null, all values are included.

Review or Upload

If you enter 'Load All Data in Tax Interface' for the Review or Upload parameter, the Sales Tax Rate Interface program loads all tax data from the tax interface table into the location and tax rates tables.

If you enter 'Load Changed Data Only in Tax Interface Table' for this parameter, the program only loads tax rows from the tax interface table which are different from the most recent data your sales tax feeder system supplied.

If you enter 'Review Tax Interface Data' for this parameter, the program prints the Tax Interface report without actually performing the upload to the location and tax rate tables. Use this to review the tax data in the tax interface table before or after you have submitted the Sales Tax Rate Interface program. If you use this method after invoking the Sales Tax Rate Interface program, the Tax Interface report shows the action that it performed on each row of the tax data in the tax interface table.

Choose 'Review Tax Interface Data' to review the tax rates of a particular location in the interface table before loading the records. In this case, enter 'Print All Detail' as your Print Format parameter value, and specify the senior location for which you want to review tax rates. You can then use SQL*Plus to update the tax rates for this location if they are not what you require.

Print Format

If you enter 'Print Summary Only' as your Print Format parameter, the Tax Interface report includes a summary of the actions that the Sales Tax Rate Interface program has performed on the tax data uploaded from the tax interface table. This summary includes each action code that the Sales Tax Rate Interface program used for the upload, the action code's description, and the number of rows on which the program executed each action.

These action codes are described in detail later in the Action Codes section of this essay.

If you enter 'Print Warnings in Detail' as your Print Format parameter, the Tax Interface report includes a summarized section that lists the program's actions, and a detailed section that lists lines from the tax interface table that the program identified with a warning action code.

If you enter 'Print All Detail' as your Print Format parameter, the Tax Interface report includes a summarized section that lists the program's actions, and a detailed section that lists each line that the program loaded and the action that was identified for it.

Senior Location

If you do not enter a value for the senior location parameter, the Sales Tax Rate Interface program lets you upload or review tax rows in the tax interface table for all senior locations. Use the list of values to select a specific location as your senior location value to upload or review only the tax rows for a specific location. If you are using one of the predefined Sales Tax Location Flexfield structures, the first segment of that structure will be your senior location.

See Also

Running the Tax Rate Interface Program

Tax Interface Report


         Previous  Next          Contents  Index  Navigation  Glossary  Library