I found a question in the Dynamics Forum about this subject and answered Mariano Gomez, Mariano detailed all the steps required to fix this up, follow Mariano steps in this article if you found an issue about this subject.
Friday, December 17, 2010
Have you ever restored a database from your backup and wanted an easy way to get users automatically created? script below will do this task for you:
DECLARE @USER varchar(500)
DECLARE @SID varchar(500)
DECLARE CURR CURSOR FOR
SELECT NAME, SID FROM sysusers WHERE issqluser = 1 and (sid is not null and sid <> 0x0)
and suser_sname(sid) is null ORDER BY name
FETCH NEXT FROM CURR INTO @USER, @SID
WHILE @@FETCH_STATUS = 0
EXEC sp_change_users_login 'Auto_Fix', @USER, @SID , @SID
FETCH NEXT FROM CURR INTO @USER, @SID
Above script will read all database level defined users and locate it corresponding users in SQL, if it found the script will map existing user to SQL user, otherwise it will add a new user with a new password and map both users.
Next step required is to change the user password at the application level “Dynamics GP” so it encrypts the user password again and fulfill business requirements.
If you have updated to GP 10.0 SP 5 or GP 2010 SP1 you might already notice the slow performance during login, this is mainly related to the newly added “Dynamics Online Services” dictionary that adds records in the menu table with removing old ones as detailed in this article for David Musgrave and this article for Vaidy Mohan, the temporary solution for this is deleting the records in the menu table that's related to this dictionary.
To avoid the manual deletion of the records in this table, you will need to create an SQL job that automatically deletes unwanted records from this table, follow steps below to start:
1. Open SQL Server, navigate to SQL Server Agent >> Jobs, right click and select “New Job”:
2. Name this Job and click on “Steps”:
3. On steps click on “New”, select your company and paste the following command then click on OK:
DELETE FROM DYNAMICS.dbo.SY07110 WHERE CmdParentDictID = 6499
4. On the new job screen click on schedules and schedule the task to run daily:
5. That’s it, you are ready to go, right click the job and select “Start Job”
Make sure that the job was successfully executed:
Friday, December 10, 2010
I would like to invite you to the biggest IT event by Microsoft this year – the Amman Open Door, December 15-16 at Sheraton Hotel.
Register and attend, we’ll have fun! You can find me in “ASK THE EXPERTS” booth all the time.
Please feel free to share this event.
Monday, December 6, 2010
Its all about extracting data from Dynamics GP! Take a look into Mariano article here and you will understand!
Friday, December 3, 2010
Have you ever wanted to apply your vendors transactions automatically without having to move between all your vendors? I been in a situation with a new client that works on Dynamics GP since 2001 and they never applied their vendors payments to their invoices.
Working on this manually is a real nightmare and the user will keep working on this for ever before being able to finalize, therefore I have wrote script below that generates Macro to set this up, follow steps below to get the macro:
1. Open SQL Server and create new query.
2. Select your company database.
3. Paste code below ** “at the article footer under the signature” and run.
4. Script will generate a macro:
5. Copy macro text and paste it into a new notepad document.
6. Save it under “.Mac” extension.
7. Go to “Transactions >> Purchasing >> Apply Payables Documents”.
8. Go to “Tools >> Macro >> Play” and select the file you just saved:
Enjoy watching your transactions during the apply process.
** SQL Code:
/** SQL Code: **//** By Mohammad R. Daoud **//** Dynamics GP MVP **//** www.mohdaoud.com **//** +962 79 999 65 85 **//** 02-12-2010 **/SELECT VENDORID, CASE WHEN DOCTYPE = 4 THEN 1 WHEN DOCTYPE = 5 THEN 2 WHEN DOCTYPE = 6 THEN 3 END AS DOCTYPE, CASE WHEN DOCTYPE = 4 THEN 'RETURN' WHEN DOCTYPE = 5 THEN 'CREDIT MEMO' WHEN DOCTYPE = 6 THEN 'PAYMENT' END AS DOCTYPEDESC, DOCNUMBR FROM PM20000 WHERE DOCTYPE IN (4,5,6) AND YEAR(DOCDATE) BETWEEN 2001 AND 2017 ORDER BY DOCTYPE, DOCDATE ASCOPEN PMAPPLYWHILE @@FETCH_STATUS = 0Print '##################################'Print 'CheckActiveWin dictionary ''default'' form ''PM_Apply_To_Maintenance'' window ''PM_Apply_Document'''Print 'NewActiveWin dictionary ''default'' form ''PM_Apply_To_Maintenance'' window ''PM_Apply_Document'''Print 'MoveTo field ''Vendor ID'''Print 'TypeTo field ''Vendor ID'' , ''' + LTRIM(RTRIM(@VENDORID)) + ''''Print 'MoveTo field ''Document Number'''Print 'MoveTo field ''Document Type'' item ''' + @DOCTYPE + ''' # ''' + @DOCTYPEDESC + ''''Print 'ClickHit field ''Document Type'' item ' + @DOCTYPE + ' # ''' + @DOCTYPEDESC + ''''Print 'MoveTo field ''Document Number'''Print 'TypeTo field ''Document Number'' , ''' + LTRIM(RTRIM(@DOCNUMBR)) + ''''Print 'MoveTo field ''Auto Apply Button'''Print 'ClickHit field ''Auto Apply Button'''CLOSE PMAPPLYDEALLOCATE PMAPPLY
Thursday, December 2, 2010
David just announced the availability of the support debugging tool build 14, I am not gonna say anything about it and leave you with this article from David @ Developing for Dynamics GP blog.
Tuesday, November 30, 2010
Have you ever wanted to copy your business alerts from a company to another? Fabien Peyaud created stored procedures posted @ Dynamics GP.ie blog, checkout the article here.
Saturday, November 27, 2010
Interesting article by Amy Walsh, he explained how to add vertical lines into FRx, checkout his article here.
Looks like David Musgrave hacked into my laptop and saw my draft article about Barcode Printing using Dynamics GP!
A couple of weeks ago I got a request to print barcodes from Dynamics GP, I wanted to publish my experience but couldn’t due to the workload I currently have! However, I did this using one of the below sources:
Barcodes Inc. also will work:
David explained how to add the Barcode font to the report with all related details using VBA, find out David’s article here.
Friday, November 19, 2010
Support for Microsoft Dynamics GP 9.0 will end January 11, 2011 it is highly recommended for existing GP 9.0 users to upgrade from GP 9.0 to GP 2010 to utilize the maximum benefits of purchasing an international product with yearly enhancements and updates.
Great news was published on Microsoft Press Release, Microsoft Dynamics GP 2010 R2 is coming up with great new features, checkout below features as an example:
The Microsoft Dynamics GP 2010 R2 update expands key areas of investment for Microsoft Dynamics GP 2010, including the following:
• Enhancing insight into role-specific information through an improved user interface and personalized dashboards, quickly delivering information that’s relevant to the actions people are taking or the information they are viewing
• Making it easier to complete tasks with improved approval workflow and electronic signature capabilities, helping people save time while managing compliance and helping to reduce fraud
• Extending connections through Fact Boxes and Action Shortcuts, which are now connected with Microsoft Lync 2010 instant messaging windows, bringing information about the people who are chatting and their companies to the user’s fingertips
Read the complete article here.
Saturday, November 13, 2010
I am glad to announce this guys! We are preparing for a competition between active community members in Jordan, unfortunately MVP’s are not allowed to participate!!!
Simply contribute in any online or offline activities – I would love to help you in this – and record your activity.
The prize for the winner is:
A FULLY-PAID trip to Tech-Ed Middle East 2011!
To be eligible for judging, an entry must be unique and focus on Microsoft technologies or products, while also meeting the criteria mentioned below:
Minimum 10 attendees
Minimum 4 trainees
Minimum 200 views
Minimum 200 views
Minimum 50 downloads
Minimum 50 downloads
Minimum 100 downloads
Minimum 100 downloads
Open Source Project
Must be publicly available on CodePlex.com
Answer question on Microsoft Forums
Post must be Marked as Answer
To help you more, Muhanad Omar (SharePoint MVP) published a portal for this competition that allows all users to create their own entries and participations, and allows the Committee to validate your work:
To submit an entry, browse to the “My Entries” page and fill-in the appropriate form for your entry. The Entry Form will ask you to select the Contact Person for verification purposes. This person must be a Microsoft Employee, Microsoft MVP, or Community Leader. You may contact the verifier to explain your entry. Once your entry is reviewed, you will be notified if it has been approved or rejected.
Community work is rewarding - to us and our communities.
Let’s compete to see who is the most active community member amongst us!
Have you ever got a request to keep versions on Dynamics GP Data? With “Audit Trails” module you can!
Follow steps below to activate the Audit Trails:
1. Install the module for GP CD.
2. Go to “Microsoft Dynamics GP menu >> Tools >> Setup >> Company >> Audit Trails >> Install Audit Trails” and click on “Install” :
2. Go to “Microsoft Dynamics GP menu >> Tools >> Setup >> Company >> Audit Trails >> Audit Trail Maintenance” and setup your Audit:
3. First click on “Refresh” to get the list of tables, and then select the needed table.
4. Click on “Apply Auditing” to select your table.
5. Click on “Auditing Options” to set filters on what data need to be monitored if required:
6. Click on “View” and enjoy monitoring changes on the selected table:
This looks typically like the smart list, you can utilize all smart list features here.
I should admit, it was a crazy month! I been very much busy in thousands of meetings and been unable even to check my mail, thanks god we have a vacation these days so I can post few articles!
Are you “Not for Profit” organization? Do you have budgeted donations and grants and wanted to manage it the right way? Dynamics GP is the right solution for this.
If you ever installed Analytical Accounting, you might notice a module called “Grants Management” that is located under Analytical Accounting, this module is mainly used to manage Grants and Donations for Not for Profit Organizations and indeed it integrates Analytical Accounting Dimensions, Codes and Budgets.
To activate and work on this module, you must follow steps below:
1. Install this module using Dynamics GP CD’s.
2. Go to “Microsoft Dynamics GP menu >> Tools >> Setup >> Company >> Grant Management” and check “Activate Grant Management” and select your default transaction dimension that holds your grants.
3. If you have any company specific fields you would like to customize, just name it here:
4. Go to “Cards >> Financial >> Grant Management >> Grant Status Maintenance” and set you workflow of status changes:
5. Go to “Cards >> Financial >> Grant Management >> Grant Maintenance” and define you grant, you can define unlimited number of grants types:
6. Go to Analytical Accounting Budgeting and create your budget:
7. Click on “Validation Options” button on “Grants Maintenance” form and link your budget:
Saturday, October 16, 2010
Inside Microsoft Dynamics GP published the dates for the Demo and VPC Trainings around the US, unfortunately such event does not cover the Middle East, it would be great if they could expand it to our region!
Find out the training schedule in this article.
Interesting article by Victoria Yudin, she displayed the Checkbook Register using SQL view, find her article here.
Wednesday, October 13, 2010
Personally, when Microsoft announced the discontinuation of old public newsgroups microsoft.public.greatplains and the microsoft.public.dynamics.gp.developer, I didn’t like the idea! I been working the last 3 years on a platform that currently will need to be changed!
Few days ago, I start accessing the community and start replying on the users questions, I really found an amazing difference between this version of community and what I used to work on! I enjoyed working on many new features announced in this post, mainly I touched the social networking during newsgroup questions and saw the blog posts consolidated in one place.
Well done guys!
Monday, October 11, 2010
I found an interesting question in the Dynamics GP Forum, the user was trying to fix security issue as one of GP users cannot see the Asset Groups, below is the question:
In several of the Fixed Asset transaction screens, like the Fixed Assets Mass Change screen, there is a Asset Group ID drop down select list. For one of our users this drop down does not function. I've compared his security to a user that has the drop down working correctly and cannot see any difference. The two users can log in to GP on the same machine and it works for one and not the other. Can anyone give me any suggestions on what I might check?
Below is my answer:
This is not related to any security reasons, actually Assets groups is User Oriented field, each user will have its own groups that are not shared with other users, as written in the F1 help:
"Asset groups are saved on a user-by-user basis. For example, if user A creates an asset group, user B will not see that asset group anywhere in Fixed Asset Management."
Hope that this helps.
Looks like I have a tough month, last week I spent 4 days in AQABA for customer support and yesterday I presented Dynamics GP for a new customer in Damascus, the customer’s team is highly trained team with a minimum of 15+ years of experience in ERP field, they requested an interesting specific demo script that shows the ERP functionalities and weaknesses, I requested the authorization to share this demo script and waiting for their confirmation.
However, I got an interesting case last week, my customer informed me that every time they adds a new user using Dynamics GP users, the user is added automatically to the db_owner role on all databases!?! First I didn’t believe in this but when I checked this it turns to be true!
After investigating on this, I found the reason behind this, the whole “DYNGRP” role which used by the Dynamics GP application to set users security was added to the “db_owner” role, therefore when adding any user to the DYNGRP it was automatically grants the db_owner permissions! I just removed the DYNGRP from db_owners role and everything worked perfectly as expected.
Hope that this helps.
Customers that holds certificates such as the ISO and many others, normally having bad fights with auditors on security audits and database monitoring tools, normally I gets allot of requests on how to monitor this up and get rid of those auditors!
Few months back, I created a script that generates database triggers on all database tables and sends all the activities to a transactions log table that in return will hold all transactions.
Lets think about it again, what users should I monitor? Dynamics GP users does cannot access the SQL Databases using any other application as all the passwords are encrypted and only Dynamics GP application and Mariano Gomez can decrypt it! I mean only Dynamics GP!
So users that need to be monitored are listed below:
1. Users that does not have access to Dynamics GP but have direct access to the SQL.
2. Users that has access to both Dynamics GP and SQL Databases and does not have their passwords encrypted, which are only two “sa” and “DYNSA”.
3. Users that’s login using windows authentication.
Now using SQL 2008, you can audit all above using the Database Audit feature, go to “SQL Server –> Security Folder –> Audits” and follow steps below to activate this:
Create new Audit:
Go to the database you wish to monitor, navigate to its security folder –> Database Audit –> Create new:
Now you need to specify actions you wish to audit, personally I wanted to monitor “Insert, Update, Delete and Execute” for non-GP users, “dbo” represents any user with sysadmin permissions, which includes “sa” and “DYNSA” and “SYSTEM” users represents any user logged in using windows authentication.
Set back and relax watching any unwanted modifications done on the database monitored, and view what does this recorded from time to time by right clicking your audit and selecting “View Audit Log”:
For CFO’s and top management reporting, you cannot ask them to go to your SQL and view the report! So you will have to setup another solution:
1. Create a new view on your Master database with the following command:
FROM dbo.fn_get_audit_file('C:\Database Modifications Audit\*', DEFAULT, DEFAULT)
Where “Database Modifications Audit” is the folder I created on the C:\ Drive to save all my logs.
2. Create a new SQL Login that has permissions only on this view.
3. Create an excel file that reads directly from this view using Data Source.
4. Send this excel file to the top management and ask them to refresh.
Sunday, October 3, 2010
This morning, I went to the exams center with my both colleagues Nancy and Omar to attend “Managing Microsoft Dynamics Using Sure Step Methodology” exam, it was such an exciting experience answering questions related to the management part instead of the usual technical's, we all passed!!
Few hours later, I decided to attend the “Microsoft Dynamics GP 2010 Installation and Configuration”, honestly it wasn’t an easy task, I still didn’t work deeply on Dynamics GP 2010 nor worked deeply on SQL 2008, I thought it will not be that much difference than Dynamics GP 10.0 exam, unfortunately it was! I passed the exam but got 72% mark! I would fail if I missed 2 more questions!
It was focused on the Word Templates customizations, printing and installation, in addition to SQL 2008 express and process server.
Saturday, October 2, 2010
Interesting article by Blinda, the GP CSI! She explained how to combine multiple reports into report groups and print it once, checkout her article here.
Wednesday, September 29, 2010
I liked the way how Mark Polino posted about it in this post, checkout mark post below:
David Musgrave takes a look at Microsoft Dynamics ERP Licensing Changes. I’m going to say that on a personal level, there are elements of the new licensing that I find to be a naked cash grab by MS. Customers screamed about the DCO licenses and rather than deal with customer anger, MS renamed them to make them sound more appealing. Accessing GP data with other tools should be covered by other licenses, the SQL CAL, the Office CAL, etc.There is no good reason to allow access other data in the same location with these licenses but not cover Dynamics data. Companies have already paid for access to this data, there is no reason for them to have to pay again.
Tuesday, September 28, 2010
Yesterday I noticed that the last exam I attended was since 3 years ago! It was Dynamics GP 9.0 Supply Chain, so I went to the exams center this morning and attended Dynamics GP 10.0 Financials, Dynamics GP 10.0 Supply Chain, Dynamics GP 10.0 Installation and Configuration and passed them all :) Next week I will proceed with Dynamics GP 10.0 Manufacturing and start with GP 2010 Exams.
Wish me luck.
Have you wondered how to move integrations from one location to another? Have you tried to export the integration and it didn’t work? Follow steps below:
1. Open Integration Manager and go to Tools –> Create Database:
2. Save the database in a known location.
3. Go to File –> Export Integrations, and select the file you just generated.
4. Copy the file to the other PC and import it.
Sunday, September 26, 2010
Omar Kloub posted an interesting script that views the history of the fixed assets depreciations, he’s displaying (Asset ID , Asset Description , Year , Period , Depreciation General Journal Number , General Journal Date , Vendor ID , Vendor Name (If the asset was purchased of course) . Purchase document number ,..etc) in his view, find out his interesting article here.
Inside Microsoft Dynamics GP blog has published the availability of the Dynamics GP 2010 VPC, find their article here below they have posted about this image:
What Are the Key Programs Installed?
1. Microsoft Dynamics GP 2010 (RTM) – FULL INSTALL
2. Management Reporter for Microsoft Dynamics ERP
3. Business Portal 5.0 for Microsoft Dynamics GP 2010
4. Workflow for Microsoft Dynamics GP 2010
5. Microsoft Dynamics GP 2010 Dashboards
6. Microsoft Windows Server 2003 R2
7. Microsoft SQL Server 2008 R2
8. Microsoft Windows SharePoint Services 3.0
9. Microsoft SQL Server Report Builder 2.0
10. Microsoft SQL Server 2008 SRS Reports for Microsoft Dynamics GP 2010
11. Microsoft Office 2010 – Professional Plus
12. Word Forms for Microsoft Dynamics GP 2010
13. Audit Trails and Electronic Signatures
14. Advanced Human Resources and Payroll
15. Extender, SmartList Builder, Excel Report Builder and Navigation List Builder
16. IW Specific Demonstrations
Microsoft Dynamics GP 2010 RTM “Core-Plus” VPC PartnerSource Download Page:
Mariano Gomez posted an interesting article explaining the security behind remember password feature in Dynamics GP 2010, checkout his article here.
Victoria Yudin posted an interesting article about this subject, checkout her post here.
I noticed that the SP1 for Dynamics GP 2010 was released, its now safe to upgrade from GP 10.0 SP5 to GP 2010 as long as you have SP1 installed, use below links to download:
Posts from other blogs:
Mariano Gomez: Microsoft Dynamics GP 2010 Service Pack 1 now available!
David Musgrave: Microsoft Dynamics GP 2010 Service Pack 1
Geofrrey Wayong: Microsoft Dynamics GP 2010 Service Pack 1 has been released!
Amy Walsh: Dynamics 2010 SP1 Release
Jivtesh Singh: GP 2010 SP1 is out!
David has an interesting article explaining how does Disk Cleanup and Windows Update affects Dynamics GP, checkout his interesting article here.
Tuesday, September 21, 2010
Yesterday I been working to enhance the blog design and added a new functionality which allows the reader to receive blog updates directly to his mail:
I have used Blogtrottr services to make this task easier:
Monday, September 20, 2010
2 weeks ago I been trying to catch up what I missed during my trip to KSA, but it seems I have another “travelling month” these days, last week I had a business trip “pre-demo discussion” to Lebanon and enjoyed the dawn in Oceana Beach – Beirut, and this week I am going to finalize the demonstration, wish me luck! @_@
I just got a mail from Microsoft informing me that my MCT application was approved and I officially became Microsoft Certified Trainer!
I am very much excited to maintain this certificate and to deliver the max of Dynamics GP in my Trainings.
Checkout this page of Microsoft Support, it details the needed dates related to Dynamics GP 9.0.
More resources about this subject:
Victoria Yudin: When does my GP product’s support end?
Jivtesh Singh: GP 9 Support Ends Jan 11, 2011
Tuesday, September 14, 2010
I noticed that my colleague Omar Kloub who’s working as GP Consultant from Jordan was started his blog! He combined his GP knowledge along with his iPhone’s knowledge (the best phone I ever had!) and started this blog.
I would like to welcome Omar onboard, checkout his interesting blog here.
It been a long time since I posted my last article, I been out of reach the last couple of weeks in KSA for UMRA! The trip was great and now I am trying to catch up what I missed during that time.
Monday, August 30, 2010
While digging deeply in the internet, I been trying to find out away to help my blog readers and send my posts directly to their mails.
I found allot of sources over the internet, most of the are paid but the one I liked is Blogtrottr, I am working to integrate this site with my blog so my posts will be diverted to the readers mails directly, with the ability to unsubscribe any time.
Wish me luck!
Thursday, August 19, 2010
Talking about Bank Deposit Entry form, I noticed an issue when trying to change the Checkbook ID, the system does not automatically populates the next available deposit number, instead its uses the old number exists in the form and tries to load it document with the following message:
“The deposit already has been posted for this checkbook. Choose Continue to display the posted transaction for voiding.”
Or worst, if the selected deposit number for the old checkbook was reconciled in the newly selected checkbook, the following message will appear:
“This deposit can’t be used. It has been reconciled, is marked for reconciliation or has been previously voided.”
The simple workaround is just by clicking “Clear” before changing the Checkbook ID, I will report this to Microsoft and hopefully will get a reply!
I got an interesting case this morning by one of my clients, they are getting the following error:
“A deposit for this chequebook already has been started. If the process was interrupted, use the Check Links window to check links for the CM logical files.”
The customer informed me that they checked links as requested, but it didn’t resolve the error. I ran SQL Server Profiler Trace and found Column called “Deposit_In_Progress” that holds the current deposit number each time you opens the deposit entry form, so if GP stuck in this situation, the system will keep notifying about the issue to avoid any data violation, simple empty this field and the error will no longer exist.
I found the following article in LinkedIn if any one interested:
Opening for Great Plains consultant - UAE
Hi. We are in a lookout for Great Plains Consultant - Technical and Functional for one of our client in UAE.
Interested candidates can share their updated profile to email@example.com
Service pack 5 has a hug number of fixes included, for me I liked specially the Analytical Accounting and Inventory modules fixes, its very much useful for customers in our region, below image represents some of the enhancements on the inventory module:
My outlook is ringing right now for receiving posts from Davids and Mariano’s blogs, they confirms the release of Dynamics GP 10.0 Service Pack 5 with allot of fixes detailed in this document, to download the package go to the update page here and start downloading the files.
Thursday, August 5, 2010
Great article by Patrick Roth at Developing for Dynamics GP blog, he explained how to modify the home page of the application using VS2010. Basically he added the company name next to the user ID in home page as an example!
Nice article by Belinda Allen at Belinda, the GP CSI blog, she posted a video utilizing the account transactions smart list along with excel grouping to get the GL trial balance in excel through few click, checkout her article here.
Tuesday, August 3, 2010
Last year, David posted an article that shocked all Dexterity developers, he created a screenshot that shows dexterity codes inside Visual Studio .Net! Developers using dexterity was very much excited to work on that, but unfortunately it was April fool’s day and David couldn’t live without posting such an article!
However, Mariano was working the last few weeks to enhance dexterity with one of the most wanted .Net features which was the auto-complete, in this article he explained the whole story of the IntelliSense and the requirements to integrate non-OOP applications, and in this article he suggested this methodology to Microsoft Connect and wanted your votes and support to get this done.
For those who work on Dexterity and like the way it works, you must vote to make your life easier!!
Thanks Mariano for the update!
Unfortunately, Microsoft Knowledge Base Article # 861586 explained that FRx does not support Arabic characters at this time.
Today I found an interesting question in the newsgroup requesting an integration between Dynamics GP and Project Server, it might be doable but it will not be an easy task if it was a complicated integration.
However, the question was:
does anyone know if it is possible to integrate both GP2010 and PS2010? If so what is required?
what we are looking for is to send ProjectServer timesheet information into GP2010.
Few days ago I presented something like this for a new customer and the idea was acceptable. The customer was using MS Project to manage their projects and wanted to have their projects tasks goes directly into Dynamics GP, not only the timesheet entries, but also all project expenses, resources, items and services, I tried to integrate Project Server to Dynamics GP but it was not an easy task if you are looking to integrate the projects tasks to your
inventory items and all other integration points.
However, I worked around this by using Dynamics GP Manufacturing Bill Of Material, design the project exactly as you design it in MS Project, but instead of writing down that tasks, selects it as items, so all you MS Project Tasks will have to be defined as both inventory and service items based on the type of task, I have created a .Net based tool that replaces the print button of the Manufacturing BOM with Gantt Chart using tools from
DevExpress, Chart will look like the image on the right-->
Finally they accepts the idea as all the columns they uses frequently was exist in the BOM, they have used the In/Out dates as start/end dates and the costs will be calculated automatically, try it, it might fulfill your needs.
Dynamics GP Upgrade Failed, Company Locked and no Longer Upgradable with small lock image on the left?!?!?
We all got such an issue during Dynamics GP upgrade, this due to the fact that Dynamics GP Utilities Locks the database during the upgrade to avoid any deadlocks at the SQL Level that affect the upgrade process, yesterday I got a mail from someone asking about this issue and I though that the solution should be posted.
However, to get around this, all what you need to do is to go to Dynamics database and clear “DuLCK” table!
I know that this is a bit out of Dynamics GP scope, but all iPhone users are excited to this announcement!
Just days after the U.S. Copyright Office ruled that bypassing a manufacturer's protection mechanisms to allow "handsets to execute software applications" no longer violates federal copyright law, the iPhone Dev Team on Sunday released a jailbreak for the iPhone 4 at JailbreakMe.com.
Unlike previous jailbreaks, which required the device to be connected to a computer to run the update, the latest jailbreak is accomplished completely via mobile Safari loaded on the device. The browser-based software bypass reportedly works on all iOS devices, including iPhones, iPads, and iPods running iOS 4 and iOS 4.01, but it will reportedly not work on devices running the iOS 4.1 beta.
Read more about this here.
Bottom line, no need to be GP expert to unlock you iPhone, any internet user could do so!
Friday, July 30, 2010
It seems I totally forgot to publish this article and thought that I finalized the series!
Customer statements are normally dependant on the each client process, end user will normally request the customer statement to be in the way that fulfills their needs, some users will require the statement to integrate the payment document management module and some requires the aging.
However, normally the customer statement option in the utilities covers almost all needed statements, below statement is a standard statement could generate the customer statement in “Payment – Invoice” columns which make easier to the accountant the understanding of customer transactions.
DOCNUMBR AS DOCNUM, DOCDATE,
WHEN 1 THEN 'SLS' WHEN 2 THEN 'SCP'
WHEN 3 THEN 'DR' WHEN 4 THEN 'FIN'
WHEN 5 THEN 'SVC' WHEN 6 THEN 'WRN'
WHEN 7 THEN 'CR' WHEN 8 THEN 'RTN'
WHEN 9 THEN 'PMT' END AS CODE,
WHEN 1 THEN ORTRXAMT WHEN 3 THEN ORTRXAMT
WHEN 4 THEN ORTRXAMT WHEN 5 THEN ORTRXAMT
WHEN 6 THEN ORTRXAMT ELSE 0
END,0) AS INVOICE,
WHEN 7 THEN -(CURTRXAM) WHEN 8 THEN -(CURTRXAM)
WHEN 9 THEN -(CURTRXAM) ELSE 0
END,0) AS PAYMENT, DOCNUMBR AS APPLIEDTO
(RMDTYPAL = 7 AND CURTRXAM <> 0)
OR (RMDTYPAL = 8 AND CURTRXAM <> 0) OR (RMDTYPAL = 9 AND CURTRXAM <> 0)
OR RMDTYPAL = 1 OR RMDTYPAL = 2 OR RMDTYPAL = 3
OR RMDTYPAL = 4 OR RMDTYPAL = 5 OR RMDTYPAL = 6)
AND VOIDSTTS <> 1
APFRDCNM AS DOCNUM, DATE1 AS DOCDATE ,
WHEN 7 THEN 'CR' WHEN 8 THEN 'RTN'
WHEN 9 THEN 'PMT' END AS CODE,
0 AS INVOICE,
ISNULL(CASE APFRDCTY WHEN 7 THEN APPTOAMT
WHEN 8 THEN APPTOAMT WHEN 9 THEN APPTOAMT
ELSE 0 END,0) AS PAYMENT ,
APTODCNM AS APPLIEDTO
WHERE POSTED <> 0
ORDER BY DOCDATE
As all other reports, to avoid any issues when creating our crystal report, we’ll need to add the above statement as a “Command” instead of direct tables as the command does not store the database name along with the statement, the report will need to be designed to look like the below:
Crystal Report Design:
Few optimizations are still required to include calculations and formulas to get the report in the needed format.