Rename the node to Add Offsetting distribution. Select the taGLTransactionLineInsert Node.Īfter it is added to the Transaction Type, right click and choose Edit Node. Right Click and choose Add Existing Node. Open the Node Maintenance window from the SmartConnect Maintenance menu option and the GP Connector Pane. This is especially useful if there is a decimal place issue and we don’t want to have to manually change the file before integration. The method would be to add an Offsetting Distribution node to your General Ledger Transaction Type and calculate the offsetting value. There is a workaround that can eliminate ever getting this error but it may not result in the desired journal entry if some of the distributions are not being integrated. This method can assist with finding that one distribution in a potentially long list of distributions. When running a GL Journal Transaction through SmartConnect and the error comes back as Error 944, we know that Microsoft eConnect is unable to balance the journal automatically.
Opening the file in Excel does allow for quickly adding sums to each amount column and seeing the difference. Once it has been verified the decimal places are all as expected, open the file in Excel, go to the bottom of the Debit and Credit Columns and
The reason for not opening it in Excel first, is Excel may format the amounts to only show 2 decimals and now it becomes more difficult to track down the invalid distribution(s). Open the file in Notepad or Notepad++ and verify the amounts are correct. Here is the XML Transformation logic that can be copied to a file with the extension XSL. The CSV can also be opened in Excel easily if needed. The example uses a CSV file since Excel will format the data and potentially hide the results. The destination can be either a CSV file or an Excel file. With this new utility map, our source will be an XML Query, pointing to the XML file generated in the prior step including an XSL transformation to get the data into the right format. I have highlighted the fields that would need to be updated in the screen shots below. If you load the sample map, the paths will need to be changed to match your system and file names.
Gp 80220ii printer drivers download download#
You can download the sample map (SmartConnect 20.18.0.9 and above), sample source file and XML transformation here. We need the XML file that represents the out of balance journal entry.Ĭreate a new map that will use the resulting XML file from the first step. When the map runs it will create an XML file for each journal that would be created based on the selected Key Field. The first step is to change the Destination to Dynamics GP – File and enter a path to create the eConnect XML file. The Key Fields setting determines how the data is grouped.
Check that you are not restricting any records that would cause the transaction to be out of balance.
Gp 80220ii printer drivers download how to#
This article will show how to reduce the number of destination columns to just the journal number and amounts so we can validate the expected values. The difficulty with this error is eConnect cannot not show which distribution(s) causes the transaction to be out of balance and with large Journals, searching through a source file or resulting eConnect XML can take hours to find. One of the most fun (insert sarcastic emoji) items to troubleshoot is eConnect error 944, Unbalanced journal entry, the credits do not equal the debits.