Tag: security

Synchronizing any folder on your system with OneDrive

| 09/12/2014 | 0 Comments

In my last post: Backup regimes and synchronizing folders across your network , I discussed my method of backing up data from four folders off the root of the drive across my network and how I use the free SyncToy 2.1 tool from Microsoft. So in this post I wanted to take it to the next level.   Introducing the Cloud Here is the next bit of the puzzle…

Continue Reading

Project Accounting + Multi-currency + Inventory Items = No Worky

Project Accounting + Multi-currency + Inventory Items = No Worky

Just confirmed via Microsoft support today that if you’re using Multi-currency in your Project Accounting projects, you cannot add the Inventory Item Cost Category to the project if the project currency is different from the company Functional Currency.  This is due lack of multi-currency capability in the inventory module.

Continue Reading

Product ID and Product Name

| 09/09/2014 | 0 Comments
Product ID and Product Name

The table below lists the various products that are commonly available on the Dynamics GP install DVD media. I got this list originally from the Dynamics GP worksheet prepared by Microsoft. Product ID Product 0 Dynamics 1 Dexterity 258 Project Accounting 309 Fixed Assets 346 Manufacturing 414 Human Resources 949 Field Service 1042 Interfund Management 1045 Revenue Expense Deferrals 1058 Cashbook (Bank Management) 1150 Scheduled Installment 1157 Collections Management 1235 Safe Pay 1428 Electronic Reconcile 1493 SmartList 1632 Cash Flow Management 1838 Technical Service Tools 1878 Excel-Based Budgeting 1911 HRM Solution Series 2150 Payment Document Management 2199 Business Activity Statement 2277 Purchase Order Enhancements 2416 Control Account Management 2547 Enhanced Commitment Management 2788 Enhanced Intrastat 2992 CopierSeries 3096 VAT Daybook 3104 Advanced Security 3180 Analytical Accounting 3258 Encumbrance Management 3278 Report Scheduler 3830 SmartList Builder 4067 ML Checks 4421 Grant Management 4522 Payroll Integration to Payable 4612 Advanced Go Tos 4621 Analysis Cubes for Excel 4933 Certification Manager 4955 Employee Health and Wellness 5597 HITB Report 5967 Fixed Assets Enhancements 5982 Export Financial Data 6499 Dynamics Online 6831 Date Effective Tax Rates 7131 Canadian Payroll 8811 Direct Debits & Refunds If you look in the ‘upgrade’ section of Customer/PartnerSource, a worksheet is available that includes the products and their various build numbers

Continue Reading

After restarting SQL Server, only ‘sa’ user can log into Microsoft Dynamics GP

| 09/08/2014 | 0 Comments

Last week, I resolved a rather bizarre case for a customer. The Situation Each time the customer’s SQL Server was restarted for whatever reason, only the ‘sa’ user was able to log into Microsoft Dynamics GP.  Once the ‘sa’ user had logged into Microsoft Dynamics GP at least once, then all the other “normal” users could log in and everything was fine until the next time the SQL Server was restarted.

Continue Reading

SQL view for easier General Ledger transaction searches in Dynamics GP

| 09/04/2014 | 0 Comments

Just about every Dynamics GP customer I have worked with, at one time or another, has had occasion to search the General Ledger for a particular dollar amount.

Continue Reading

More from the Dynamics GP Community do the ALS #IceBucketChallenge

| 09/03/2014 | 0 Comments

Following on from my recent post: David Musgrave does the ALS #IceBucketChallenge . A number of other people in the Microsoft Dynamics GP Community have now risen to the challenge. Below are their videos and blog articles:   Beat Bucher: @GP_Beat takes the ALS #IceBucketChallenge Aug-2014 ( direct link ) (Please visit the site to view this video) Blog: ALS Ice Bucket Challenge   Mariano Gomez does ALS #IceBucketChallenge ( direct link ) (Please visit the site to view this video)   Blog: Mariano Gomez does the ALS #IceBucketChallenge   Mark Polino: ALS Ice Bucket Challenge.

Continue Reading

VBA: DUOS data stored in the wrong database after switching companies

| 09/01/2014 | 0 Comments

A while ago I had a case where the customer was storing data in the DUOS (Dynamic User Object Store) table from a VBA (Visual Basic for Applications) customisation.

Continue Reading