December 31, 2010
December 28, 2010
December 23, 2010
December 6, 2010
November 18, 2010
October 11, 2010
You can now exclude all inactive account records from the Accounts lookup window.
Clear recurring batch amounts
You can now clear the distribution amounts for all transactions on recurring batches after posting a batch. You can navigate through the distribution lines and enter new amounts for each period.
Combine multiple General Ledger Budgets into a single, Master Budget
You can combine multiple General Ledger budgets into a single, Master Budget, one budget at a time. The Master Budget can be completely new and have its own Budget ID, or it can be one of the original budgets. This feature is helpful when multiple departments in your organization create their own budgets, which must then be consolidated. The new Combine Budgets window simplifies this process.
You can now create a transaction directly against a budget. You can view a list of budget transactions, make adjustments, and then update the budget from the list.
Comply with International Financial Reporting Standards (IFRS) requirements
October 9, 2010
In GP2010, you can embed any of a number of documents into the body of an e-mail message or send documents as attachments.
You can send a single document, batches of documents, or send multiple documents using the Lists functionality in GP. When setting up e-mail functionality, you can select which documents can be sent and which customers and vendors should receive their documents via e-mail. If you are using Word templates for Microsoft Dynamics GP, you can send predefined or customized forms.
A document can be sent in HTML, XPS, PDF, or DOCX file format type. You can also combine multiple documents to be sent in a single e-mail.
October 6, 2010
September 16, 2010
September 7, 2010
July 9, 2010
June 19, 2010
June 8, 2010
June 6, 2010
May 18, 2010
May 3, 2010
April 23, 2010
April 7, 2010
The short answer is no - unless you want to spend some $$ and hire MBS Professional Services to open the year in question for you. There are those who've tried it on their own and they report it as a very ugly process, resulting in the need to fix a lot of transactions.
April 5, 2010
Yes, you can but you need to make sure the Do not allow Non-Inventory Items box in Inventory Transfer Setup in PA Setup is unchecked.
March 26, 2010
March 25, 2010
GPTip42day - FRx - How do I setup my Balance Sheet to reflect current YTD balances before I've closed the previous fiscal year?
March 24, 2010
March 18, 2010
How do you transfer an inventory item from one project to another in Project Accounting? Use the Inventory Transfer transaction.
March 16, 2010
March 15, 2010
Need to do a recurring batch but none of the standard recurrence frequencies suit your needs? Use the Miscellaneous frequency. The Miscellaneous frequency allows you to specify the number of recurrences and the number of days between each recurrence. For instance, let's say you need to post the same transaction daily for 30 days. Here's what it would look like -
March 4, 2010
Occasionally, a batch will 'hang' during the posting process and not show as available to be recovered in Batch Recovery. When this happens, follow these steps to 'unstick' the batch. Note: to be performed by GP Administrators only.
1. Run the following script against the company database. Replace XXX with the batch number or the name of the batch that you are trying to post.
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'
Note: The value of BACHNUMB is the same as the Batch ID in GP.
2. View the contents of the SY00800 table located in the DYNAMICS database to determine the value of the DEX_ROW_ID field for the batch that you are trying to recover. You can view the contents of this table by running the following script:
SELECT * FROM DYNAMICS..SY00800
March 3, 2010
Have a look at my latest article on MSDynamicsWorld. This is the first of three articles leading up to my presentation at MSDynamicsWorld's virtual conference - Decisions2010 in May.
February 26, 2010
February 22, 2010
From the GP forums this morning comes the question 'How do I capitalize an asset without depreciating it?' The poster had received some fixed assets as gifts and didn't want to depreciate them. Here's how you do it - very simple.
February 16, 2010
CASE WHEN DATEDIFF(mi, P.last_batch, GETDATE()) > 1
THEN 'Idle for ' + LTRIM(RTRIM(STR(DATEDIFF(mi, P.last_batch, GETDATE())))) + ' minutes.'
END AS IDLE_TIME_DESC,
CASE WHEN DATEDIFF(mi, P.last_batch, GETDATE()) > 1
THEN DATEDIFF(mi, P.last_batch, GETDATE())
END AS IDLE_TIME,
LOGINDAT + LOGINTIM LOGIN_DATE_TIME,
DATEDIFF(mi, P.last_batch, GETDATE()) TIME_SINCE_LAST_ACTION,
FROM DYNAMICS..ACTIVITY A
LEFT JOIN DYNAMICS..SY01400 U ON A.USERID = U.USERID
LEFT JOIN DYNAMICS..SY01500 C ON A.CMPNYNAM = C.CMPNYNAM
LEFT JOIN tempdb..DEX_SESSION S ON A.SQLSESID = S.session_id
LEFT JOIN master..sysprocesses P ON S.sqlsvr_spid = P.spid
AND ecid = 0
LEFT JOIN master..sysdatabases D ON P.dbid = D.dbid
February 9, 2010
Occasionally, or maybe more often, you process a receiving transaction for a multiple of an Item at an Extended Cost that isn't evenly divisible by the quantity. Take a look at the screenshot below, for example.
February 8, 2010
I'll bet everyone has been wondering what the maximum note size is that can be entered into a note field. From our friend and GP developer extraordinaire, Mr. David Musgrave, the maximum number of characters a note field will hold is 32,000.
February 3, 2010
This question was posed on one of the forums yesterday. The answer is yes - hotfixes are cumulative - meaning they include all previous hotfix and service pack modifications to-date.
February 2, 2010
In GP10, you can print multiple sales invoices in one step. Select the Sales tile in the Navigation Pane, then select Receivables Transactions. Filter the resulting list for the type(s) of documents you want to print, date range, etc. When you have the list filtered, place checkmarks next to the documents you want to print and click Print Documents. All documents will be printed to the destination you select in the Print Destination window.
January 28, 2010
Debi Carlton of D1 Technologies posted this solution on one of the GP forums recently -
January 20, 2010
Note, this tip is for GP Administrators only. Attempts by non-administrators to change the system password could compromise data security!
Occasionally, the GP system password is forgotten or lost. This password is required to make changes at the system level, such as adding a new user, changing user security, etc. Here's how to recover when this happens.
1. In SQL Management Studio, run this script to remove the existing password -
SET PASSWORD = 0x0202020202020202020202020202020
2. In GP, reset the system password.
January 19, 2010
I get this question on a fairly regular basis. My response always is - what do you want to use the printer for? Invariably, the use is printing checks, invoices, etc, etc, etc. My recommendation is always - HP LaserJet. You just can't go wrong with a LaserJet. They work well with GP and supplies are readily available for them.
January 18, 2010
Need to reference the transaction(s) associated with a particular Audit Trail Code but can't seem to find a report that gives that to you?
Let's use Account Transactions in SmartList as an example. Open the SmartList, then add this column - TRX Source. There's your Audit Trail Code!
January 13, 2010
Somewhere along the line in GP10, the prior behavior of account lookups (where you type in the first few digits of the account, click the lookup button and it takes you to the beginning of the range) went wacky such that the lookup takes you to the very beginning of the chart of accounts.
January 6, 2010
Now's the time of year when many of us are reconciling our GL accounts to get ready for external auditors and closing the year. I personally spend a lot of time with my clients helping them reconcile Cash, AR, AP, and Inventory. Until now, it's been a matter of hunt & peck and a whole bunch of analysis to find the reconciling items.