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
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.
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
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 .
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.
Round 1 of the 2012 tax tables have been re-released to reflect the changes made by congress to extend the 2% tax holiday. Make sure you have the new tables or you will be buying yourself a lot of heartache. Get the new tax tables from PartnerSource: 2012 Tax Tables from PartnerSource Until next post! Leslie