DynamicsGP.ie

Browse by Tags

• (45)
• aagGetComppanyStatus
• adjust costs
• back
• backup
• binary
• case insensitive
• collation
• costs
• Creditor
• Customer
• Debtor
• decimal
• disaster
• Dynamic
• Dynamics
• express
• express edition
• General
• GP
• Ian Stewart
• Inventory
• invntory
• IV10200
• landed
• landed costs
• maintenance
• management studio
• Microsoft
• microsoft dynamics gp
• microsoft sequel server
• mssql 2005
• mssql express
• mssql2000
• msswl 2005
• receipt
• recovery
• restore
• Save Opertion
• site
• sort order
• sql
• sql 2005 express
• sql express edition
• sql server
• sql server management studio
• Stock
• Strange error messages
• strategy
• Supplier
• Tips and Tricks
• unit cost
• up
• update
• upgrade
• Upgrades
• value

• Implementing Landed Costs in mid stream

  Please be careful with this one. I’ve tested it thoroughly and can’t find an issue…but it does involve editing tables through SQL. It is possible that custom reports etc. that are taking data from different tables may not like these... Published: Sunday, March 07, 2010, 10:44 AM Tags: Dynamics, Tips and Tricks, GP, Microsoft, MSSQL, Inventory, adjust costs, unit cost, receipt, Stock, IV10200, landed, costs, landed costs

• A Save operation on table GL_Account_MSTR (45) & Dynamics.dbo.aagGetCompanyStatus…when trying to add a new GL account code

  To resolve, install a fresh instance of GP on a different mchine and choose to install Analytical Accounting. Then run utilities, added the sample company data (even though I don’t think this is required), and close out of utilities. Then go to... Published: Monday, January 18, 2010, 11:37 AM Tags: Ian Stewart, Tips and Tricks, GP, Strange error messages, MSSQL, Dynamic, Save Opertion, aagGetComppanyStatus, Creditor, Customer, Debtor, Supplier, (45)

• Updating Inventory Decimal Places through SQL

  Recently I had to do this. Always best to use standard functionality where available (Tools >> Utilities >> Inventory >> Change Decimal Places) ..but the following did the trick for a decimal increase… update iv00105 set decplcur... Published: Thursday, July 30, 2009, 06:20 AM Tags: Dynamics, Tips and Tricks, GP, Microsoft, invntory, decimal, update, MSSQL

• Test your back ups

  Actually happened: About 1988…Consultant to client ‘Okay, make a copy every day, and store in this folder’…hands over a lovely blue A4 folder with 30 floppy disks in nice plastic sleeves inside. Another consultant calls out because... Published: Friday, July 03, 2009, 04:26 AM Tags: Dynamics, GP, Microsoft, MSSQL, General, up, strategy, restore, maintenance, recovery, disaster, backup, back

• What to Back Up

  So ,what to back up in the first place. Use the SQL Server Maintenance Plan set up wizard, and finish by setting up a job schedule to run the back ups. All your individual company databases must be included for a start. But don’t forget the Dynamics... Published: Friday, July 03, 2009, 04:13 AM Tags: Dynamics, GP, Microsoft, MSSQL, General, up, restore, recovery, disaster, backup, back

• SQL Script to get Inventory Value by Site

  The following will return the value of inventory on hand in each site. Good for verifying modified reports are accurate. SELECT a.ITEMNMBR, b.ITEMDESC, a.LOCNCODE, a.QTYONHND, a.ATYALLOC, b.CURRCOST, CASE WHEN b.VCTNMTHD IN (1, 2) THEN isnull(c.Value... Published: Thursday, July 02, 2009, 12:21 PM Tags: Dynamics, Tips and Tricks, GP, Microsoft, MSSQL, value, site, Inventory

• MSSQL Collation for GP

  http://dynamicsgpblogster.blogspot.com/2008/08/microsoft-dynamics-gp-and-sql-server.html Published: Thursday, June 18, 2009, 05:58 AM Tags: microsoft dynamics gp, MSSQL, sql, case insensitive, sort order, binary, collation

• MSSQL Express – link to download not working on MS Sites

  I had to download this tool today, and try as I might I could not find a working link anywhere on Micosoft. Always got ‘Page Not Available’ errors. Found the app on Filehippo and downloaded it. Here’s the link. http://www.filehippo.com... Published: Friday, June 12, 2009, 06:11 AM Tags: MSSQL, sql server management studio, express edition, mssql express, sql express edition, express, management studio, sql 2005 express, msswl 2005

• Upgrading to MSSQL 2005

  If you’re looking to move from GP 9 to 10, MSSQL 2000 is not supported. If you’re not a fan of the big bang approach, then maybe you should consider moving to MSSQL 2000 first, and upgrade to GP 10 later. Users on MSSQL 7.0 need to be on service... Published: Thursday, April 02, 2009, 08:32 AM Tags: microsoft dynamics gp, MSSQL, sql, Upgrades, upgrade, microsoft sequel server, mssql 2005, mssql2000, sql server