DynamicsGP.ie

July 2009 - Posts

• 0 Comments 610 Views

  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... Read More... Published: Thursday, July 30, 2009, 06:20 AM Tags: Dynamics, invntory, GP, Microsoft, update, decimal, Tips and Tricks, MSSQL

• 0 Comments 498 Views

  GP Logo’s Through the Years http://blogs.msdn.com/developingfordynamicsgp/archive/2008/07/29/gp-logos-though-the-years.aspx Read More... Published: Friday, July 03, 2009, 07:00 AM Tags: Dynamics, General, GP, logo, Microsoft

• 0 Comments 492 Views

  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... Read More... Published: Friday, July 03, 2009, 04:26 AM Tags: Dynamics, restore, recovery, disaster, back, backup, General, GP, Microsoft, up, maintenance, MSSQL, strategy

• 0 Comments 508 Views

  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... Read More... Published: Friday, July 03, 2009, 04:13 AM Tags: Dynamics, restore, recovery, disaster, back, backup, General, GP, Microsoft, up, MSSQL

• 0 Comments 497 Views

  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... Read More... Published: Thursday, July 02, 2009, 12:21 PM Tags: Dynamics, Inventory, GP, site, Microsoft, Tips and Tricks, MSSQL, value

• 0 Comments 457 Views

  Data Centre of the Future! This data center runs 24/7 with only a man and a dog. The man’s job is to feed the dog. The dog’s job is to make sure the man does not touch the computer. Read More... Published: Thursday, July 02, 2009, 07:21 AM Tags: General, Microsoft, data centre