FRx 6.7 SP11 Released

Some of the main benefits of SP11 are as follows

• Windows 2008 and Windows 7 will be supported now.
• FRx WebPort will be supported with Windows 2008 and Windows 7 and Windows Vista will still not be supported.
• Office 2010 will not be certified in this cycle. However, there was some limited testing and it does work. 64-bit version of Windows will still not be supported, Customers will have to use Virtual Machines.  A new feature in Windows 7 allows users to download Windows XP Mode. This is a new feature in Windows 7, available in Windows 7 Professional, Ultimate, and Enterprise, provides a licensed copy of Windows XP with Service Pack 3 in Virtual Hard Drive (VHD) format.  When installed with the proper integration components, it allows you to run Windows XP in its own virtual machine, separate from the host Windows 7 installation.  The location for the download and additional information about XP Mode is available at this URL: http://www.microsoft.com/windows/virtual-pc/default.aspx.
• The previous issues with percentage and dollar formatting using CS are resolved in this service pack, along with other fixes in the service pack listed in the Release notes.

Items Having Current Cost and No Movement

At time you want to audit the inventory items which are having Current Cost and no Movement (these items normally exist in GP during the migration process or upgrade process from the old system), below query gives you the list of such items in GP. The listed items are safe to delete from the system if they are not really required (delete at you own risk).

SELECT LTRIM(RTRIM(IV00101.ITEMNMBR)) as ITEMNMBR, IV00101.STNDCOST, IV00101.CURRCOST, IV00102.QTYONHND
FROM IV00101 INNER JOIN IV00102 ON IV00101.ITEMNMBR = IV00102.ITEMNMBR
WHERE    (IV00102.RCRDTYPE = 1) AND (IV00102.QTYONHND = 0) AND (IV00101.CURRCOST > 0)
    AND IV00101.ITEMNMBR NOT IN (select distinct(itemnmbr) from IV30300)
Come back for more tips ..... J

How to find installed Version of eConnect

I often use to get errors on eConnect whenever i deploy my integration on the client machine and hence thought of figuring out to fine the installed version of eConnect on client PC, after browsing through the documents and the database i was finally able to retrieve the version of eConnect installed.
Below is the script which gives the installed version of eConnect
exec DYNAMICS..taeConnectVersionInfoDYNAMICS
Run and execute the above script in SQL Query window, the SP retrieves three columns with DatabaseName, Version and CompanyName.
Keep visiting the site for more tips ... J