Microsoft Dynamics GP

Home » Microsoft Dynamics GP » Real Life Dynamics User (RLDU) » All Tags » SQL Scripts » Dynamics GP

Browse by Tags

Related Posts

  • Blog Post: SQL Scripts–Vendor Invoice Pricing Discrepancy

    Ron Wilson
    The following SQL Script will show you all Payables invoices that have been entered into your system where the price your vendor is charging does not match the price of your purchase order.  We use this, in conjunction with Task Centre, to alert us when a vendor has charged us more than what our...
    on 14 Sep 2011

  • Blog Post: SQL Scripts–SOP to POP Freight Analysis

    Ron Wilson
    The following SQL Script will show analyze the freight you charged to a customer versus the freight you were billed from you vendor provided there is a SOP to POP link between the sales order and purchase order. This question was raised in the Dynamics GP Community by JCohen: We are looking for a...
    on 13 Sep 2011

  • Blog Post: SQL Scripts–Invoices Coming Due Next Week

    Ron Wilson
    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 our aging process and past due invoices.  Our customers...
    on 12 Sep 2011

  • Blog Post: SQL Scripts–Order Count–YTD By User

    Ron Wilson
    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 current year*** This script uses the following views...
    on 5 Sep 2011

  • Blog Post: SQL Scripts–Order Count–Previous Week By User

    Ron Wilson
    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 January 1st of the current year*** This script uses the...
    on 1 Sep 2011

  • Blog Post: SQL Script – Standard Cost Less Than Valuation Cost

    Ron Wilson
    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. When our vendor sent us our updated price sheet, we imported...
    on 22 Apr 2011

  • Blog Post: SQL Script – Default Item Class GL Accounts

    Anonymous Anonymous
    Have you ever need to take a look at what your Item Class General Ledger accounts are, but didn’t want to go through them one at a time?  Here is a helpful little script that will allow you to see all Item Classes and what GL accounts are populated in the “Item Class Account Setup” screen. It...
    on 22 Jun 2010

  • Blog Post: SQL Scripts – Clear Users and Activity Locks

    Anonymous Anonymous
    Often times, when needing to perform maintenance in GP, your users will be logged out but GP still thinks they have documents open, batches they are working in, etc.  This script will clear out off the user activity locks as well as their logins. ***This will remove ALL users from being logged...
    on 18 Jun 2010

  • Blog Post: SQL Scripts – Purchase Order Line Item Discrepancy

    Anonymous Anonymous
    The following script will compare all open purchase order line item pricing with the standard cost of the item on the Item Card in GP .  This is useful to monitor if people are purchasing inventory for more than what you are selling it for. For example: I have a widget setup with a cost of $100...
    on 19 May 2010

  • Blog Post: SQL Scripts – Stock Count (Multibin Inventories)

    Anonymous Anonymous
    The following script will return a result set that can be exported (or copy and pasted) to Excel, for an easy to use stock count sheet for multibin inventory GP environments.  I have a SQL Reporting Services report written for our stock count sheets that makes it even easier.   The script...
    on 22 Apr 2010

  • Blog Post: SQL Scripts – Inventory Valuation

    Anonymous Anonymous
    The following script will take a look at your inventory receipts table ( Inquiry->Inventory->Receipts ) and give you a summary, per item, of your inventory dollar valuation.  You can use this script in an SSRS or Crystal report to sum total your entire valuation of inventory by GL account...
    on 13 Apr 2010

  • Blog Post: SQL Scripts – SOP to POP Margin Analysis

    Anonymous Anonymous
    The following script will look at all open sales line items and purchase line items that are linked together and evaluate their margins.  The default script looks for margins less than 25% or .25.  You can change your percentage by change the @marginPct value in the SET command. The script...
    on 9 Apr 2010

  • Blog Post: From The Community #4 – Creating A Test Company

    Anonymous Anonymous
    A question in the Dynamics GP forums was posted on the following issue: “ We’re in the midst of our GP implementation. I would love to be able to copy a "production" (of course, we’re not really in production yet) company into a test company for testing and maybe training. Should...
    on 5 Apr 2010

  • Blog Post: Managing Outdated Inventory Pricing

    Anonymous Anonymous
    ***Warning*** This script has code that will update data in the Dynamics GP database.  While this is not “illegal” it may or may not be supported by Microsoft.  I have not had any issues with this in our environment, but make sure you test this in your non production environment first, before...
    on 26 Mar 2010