Tag: utilities

Convergence 2012 Sessions I’m Presenting

This year at Convergence, I’ll be presenting three sessions, two on GPUG’s DayOne and one at Convergence on both Monday and Tuesday.  Here are the links to and descriptions of the sessions in the Convergence Session Catalog – DayOne – 13 Classic Underused Features in GP   DayOne – Word Up! Using Word Templates and Email in GP 2010 Ask the Experts: Financials for Dynamics GP Hope to see you there!

Continue Reading

Mass Item/Vendor Link

| 02/28/2012 | 0 Comments

  I got a request from one of my customers to have the ability to link multiple items with a vendor without the need to add them one by one and I have created this using the .Net toolkit, the screen will look like the below: The user can filter items from the list on the left panel, click on insert and process! The system will link the selected items with the selected vendor! I am willing to publish this tool soon, will update the article with the download link once doing some fine tuning on the utility. Regards, — Mohammad R.

Continue Reading

Field Level Security is not working!?!?

| 02/18/2012 | 0 Comments
Field Level Security is not working!?!?

  Few months back, one of my clients reported an issue with the field level security module in Dynamics GP that it only works for “Sa”, and this morning I noticed a question in the community reminding me to post about this issue! Below are the circumstances: 1. Only the sa user can see the module on GP even by giving the power user to other users

Continue Reading

Microsoft Dynamics Mayhem!!

Microsoft Dynamics Mayhem!!

Packt Publishing is crowning February, Microsoft Dynamics Mayhem, and celebrating its range of Dynamics books/e-books with exciting discounts. As the leading publisher of Microsoft Dynamics books/e-books and a multitude of bestsellers on NAV, AX, GP and Sure Step, not only do these titles excel in terms of quantity, but in quality, with each book garnering numerous positive reviews.  To celebrate this achievement, Packt has slashed cover prices by up to 30%, so go mad, go crazy and make the most of this mayhem. Recent Dynamics publications include: Microsoft Dynamics CRM 2011 New Features Microsoft Dynamics CRM 2011 Dashboards Cookbook Microsoft Dynamics NAV 2009 Professional Reporting Throughout 2012, Packt will continue to build-upon this success, with a focus on branching into different forms and formats such as a Dynamics Certification series.

Continue Reading

What happens with Landed Cost when you perform a Returns Transaction in GP2010?

This question popped up on the Microsoft Dynamics Community today so I thought I’d share the answer here.   The new functionality in GP2010 that edits the original PO for a purchase return (or creates a new one if the original is closed) is awesome.  Not sure why it took this long to add that functionality but it is what it is.  However, there is no facility in the Returns Transaction to reverse the Landed Cost on the original receipt, so GP writes the value of the Landed Cost to Purchase Price Variance .  Not the ideal way to handle it but at least it doesn’t leave that cost sitting in inventory, if the return is an inventory item.  *click image to enlarge P.S

Continue Reading

Vendor Statement with Analytical Accounting Information

| 01/29/2012 | 0 Comments
Vendor Statement with Analytical Accounting Information

  one of my clients is a constructions firm whose not interested to activate the project accounting and wanted to distribute their project management over analytical accounting dimensions. Therefore we have implemented Dynamics GP and created dimension for projects to distribute all expenses accounts of analytical accounting codes. One of their requirements been to have a vendor statement per project which is reasonable for such a line of business, therefore I have created the below view that extracts the information including from AP, GL and AA and wanted to share the idea to avoid reinventing the weel for people who works with the same situation, below is the script I used: DECLARE @FROMDATE DATETIME DECLARE @TODATE DATETIME DECLARE @FROMVENDOR VARCHAR ( MAX ) DECLARE @TOVENDOR VARCHAR ( MAX ) SET @FROMDATE = ’1900-01-01′ SET @TODATE = ’2017-04-17′ SET @FROMVENDOR = ‘ACETRAVE0001′ SET @TOVENDOR = ‘BLOOMING0001′ SELECT ‘Beginning Balance’ AS TRXSOURCE , @FROMDATE AS DOCDATE , ‘Beginning Balance’ AS DOCNUMBER , VENDORID , SUM ( CREDIT ) AS CREDIT , SUM ( DEBIT ) AS DEBIT , VENDNAME , ‘Beginning Balance’ AS VCHRNMBR , ‘Beginning Balance’ AS TRXDESC , 0 AS JRNENTRY , 0 AS aaGLHdrID , aaTrxDimCode , aaTrxDimCodeDescr , ” AS LOCNCODE FROM ( SELECT DISTINCT VENDORTRANSACTION .

Continue Reading

Give me 5–The Dynamics Promotion

| 01/29/2012 | 0 Comments

    For those who are still thinking about when to purchase Dynamics ERP’s, I wanted to remind you that the give me 5 promotion which will allow you to purchase 5 users for 3,000$ is around to expire, and you have less than 22 days to take the decision! Below what quoted from Microsoft Dynamics Website: Get 5 users for one low price To renew or not renew, that is the question. Your annual maintenance agreement is right around the corner. You know that the money you spend year after year provides little value and keeps you tied to software that hinders your business growth.

Continue Reading