Dynamics Community Forum Thread Details

Canadian Tax Question - Implementing HST

Hello everyone,

In Ontario, Canada as of July 1, 2010 we will be changing from having 2 taxes (GST & PST) to having 1 tax (HST). This raises the question of how to invoice quarterly recurring invoices to reflect the amounts that will need to use GST & PST and the amounts that will need to use just HST. For example, if we create an invoice in May for services from Jun 1 2010 – Aug 31 2010, then the invoice will need to reflect taxes being calculated using GST and/or PST for the month of June amount and HST for the month of July and August amounts. We are using MS Dynamics GP version 10. If anyone has any suggestions as to how to implement the change to HST into the quarterly invoices that span across the date the taxes get changed, they would be greatly appreciated!!

Thank you in advance!

Joanne

I would like to know how to update all our existing Quotes, Orders and Invoices with the new Tax Schedule.

Below is the SQL update we are planning on running after business day end June 30 2010.

The example below is for a Quote in our system.

---- Script: Tax Schedule Update---- Update RecordUPDATE SOP10100 SET TAXSCHID = 'S-HST' WHERE SOPTYPE = '1' and SOPNUMBE = 'TORQTE060630'UPDATE SOP10200 SET TAXSCHID = 'S-HST' WHERE SOPTYPE = '1' and SOPNUMBE = 'TORQTE060630' and TXSCHSRC = '2'UPDATE SOP10105 SET TAXDTLID = 'S-HST' WHERE SOPTYPE = '1' and SOPNUMBE = 'TORQTE060630'

Note: after update the Tax amount is incorrect however once the Quote or Order is transferred the amount is recalulated correctly.

Does anyone know how I can get the tax amount to recalculate without having to Transfer the Quote or Order?

Thanks

Quick Links