Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dynamics SQL question RE Statement Aging
Thanks for the reply. The company had two large GP consulting firms say that there was no way to create the statement like the company wanted in GP. I was able to create the statement like they wanted in the Access report writer. I have figured out how to accurately calculate the balance brought...- ckelsoe
- Post #3
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Dynamics SQL question RE Statement Aging
I have created a custom statement in Access. I am using RM00101 for Customer data, RM00103 for aging and balance information, RM20101 for open transactions and RM30101 for transaction history. Based on those tables, I am accurately (except for NSF cases) creating statements. In addition, I am...- ckelsoe
- Thread
- Replies: 3
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Nested Query Help Needed
Thanks. I figured that out. I was overcomplicating the problem when a well designed sql statement like yours was the solution. I appreciate the help.- ckelsoe
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Nested Query Help Needed
Hi, I have the following scenario that I am not sure how to best tackle. Any advice or examples is appreciated. I am creating a stored proc that requires a code to be passed to it. In return data gathered from 3 different tables will be returned. The big catch is that 1 of the tables resided in...- ckelsoe
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
