Sales Tax tables

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (1)

soma 24,410 on at

Like (0)

Report

Please have a look on the below link.

www.fmtconsultants.com/.../CCH-Presentation.pdf

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

SOP10100 gets updated with the tax amount.

SOP10105 gets a record appended.

Was this reply helpful? Yes No
Verified answer

coquisalsa 2,725 on at

Like (0)

Report

SOP10100 – Unposted/Work Transactions (header)

SOP10200 – Unposted/Work Transactions (line detail)

SOP10105 – Sales Taxes Work and History

Was this reply helpful? Yes No
Suggested answer

Tim Foster 8,515 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks all ! I think I was missing The Sales/Purchases Tax Master TX00201 table.

Was this reply helpful? Yes No