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
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
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
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
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
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
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
Have you ever tried to locate manufacturing registration keys form? Frank found it! 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
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
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
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
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
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
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:
5. Click on “Sessions” tab and configure this settings:
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
Last week I been out of reach in a personal trip to Lebanon, it was great! Below is my son in Syda:
Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
mohdaoud@gmail.com
mohdaoud.blogspot.com
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
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
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
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
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
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
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
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:
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:
To correct this, you must change your settings in SOP Setup options to allow Sales of Discontinued Items:
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:
Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
mohdaoud@gmail.com
mohdaoud.blogspot.com
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:
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
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:
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:
Proceed with preparing your manual payment, and notice the “Payment Document Entry” menu added under “Additional”:
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:
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:
Clicking Payment Docs. will open a form where you can select the due checks and process it as needed:
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:
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:
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:
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
