SQL Store for Taxes on Posted Invoices

[TheMitelGuy]

I understand the name of the taxes is not really important, but does anyone know which table GP stores the taxes for POSTED INVOICES? I can't seem to find it, and just need to pull it out to print on our invoices.

Thanks so much!

 

[winthropdc]

Are we talking RM, PM, SOP, POP or Invoicing?

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[TheMitelGuy]

SOP

 

[VictoriaYudin]

For SOP the Sales Transaction History Table (SOP30200) has the taxes.

Victoria Yudin
Dynamics GP MVP 2005 - 2008
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

 

[TheMitelGuy]

You are correct that SOP30200 does store the taxes - however it stores the values of two taxes (GST and PST) as a single value (GST + PST). I need the values separated and do not want to do the calculations in Crystal Reports. There has to be a table somewhere in GP that has one line stored with the invoice number and GST and another line with the same invoice number and PST.

 

[VictoriaYudin]

Ah! I see what you're asking now. Try TX30000.

Victoria Yudin
Dynamics GP MVP 2005 - 2008
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

 

[chuito7]

The SOP30200 stores the total tax, the detail of each tax detail is stored in SOP10105.

Jesus M. Cruz Narvaez
Senior IT Consultant
JT Consulting Group, Inc.
jesus@jtconsulting.com

 

[TheMitelGuy]

Found it - it's in the TX30000 field.

 

[VictoriaYudin]

Yep, that will work too forgot about that one.

Victoria Yudin
Dynamics GP MVP 2005 - 2008
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

 

[TheMitelGuy]

Ops, thanks for the info. I think I found it at the same time you were telling me where to go.

Thanks so much.