Browse by Tags
All Tags » Tips and Tricks ( RSS)
-
|
Please be careful with this one. I’ve tested it thoroughly and can’t find an issue…but it does involve editing tables through SQL. It is possible that custom reports etc. that are taking data from different tables may not like these...
|
-
|
One of those great blog posts that solves a request we’ve all been asked at some stage, this one comes via Frank Hamelly , Ron Wilson and Sivakumar Venkataraman and the Dynamics Community ( https://community.dynamics.com/forums/32.aspx ). Check...
|
-
|
To resolve, install a fresh instance of GP on a different mchine and choose to install Analytical Accounting. Then run utilities, added the sample company data (even though I don’t think this is required), and close out of utilities. Then go to...
|
-
|
When you get this message in Bank Management, usually first noticed in the Chequebook Maintenance window, its normally caused by a network error or as the result of a workstation or system crash. The first port of call will always be to clear the Bank...
|
-
|
Thanks to Vaidy , I visited Leslie Vails Dynamics Confessor Blogspot and found this little gem. New in version 10, you can now tell the dex.ini where to create reports and forms dictionaries for exploding chunks. No need to explode your chunk and then...
|
-
|
Trying to open a document in SOP and you get told the following? Your previous transaction-level posting session has not finished processing. Please allow time for it to finish. Second most asked question in support…this occurs when posting routines...
|
-
|
For years I laboured away in ignorance until I found a simple solution to a big problem by editing the dex.ini. This whetted my appetite for more! The list of settings below is not exhaustive but hopefully gives you some idea of the power of this little...
|
-
|
To enable this feature you need to select the ‘Enable Reverse Charge Taxes’ option in Company Set up – (Microsoft Dynaics GP >> Tools >> Set Up >> Company >> Company…and click the Options button). Depending on your set up, you...
|
-
|
When the user launched the Business Portal website, and navigated to enter a purchase requisition for this new company, they could create the requisition header just fine. They clicked on the Add Item field to open the item selection window. Did a look...
|
-
|
Dan Sionov: http://accountingbot.com/wordpress/?p=61 Mariano’s first look at the support debugging tool: http://dynamicsgpblogster.blogspot.com/2008/08/first-look-at-support-debugging-tool.html
|
-
|
http://victoriayudin.com/2009/07/17/dynamics-gp-trial-balance-in-excel-using-frx/
|
-
|
Partnersource: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYKORSXPPNNWUNVVRWRTOXTUNUNPMQQOTSYWSXRXTVLYNPOZXR
|
-
|
Recently I had to do this. Always best to use standard functionality where available (Tools >> Utilities >> Inventory >> Change Decimal Places) ..but the following did the trick for a decimal increase… update iv00105 set decplcur...
|
-
|
The following will return the value of inventory on hand in each site. Good for verifying modified reports are accurate. SELECT a.ITEMNMBR, b.ITEMDESC, a.LOCNCODE, a.QTYONHND, a.ATYALLOC, b.CURRCOST, CASE WHEN b.VCTNMTHD IN (1, 2) THEN isnull(c.Value...
|
-
|
Check it out at http://www.rosebizinc.com/gpblog/2009/06/tips-from-noc-gp-10-server-pack.html
|
-
|
But…like a lot of issues…the answer was simple. My customer is based in Ireland. They pay suppliers in the US through a US bank. EFT is the way to go, so we use the standard GP functionality to produce an ACH file…but when we runit by...
|
-
|
You will need to create a modified version of the report you want in US date format. In GP 10, run the report and click on ‘Modify’. Once the report layout opens in Reort Writer, click on the toolbox and select Calculated Fields. Click on...
|
-
|
Came across this about two weeks ago with a client and was tearing my hair out trying to figure it out – comparing ‘good’ items with the ‘bad’ items across all inventory tables and such like. Eventually, the good people of...
|
|
|
|
|
|
|
|