SQL Queries

• 07-17-2008 8:59 AM

  GPDynamics Joined on 07-17-2008 Posts 1

  SQL Queries Reply Contact Would be curious if anyone has SQL queries for various reporting functions.  I would be willing to share Excel tools (to be published to SharePoint) developed from such queries.  For example, I need  Sales Tax report   Column Headers are:  Transaction Date, Tax Detail ID, Tax Detail Description, Tax %, Doc #, Cust ID, Cust Name, Total Sales, Sales Tax, Tax Amt   I would also like to discuss improving queries already developed.   Thanks! Any assistance would be appreciated.   Michael

  Tags: Dynamics GP, SQL Queries

• 07-25-2008 10:29 AM

  In reply to

  Scott Sparrow Joined on 03-14-2008 MA Posts 9	Re: SQL Queries Reply Contact I have quite a few SQL queries that we use for various items on our intranet. Feel free to contact me directly about your needs Scott

• 07-29-2008 6:54 AM

  In reply to

  Brian Babyok Joined on 07-29-2008 Posts 2	Re: SQL Queries Reply Contact I'm trying to find the table/field names for the Trx Date and Apply Date from the Applied From Credits screen (Receivables Transaction Inquiry). Any help?

• 07-29-2008 6:58 AM

  In reply to

  Scott Sparrow Joined on 03-14-2008 MA Posts 9	Re: SQL Queries Reply Contact For historical transactions try the RM30201 table.

• 07-29-2008 7:25 AM

  In reply to

  Brian Babyok Joined on 07-29-2008 Posts 2	Re: SQL Queries Reply Contact That was it, thanks Scott!