Share
ReportWith the sales tax load utility provided by CCH to integrate sales tax, can anyone tell me which tables are being updated?
*This post is locked for comments
You’re offline. This is a read only version of the page.
With the sales tax load utility provided by CCH to integrate sales tax, can anyone tell me which tables are being updated?
*This post is locked for comments
Thanks all ! I think I was missing The Sales/Purchases Tax Master TX00201 table.
I have no experience with CCH. I do know something about Sales taxes (living in Canada helps with that). The other responses provided previously are correct if the CCH tax engine over-rides normal Dynamics GP tax processes. If the CCH product creates Dynamics GP Tax Schedules and Details and continuously updates them, then the following might help you.
If you are in Microsoft Dynamics GP and from the menu click Microsoft Dynamics GP >> Tools >> Setup >> Company >> Tax Details. What do you see when you click on the Magnifying Glass next to Tax Detail ID? If CCH is loading your schedules and details, you will have a very long list indeed.
If you have SQL abilities, checking these tables:
Sales/Purchases Tax Schedule Header Master - TX00101
Sales/Purchases Tax Schedule Master - TX00102
Sales/Purchases Tax Master - TX00201
If the CCH product updates it's own tables you will have to discover that for yourself.
Tim
SOP10100 – Unposted/Work Transactions (header)
SOP10200 – Unposted/Work Transactions (line detail)
SOP10105 – Sales Taxes Work and History
SOP10100 gets updated with the tax amount.
SOP10105 gets a record appended.
your response did not answer the question as to which tables are being updated during the upload process. We are already using CCH and the link you posted seemed just be a promo for them.
Please have a look on the below link.
www.fmtconsultants.com/.../CCH-Presentation.pdf
Hope this helps!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (