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.