Dynamics Tips

Pages

  • Home
  • GP
  • AX
  • SQL Server
  • Downloads
  • Partners

Oct 18, 2005

SQL Scripts

Posted by Venugopal G A @ 10:54 AM

1) SQL Procedure of search phrase on all Database
2) Backup All Database

3) Get inventory items with positive quantity-on-hand with latest corresponding invoice.

Email ThisBlogThis!Share to XShare to Facebook

Download Articles & Tools

Posted by Venugopal G A @ 10:18 AM

Articles & Tools

GP

  1. Great Plains® Architecture
  2. Microsoft Dynamics GP 2010 New Features
  3. Microsoft GP Inventory Year End Process

AX

  1. Microsoft Dynamics AX 2009 What's New
  2. Microsoft Dynamics AX 2009 Keyboard Shortcuts
  3. Microsoft Dynamics AX 2009 Development With Visual Studio .Net

Tools

  1. All Purpose Worksheet (Conversions)
  2. Income Tax Calculator F.Y. 2009-10
Email ThisBlogThis!Share to XShare to Facebook
Newer Posts Home
Subscribe to: Posts (Atom)

About Me

Venugopal, PMP

Support

  • Dynamics GP Support

Search

Labels

AP (1) AX (2) BR (2) CRM (1) DEX.ini (1) eConnect (1) Extender (1) FA (1) FRX (6) GL (1) GP (28) GP 2010 (21) GP 2010 R2 (2) GP 2013 (7) GP 2015 (4) GP 2018 (2) GP Scripts (10) GP2010 (4) GP2013 (3) Management Reporter (2) MR (4) MR 2012 (3) Office 2010 (1) Smartlist (1) SQL (5) SQL Server (3) tenfold (1)

Blog Archive

  • ►  2024 (2)
    • ►  Jan (2)
  • ►  2022 (4)
    • ►  Dec (4)
  • ►  2018 (4)
    • ►  Jul (4)
  • ►  2015 (2)
    • ►  Mar (2)
  • ►  2014 (14)
    • ►  Dec (4)
    • ►  Sep (1)
    • ►  Aug (3)
    • ►  Jul (1)
    • ►  Mar (4)
    • ►  Jan (1)
  • ►  2013 (10)
    • ►  Aug (2)
    • ►  Jul (7)
    • ►  Apr (1)
  • ►  2012 (1)
    • ►  May (1)
  • ►  2011 (10)
    • ►  Sep (2)
    • ►  Aug (1)
    • ►  May (1)
    • ►  Apr (6)
  • ►  2010 (33)
    • ►  Dec (1)
    • ►  Nov (1)
    • ►  Oct (3)
    • ►  Sep (2)
    • ►  Aug (19)
    • ►  Jul (7)
  • ►  2009 (4)
    • ►  Dec (2)
    • ►  Oct (2)
  • ▼  2005 (2)
    • ▼  Oct (2)
      • SQL Scripts
      • Download Articles & Tools

Mobile App

Mobile App
Now get updates from Dynamics Tips on your Android mobile

Popular Posts

  • Microsoft Dynamics AX Architecture
    Understanding the internal architecture of Microsoft Dynamics AX can help you make decisions when planning and developing a Microsoft Dynami...
  • AA Transaction Error – Primary Key Voilation
    There are quite a few errors comes in AA which are not highlighted in the knowledge base articles. Transaction dimensions can't able t...
  • SQL Query to get Field names as Records
        At times you may need to have the SQL table column names in runtime for your various reasons, below is the simple query to get the colu...
  • Management Reporter 2012 - How to Clear Report Queue?
    It is often noted that after generating report Management Reporter 2012 keeps the logs of the same and during the course these are piled u...
  • Layers in Microsoft Dynamics AX 2009
    Layers are a hierarchy of levels in the application source code that enable you to make modifications and additions without interfering wit...
  • Management Reporter 2012 - How to Delete Report Queue Manually?
    All the Report Process are stored in the Management Report Database under the table " Repository ". To manually remove reports t...
  • SQL : Useful DateTime Queries
    ----Today SELECT GETDATE() 'Today' ----Yesterday SELECT DATEADD(d,-1,GETDATE()) 'Yesterday' ----First Day of Current ...
  • Adding Extender fields to a Great Plains Report
    Adding an Extender Window field to a Great Plains report is a simple process of adding a calculated field to the report. Before you add a fi...
  • Dynamics Management Reporter
    Management Reporter is a specialized financial reporting solution that allows users to create powerful reports in minutes. This application...
  • SQL Script to Assign ALL ITEMS IN THE ITEM CLASS to a given Vendor in Microsoft GP
    ------------------------------------------------------------------------- -- Assign ALL ITEMS IN THE ITEM CLASS to a given Vendor -- ...

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

Blogger templates

Share | |
Venugopal G A @ 2009-2014. Theme images by Dizzo. Powered by Blogger.