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

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
News and Announcements icon
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