Wednesday, March 31, 2010

Transfer Item From inventory site to a Fixed Assets Item

Really liked the method Mariano used in this post to fulfill a need to have his fixed assets items moved out of the main inventory and get capitalized as required, he used the in-transit transaction to transfer the goods and get the required accounting reflect, I really recommend reading his post.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Checkboxes in Crystal Reports

Great article by Victoria on Crystal Reports to view Boolean objects as checkboxes in your crystal report, she’s using the Character of the ASCII (168) and (254) to display the Checkbox symbols, checkout her post here.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Separate Remittance in Checks Printing

Option posted by Frank, where you can get remittance printed along with your checks, checkout his post here.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Playing Sound when starting Dynamics GP!!!

Interesting article by David, just add a wave file and rename it to “GPSSystemStart.wav” in your windows folder to get it played upon starting GP! Checkout his post here.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Automatic Bank Reconciliation (Electronic Reconcile)

Amy Walash posted an article describes how e-reconcile works, his post worth checking.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Wednesday, March 24, 2010

Microsoft Dynamics GP Promotion: Three Users for $1

Microsoft Dynamics GP Official blog announced a new offer from Microsoft, you can now purchase your first 3 GP AM or BE users for 1$ only! Unfortunately this offer is valid in US only.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Customer Statement With Multicurrency Information

Have you ever wanted a customer statement with multicurrency information and aging? Take a look to this post.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Manufacturing Registration Keys

Have you ever tried to locate manufacturing registration keys form? Frank found it! Checkout his post here.

image

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Budget Lock with Password

Have you ever wondered what is the “Lock” button besides the Budget ID? Its an option to protect your budget with a password, for more details, checkout Frank post here.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

No Receipts are shown up when you perform Purchasing Return Transaction??

Frank posted a tip to print The Purchase Receipts report that detail all the transactions per receipt, checkout his post here.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Mass Modify Chart of Account

If you were looking to copy or modify a range of accounts, you will need to checkout Frank post here, he explained how the process works.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Display/Hide Unit Cost In Sales Transaction Entry Form

Frank post a new tip on how to control the appearance of the unit cost in Sales Transaction Entry, checkout his post here.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Tuesday, March 23, 2010

New Video Games Generation – Project Natal

It seems I am not the only one excited to get Natal cam! Checkout the video posted @ Developing for Dynamics GP here.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Saturday, March 20, 2010

Configure Terminal Services Sessions Limit

Sometimes, you might need to have your Terminal Services Server to terminate idle sessions to avoid server load, or vise versa as you might need to prevent the server from terminating your sessions if you would like to run processes over night, to configure such settings, follow steps below:

1. Go to your server Administrative tools.

2. Locate “Terminal Services Configuration”

3. Click on “Connections”

4. Right click “RDP-TCP” and select properties as shown in the image below:

image

5. Click on “Sessions” tab and configure this settings:

image

Hope that helps.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Tuesday, March 16, 2010

Vacation!!!

Last week I been out of reach in a personal trip to Lebanon, it was great! Below is my son in Syda:

100_4048

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Miscellaneous Recurring Batch

Good tip by Frank Hamelly, on how to specify Misc number of days for recurring batches, checkout his article here.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

My Interview with Dynamics World was published!

Check it out below:

http://www.dynamicsworld.co.uk/Interview---Mohammad-Daoud.php

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

ERP Implementation Strategies

Another great job by Houston Neal, he posted an article about ERP Implementation Strategies, checkout his blog post here.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Saturday, March 6, 2010

Auto grant access to users on newly added Analytical Accounting Codes

This feature is already added to GP 2010, but if you are looking to have such feature in your current GP, you might need to take a look at this macro generator.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

View for Account Payable Transactions with Analytical Accounting Information

If you are looking to combine such information in smart list builder, take a look to this article, it will save you allot of time.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Support Debugging Tool Portal

Looks interesting.. http://blogs.msdn.com/developingfordynamicsgp/pages/support-debugging-tool.aspx

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Dynamics GP Change Colors Per Company

David post an article about covering this section in the Support Debugging Tool, checkout his blog post here.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Friday, March 5, 2010

Tips on Discontinued Items

When you need to inactivate one of your inventory items, your only available option is to change the item type to discontinued, in Item Maintenance:

image

Logically, discontinued items that has quantity on hand must give users the ability to SOLD remaining quantities, you need to setup the application to allow this, check out the message below on Sales Transaction Entry:

image

To correct this, you must change your settings in SOP Setup options to allow Sales of Discontinued Items:

image

While the system does not allow the item to be added to PO, it allows the user to receive the goods and only warns the user that this item is a discontinued:

image

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Thursday, March 4, 2010

Only Transactions that has special characters in Number field are displayed in Bank Statement Reconciliation

One of my customers reported that when they are trying to reconcile bank statement, not all transactions entered in bank transaction window are displayed, while investigating the issue, I did the following:

1. Checked-links.

2. Changed Regional and Language options language for Unicode characters to make sure that this is not a collation error.

3. Reinstalled the application.

4. Tried to use another machine.

5. Checked the knowledgebase, the only solution they provided is to compare CM20200 and CM20500 with no luck.

6. Checked the database collation and validated that the collation for all databases is matched to the SQL engine.

7. Compared one of the displayed lines with another one and noted that only transactions that has Special Characters in the Number field are displayed! as shown below:

image

I created SQL Server profiler trace to get the SQL Command that retrieve the data from CM20200 and got the following SQL Statement:

SELECT TOP 25
CMRECNUM, sRecNum, RCRDSTTS, CHEKBKID, CMTrxNum, CMTrxType, TRXDATE, GLPOSTDT, TRXAMNT, CURNCYID, CMLinkID, paidtorcvdfrom, DSCRIPTN, Recond, RECONUM, ClrdAmt, clearedate, VOIDED, VOIDDATE, VOIDPDATE, VOIDDESC, NOTEINDX, AUDITTRAIL, DEPTYPE, SOURCDOC, SRCDOCTYP, SRCDOCNUM, POSTEDDT, PTDUSRID, MODIFDT, MDFUSRID, USERDEF1, USERDEF2, ORIGAMT, Checkbook_Amount, RATETPID, EXGTBLID, XCHGRATE, EXCHDATE, TIME1, RTCLCMTD, EXPNDATE, CURRNIDX, DECPLCUR, DENXRATE, MCTRXSTT, Xfr_Record_Number, DEX_ROW_ID
FROM JBC.dbo.CM20200 WHERE

(CHEKBKID >= 'JODCA-500' AND CHEKBKID <= 'JODCA-500'

AND ((Recond = 0 AND VOIDED = 0) OR (VOIDED = 1 AND VOIDDATE > '20101231'))

AND TRXDATE >= '19000101' AND TRXDATE <= '20101231'

AND CMTrxNum >= '' AND CMTrxNum <= 'øøøøøøøøøøøøøøøøøøø')

Last condition (AND CMTrxNum <= 'øøøøøøøøøøøøøøøøøøø') is the one used to filter characters to display only “CMTrxNum“ that has special characters.

I posted this case in the Microsoft Dynamics GP Newsgroup under this link, and a great guy called Robert Cavill gave me a great tip on the source of the “ø” character, it seemed to be that the character is the 'fill' character used by Dexterity to get the upper limit of characters for the given collation This character is generated when first initiating the Dynamics GP session, with the SQL, below is the command that returns this character:

exec master..smDEX_Max_Char

This character is being changed from collation to another and not sure why this was the generated one based on my collation.

However, I excluded this character from the stored procedures to get the next max character and the issue was resolved.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Monday, March 1, 2010

Post Dated Checks in Dynamics GP

Since long time ago, I used to hear that partners develops tools that manages post dated checks, in Microsoft Dynamics GP, there is a build in module that covers all the needed requirements out of the box, that’s why I thought I should post few screenshots about this module:

After installing the “Payment Document Management” module from CD1, you will need to go to “Microsoft Dynamics GP menu >> Tools >> Setup >> Company >> Payment Document Setup” and activate the module, you can activate it for both Sent and Received checks:

image

After activating the module to work with AP or/and AR, you will need to setup you checkbooks, first lets start with AP module, go to “Cards >> Purchasing >> Payment Document Maintenance” and setup your post dated checks checkbook:

image

Proceed with preparing your manual payment, and notice the “Payment Document Entry” menu added under “Additional”:

image

After filling the check information, you will need to setup the due date for the check in addition to any other user defined information needed:

image

After finalizing all manual payment transactions, you could manage you posted checks from “Transactions >> Purchasing >> Payment Document Settlement” where you can select your documents and select the destination checkbook where the check will be moved:

image 

Clicking Payment Docs. will open a form where you can select the due checks and process it as needed:

image

Processing the check will perform all the needed transaction to settle the check and finalize the payment, the same concept applied to the AR with further options that allows , create a new cash receipt and notice the additional menu:

image

After filling the check information, you will need to setup the due date for the check in addition to any other user defined information needed:

image

As same as the AP module Sales Payment Document Settlement form is exist to settle the check, with options that includes Collect, Discount and Reject Discount:

image

Hope that I clarified enough, please don’t hesitate to contact me for any further inquiries.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Related Posts:

Related Posts with Thumbnails