Previous  Next          Contents  Index  Navigation  Glossary  Library

Sales Tax Rate Date Adjustments

The Sales Tax Rate Interface program adjusts the active date ranges of existing tax rates to ensure that they do not overlap with incoming tax rates for a location. For example, if an incoming sales tax rate for a location has start and end dates that overlap the active date range of an existing rate, then the Sales Tax Rate Interface program adjusts the active date range of the existing rate so that its active period does not overlap the date range of the incoming rate.

The following diagrams indicate how the Sales Tax Rate Interface program inserts new tax rates and updates the active date range of existing tax rates. Each diagram shows the action code associated with the type of rate date adjustment that the Sales Tax Rate Interface program performs.

In Figure 1 - 29, when the Sales Tax Rate Interface program has assigned an action code of 'UPDATE-INSERT' to a new tax rate record, it has updated the existing tax rate by assigning it an end date immediately before the start date of the new tax rate. The program then inserts the new sales tax rate into Receivables.

In Figure 1 - 30, when the Sales Tax Rate Interface program has assigned an action code of 'IGNORE' to a new tax rate record, it has ignored the new tax rate because it cannot determine either an end date for the existing rate, or a start date for the new rate. Therefore, the existing tax rate remains unchanged.

In Figure 1 - 31, when the Sales Tax Rate Interface program has assigned an action code of 'IGNORE' to a new tax rate record, it has ignored the new tax rate because it cannot determine an end date for this rate. Therefore, the existing tax rate remains unchanged.

In Figure 1 - 32, when the Sales Tax Rate Interface program has assigned an action code of 'RATE-ADJUST' to a new tax record, it has replaced an existing tax rate with a new rate for the same location and active date range. You can either accept this new rate, or update it manually through the Tax Locations and Rates window in Receivables.

As you continually update your tax rates using the Sales Tax Rate Interface program, you will store different tax rates for the same location that have mutually exclusive active date ranges. Figure 1 - 33 shows how Receivables will record different tax rates for a location as you update its rates over time.

See Also

Running the Tax Rate Interface Program

Action Codes of Sales Tax Rate Interface


         Previous  Next          Contents  Index  Navigation  Glossary  Library