Regenerate Sales Taxes, Sales Tax Effective Dates, and Mass Modify Taxes

Sales Tax rates change periodically, even sometimes in the middle of a calendar year. If you have saved Sales Order, Receivable, or Purchase Order Invoice transactions, simply changing the tax rates will not update these saved transactions. Running the Regenerate Sales Taxes routine saves you from having to rekey lines to recalculate sales taxes.

The utility is found on the Administration page in GP under Utilities then Company then  Regenerate Sales Taxes.

Let’s look at the details that are part of Tax Schedule ID USASTCITY-6* and their calculated amounts on saved sales documents.

I updated the two tax details that are on that schedule.

We can run the Regenerate Sales Taxes Utility now. We will run it only for Sales Order documents for now.

Do not skip taking a backup first.

You will get a listing of those sales line items that were updated.

Let us look at the results and changes to Tax Schedule ID USASTCITY-6*

You can dig much deeper and use Effect Dates for Taxes.

To activate, mark Use Date-effective Tax in the Company Setup. Choose either Document Date or Posting Date upon which to calculate sales taxes.

To use Date-effective Tax dates, click the Date Effective Tax Rates in the Tax Detail window.

Finally, use Mass Modify Taxes to mass modify a range of tax details and effective dates.

Select what we want to Modify, either details, effective dates, or both.

Enter a range of Tax Details and click insert. If the range includes details that do not need to be updated, right-click the detail row and choose Delete Row.

Use the Regenerate Sales Tax Utility after Effective Dates and Mass Modify.

Ready to Grow your business with Dynamics 365 Business Central?

If you need help migrating from existing systems or maximizing your onboarding success, TruNorth Dynamics can help you adapt Dynamics 365 applications and services for your organization. Our extensive services, centralized project management, and expert consultants simplify your business transformation as a Microsoft Certified Gold Partner in Dynamics. We can help you make the right choices about business solutions, develop the processes that best support your goals, and roll out smoothly across your entire organization. Contact us today to start your Dynamics journey.

TruNorth Dynamics can assist you in maximizing the capabilities of Dynamics 365 and other Microsoft apps by examining the specific requirements of your company, customers, and workers. To get started, get in touch with our Dynamics 365 team today.

Learn more about D365 Business Central

Go to Top