web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :

Community blogs

Dynamics 365 Community / Blogs

Featured

Finance | Project Oper...
What I Have Been Up To Lately
Ron Wilson 6,010
Like (0)
Finance | Project Oper...
SQL Script – Standard Cost Less Than Valuation Cost
Ron Wilson 6,010
Like (0)
Finance | Project Oper...
SQL View–Sales Document Holds
Ron Wilson 6,010
Like (0)
Finance | Project Oper...
SQL Script – Orders Needing Purchase
Ron Wilson 6,010
Like (0)

Latest blog posts

View all
Like (0)
What I Have Been Up To Lately

Folks…I just wanted to update you on the status of the RLDU blog. It has obviously been pretty stagnant over the past couple of months. I recently received a big promotion at work and I am know the “Director of Operations” (big...

Ron Wilson 6,010
Like (0)
SQL Script – Standard Cost Less Than Valuation Cost

We recently had a vendor decrease pricing (yes…you read that right…DECREASE!!!!). While this is wonderful to see, it has cause a little bit of a problem for us. We use a product call SmartConnect to import and update items and pricing....

Ron Wilson 6,010
Like (0)
SQL View–Sales Document Holds

The following view shows all Sales Documents with active or inactive holds. This view is also a modification of the spvSalesDocumentHolds view from Salespad (www.salespad.net). You can name the view whatever you want by change the [tspvSalesDocume...

Ron Wilson 6,010
Like (0)
SQL Script – Orders Needing Purchase

So…you know that you had something that you needed to order for a customer, but you cannot remember what it is to save your life?  Well the following view will show you a listing of all open sales order with line items that need to be purcha...

Ron Wilson 6,010
Like (0)
SQL Scripts–Order Count–Previous Week By User

Do you ever wonder what your sales order workload looks like for you customer service staff?  This script will show you the number of orders entered by user for last week. ***Note that you will need to make sure the @doc_date is set to Januar...

Ron Wilson 6,010
Like (0)
SQL Scripts–Order Count–YTD By User

Following up on my last script, SQL Scripts–Order Count–Previous Week By User, this script will show you the number of orders entered by user for the current year. ***Note that you will need to make sure the @doc_date is set to January 1st of the ...

Ron Wilson 6,010
Like (0)
Packt Publishing–Dynamics GP 2010 Reporting

If you have some time, check out Dynamics GP 2010 Reporting from Packt Publishing.  This book will give you some great information with regards to reporting and Dynamics GP.  Whether you are looking to utilize the built in reporting too...

Ron Wilson 6,010
Like (0)
SQL Scripts–Invoices Coming Due Next Week

The following SQL View shows you all invoices that are coming due next week.  We use this view in conjunction with Task Centre to send out a list (fax or email) to our customers of invoices will be due next week.  This has really helped ...

Ron Wilson 6,010