The Kinect Effect and Kinect Star Wars: Duel
Another off topic post, but one that shows lots of potential for many applications. The Kinect was originally created for use with the Xbox 360, but has now found its way into many other applications
February 6, 2012 · 
David Musgrave · 
No Comments
Tags: Customizations, dynamics, fun, security, Smartlist Builder, support debugging tool, upgrade, windows · Posted in: Blogs I Follow Total Views: 1
How to change SQL Collation for SQL Server 2008 R2
Have you ever been in a situation where you wanted to change the SQL Collation to match SQL Database Collation?? Last year I have posted a script that resolves this for SQL Server 2005, but the same syntax is not applicable for SQL 2008 R2, while investigating this I found the correct syntax that need to be used as below: ” E:SQLsetup.exe ” /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME= MSSQLSERVER /SAPWD= P@ssW0rd /SQLCOLLATION= Arabic_CI_AI /SQLSYSADMINACCOUNTS=” DAOUD-PCDAOUD ” E:SQLsetup.exe will need to be replaced with the locations of the SQL Server 2008 R2 setup.exe path. MSSQLSERVER represents the default instance, if you have a named instance this must be changed to hold the instance name
February 4, 2012 · · No Comments
Tags: Analytical Accounting, auto, colleague, Customizations, development, fun, knowledge, sql server, sql server 2008, virtual · Posted in: Blogs I Follow Total Views: 2
Down Under
˙ɐıןɐɹʇsnɐ ɯoɹɟ sıɥʇ buıʇsod ɯɐ ı ˙uǝǝɹɔs ɹnoʎ ɥʇıʍ buoɹʍ buıɥʇou sı ǝɹǝɥʇ ‘ʎɐʞo sʇı More updates to follow once I get accustomed to reading and posting from here. Posted from – Perth, Feb 2012.
February 4, 2012 · Jivtesh Singh · No Comments
Tags: Analytical Accounting, Customizations, development, dynamics, extender, georgia, great plains, jivtesh-singh, management, support debugging tool, technology, upgrade · Posted in: Blogs I Follow Total Views: 4
Microsoft Dynamics Convergence 2012 Houston Sessions
It is now February and Converegence 2012 Houston is happening next month (March 18-21). If you are not registered to attend yet ….. why not
February 3, 2012 · David Musgrave · No Comments
Tags: conference, Customizations, Dex.ini, Dexterity, dynamics, extender, security, Smartlist Builder, sql server, support debugging tool, upgrade, windows · Posted in: Blogs I Follow Total Views: 4
Microsoft Dynamics Convergence 2012 Houston Videos
Microsoft Dynamics Convergence 2012 in Houston on March 18-21 is getting closer by the day. Here are some videos to get you in the mood.
January 30, 2012 · David Musgrave · No Comments
Tags: Customizations, Dex.ini, Dexterity, dynamics, extender, integration, news, Smartlist Builder, support debugging tool, windows · Posted in: Blogs I Follow Total Views: 16
Vendor Statement with Analytical Accounting Information
one of my clients is a constructions firm whose not interested to activate the project accounting and wanted to distribute their project management over analytical accounting dimensions. Therefore we have implemented Dynamics GP and created dimension for projects to distribute all expenses accounts of analytical accounting codes. One of their requirements been to have a vendor statement per project which is reasonable for such a line of business, therefore I have created the below view that extracts the information including from AP, GL and AA and wanted to share the idea to avoid reinventing the weel for people who works with the same situation, below is the script I used: DECLARE @FROMDATE DATETIME DECLARE @TODATE DATETIME DECLARE @FROMVENDOR VARCHAR ( MAX ) DECLARE @TOVENDOR VARCHAR ( MAX ) SET @FROMDATE = ’1900-01-01′ SET @TODATE = ’2017-04-17′ SET @FROMVENDOR = ‘ACETRAVE0001′ SET @TOVENDOR = ‘BLOOMING0001′ SELECT ‘Beginning Balance’ AS TRXSOURCE , @FROMDATE AS DOCDATE , ‘Beginning Balance’ AS DOCNUMBER , VENDORID , SUM ( CREDIT ) AS CREDIT , SUM ( DEBIT ) AS DEBIT , VENDNAME , ‘Beginning Balance’ AS VCHRNMBR , ‘Beginning Balance’ AS TRXDESC , 0 AS JRNENTRY , 0 AS aaGLHdrID , aaTrxDimCode , aaTrxDimCodeDescr , ” AS LOCNCODE FROM ( SELECT DISTINCT VENDORTRANSACTION .
January 29, 2012 · · No Comments
Tags: auto, credit, Customizations, downloads, facebook, integration, security, utilities · Posted in: Blogs I Follow Total Views: 14
Before Yearend Closing Check – Retained Earnings Exception Report
It has been long time since I been an active online community member as before, as the day has only 24 hours and is really not enough for 45 customers with many GP issues, offline contribution, online community activities, my masters , family, and fun time!!! However, I am doing my best to recover and follow up with all these! As a start, I wanted to share one thing to be included in your checks before closing your financial year, if you have several currencies linked to your profit and loss accounts, you will need to make sure that all these currencies are linked to the retained earnings account, so the multicurrency management module can work this with no issues. If you forgot to do so, the system will generate the accounts along with the currencies not linked to the Retained Earnings in a report called “Retained Earnings Exception Report” and the report will be printed automatically. Nothing to be done from your side at this point as the system will affect the retained earnings with the amounts, but you need to validate your profit/loss balance and make sure that the RE account affected correctly
January 29, 2012 · · No Comments
Tags: Analytical Accounting, books, Customizations, facebook, integration, Inventory, management, Multicurrency, reporting · Posted in: Blogs I Follow Total Views: 14
Failed eConnect document leaves orphaned records
I assisted on an eConnect incident today that was quite interesting and I thought I’d share the case and the solution.
January 27, 2012 · Patrick Roth · No Comments
Tags: Customizations, Dex.ini, dynamics, extender, security, Smartlist Builder, support debugging tool, upgrade, windows · Posted in: Blogs I Follow Total Views: 15
Off Topic: Australia Day 2012 Eat Lamb Campaign
Back in 2005, the Meat & Livestock Australia (MLA) organisation started a marketing campaign to encourage Australians to eat lamb on Australia Day (26 th January). They enlisted Sam Kekovich , ex Australian Rules Football player, sports commentator and media personality ( Wikipedia ), to promote lamb with his deadpan presentation of monologues. These monologues have lots of Australianisms in them and have been a funny and satirical (and sometimes controversial) way to promote eating lamb cooked on the bar-be-que (BBQ or “barbie”) on Australia Day as the Australian thing to do.
January 26, 2012 · David Musgrave · No Comments
Tags: Customizations, Dex.ini, dynamics, extender, integration, support debugging tool, upgrade, windows · Posted in: Blogs I Follow Total Views: 18
The Windows Phone $100 Challenge #smokedbywindowsphone
At the recent CES 2012 conference Ben the PC Guy ( @benthepcguy ) and the Windows Phone team setup a challenge. They would give US$100 to anyone who could perform and everyday action on their non Windows Phone faster than Ben could on his HTC Titan Windows Phone. The challenges included tasks such as Taking a photo and posting it on Facebook Locating a nearby 4 star restaurant and finding directions Posting a status update onto multiple social networks Texting to a friend Listening to a song and then identify it, download it and play it If the challenger wins they would get US$100.
January 25, 2012 · David Musgrave · No Comments
Tags: Customizations, Dex.ini, Dexterity, dynamics, extender, fun, news, security, Smartlist Builder, upgrade, windows, windows-phone · Posted in: Blogs I Follow Total Views: 20