FRX - To change the path of SYSDATA folder outside FRx

Today I learned a new lesson about FRx.

If you want to change the path of the SYSDATA folder, you should not only change in FRX32.CFG file (which is available in the installation folder of FRx), but also you should change it in FRxConfig.xml (which is available in C:\Users\username\AppData\Local\FRx Software\FRx 6.7)

Fixed Asset Disposal in Quantity

One new thing which I learned about GP today is that it is possible to dispose an asset in Quantity too. So, while retiring an asset, you can key in the quantity (instead of value or percentage) for retirement. System will automatically calculate the percentage.

How to setup integration using Integration Manager for integrating Journal Entries with Analytical Accounting Codes?

This solution is based on the following link.

http://support.microsoft.com/kb/2687958

The below solution is with a minor modification to the above one i.e., for a Reversal Journal Entry.

(Please note that you need to install 'eConnect Destination Adapters' feature for Integration Manager for this solution. This can be installed using the Installation Setup of Integration Manager.)

To setup integration using Integration Manager for integrating Journal Entries with Analytical Accounting Codes, follow the below steps.

1. Open Microsoft Excel.
2. Prepare the excel sheet with the following columns.
3. Populate data to the above columns.
4. Save the excel sheet as AA GL Trx.xlsx
5. Save the excel sheet as Text (Tab Delimited) with the file name as AA GL Trx.txt
6. Close the excel sheet.
7. Open another excel.
8. Prepare the excel with the following columns.
9. Populate data to the above columns.
10. Save the excel sheet as AA GL Trx with Dim.xlsx
11. Save the excel sheet as Text (Tab Delimited) with the file name as AA GL Trx with Dim.txt
12. Open Integration Manager.
13. Click on New Integration.
14. Give 'Integration Name' as GL Transaction - AA.
15. Click on OK.
16. Click on Add Source.
17. Select Text under the folder 'ODBC/Text'.
18. Select on 'Define New Text' and click on Open.
19. Give Name as 'GL Header'.
20. Select the file AA GL Trx.txt 
21. Select Tab under Delimiter Section.
22. Select 'First Row Contains Column Names' checkbox.
23. Click on Sorting Tab.
24. Select the columns such as Batch ID, JournalNum, TrxDate, RevDate, TrxTyp and Reference under 'Group By' section.
25. Click on OK.
26. A warning will be displayed, Click on OK.
27. Click on Add Source.
28. Select Text under the folder 'ODBC/Text'.
29. Select on 'Define New Text' and click on Open.
30. Give Name as 'GL Distributions'.
31. Select the file AA GL Trx.txt 
32. Select Tab under Delimiter Section.
33. Select 'First Row Contains Column Names' checkbox.
34. Click on OK.
35. A warning will be displayed, Click on OK.
36. Click on Add Source.
37. Select Text under the folder 'ODBC/Text'.
38. Select on 'Define New Text' and click on Open.
39. Give Name as 'GL AA Dimension'.
40. Select the file AA GL Trx with Dim.txt 
41. Select Tab under Delimiter Section.
42. Select 'First Row Contains Column Names' checkbox.
43. Click on OK.
44. Click on Add Source.
45. Select Text under the folder 'ODBC/Text'.
46. Select on 'Define New Text' and click on Open.
47. Give Name as 'GL AA Dimension Code'.
48. Select the file AA GL Trx with Dim.txt 
49. Select Tab under Delimiter Section.
50. Select 'First Row Contains Column Names' checkbox.
51. Click on OK.
52. Double Click on 'Query Relationships'.
53. Set the relationship as follows.
54. Click on 'Add Dest.'
55. Open 'Microsoft Dynamics GP eConnect' folder by clicking on + sign next to the folder.
56. Click on Financial Folder.
57. Select 'GL Transaction'.
58. Click on Open.
59. Double click on 'Destination Settings'
60. Give the database server name for 'Server Name'.
61. Give the company database name for 'Company Database'.
62. Click on Close.
63. Double click on 'Destination Mapping' (or Click on Mapping button in the toolbar).
64. Click on 'GL Transaction' folder on the top left hand side.
65. Set the mappings as shown below.

66. Click on 'Entries' folder.
67. Set the mappings as shown below.

68. Click on 'Analytics' folder.
69. Set the mappings as shown below.

70. Click on 'Dimensions' folder.
71. Set the mappning as shown below.

72. Click on Save button to save the integration.
73. Click on Run to run the integration.

Note : Unlike normal integration, this integration will run for the company which is setup in the 'Destination Settings' i.e., you would not need to login to any GP companies to run this integration.

How to export/import integration(s) from/to Integration Manager?

To export integration(s) from Integration Manager, please follow the below steps.

1. Open Integration Manager.
2. Click on Tools >> Create Database.
3. Click on Folder Dialog button.
4. Select the location where you want to create the database.
5. Give a file name and click on Save.
6. Click on File >> Export Integrations.
7. Select the integration which you would like to export.
8. Click on Export.
9. Select the file which you created in Step 5.
10. Click on Open.

To import, please follow the below steps.

1. Open Integration Manager.
2. Click on File >> Import Integrations.
3. Select the .imd file which is exported from Integration Manager.
4. Click on Open.

Shortcut Key to open Dynamics GP

To setup a shortcut key to open Dynamics GP, follow the below steps

1. Right click on Dynamics GP icon (which is available either on Windows desktop or in Start menu).
2. Select properties.
3. Click on Shortcut key.
4. Press the key combination (for eg. CTRL + ALT + G) which will be used to open Dynamics GP.
5. Click on OK.

How to disable/enable Analytical Accounting?

To disable Analytical Accounting, follow the below steps

1. Open Customisation Status from Microsoft Dynamics GP >> Tools >> Customise >> Customisation Status.
2. Select Analytical Accounting.
3. Click on Disable if it is enabled or vice versa.

Shortcut Keys for Dynamics GP

CTRL + L
To display lookup window

ENTER
Will execute the default button in GP Window. Most of the GP windows are having SAVE button as default button. Hence, hitting an ENTER button will save the record (which is same as clicking on SAVE button)

ALT + F11
To open Visual Basic Editor

CTRL + F11
To add current window to Visual Basic

SHIFT + F11
To add fields to Visual Basic

ALT + F9
To open Report Writer

CTRL + F9
To modify current report

CTRL + A
To select all text in a field.

CTRL + C
To copy the selected text.

CTRL + X
To cut the selected text.

CTRL + V
To paste the copied text.

ALT + F4
To close a window.

CTRL + P
To print an Edit List.