web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Dynamics GP Support and Services Blog / Microsoft Dynamics GP - Web...

Microsoft Dynamics GP - Web Client Excel Copy and Paste General Ledger Journal

Views (2009)
Isaac Olson Profile Picture Isaac Olson Microsoft Employee

This was one of the most requested features from the customer community, and because of the complexity of Web Client this was not an easy task, but you asked and its finally here!!! 

With the new release you can now import journal entry lines from an excel file using the Paste button on the menu bar of the General Ledger Transaction Entry window.   Just like the desktop client, the format of the data in your excel file is the same with the exception that you must not have a header line on your file.  In my below example, the first row contains headers that describe each column.  

NOTE:  There is no header information in the Excel document
This feature does not copy AA (Analytical Accounting) information in web client only, vote on this suggestion.

             excel.jpg

To access this feature in Web Client, Expand the Area Pages menu on the left navigation pane and click on Financial Microsoft Dynamics GP menu, then under Transactions, Financial, Click General.  This opens the Transaction Entry window with a new Journal Entry.   Click the ‘Paste’ button on the menu to open a Browse window, where you can select the Excel file holding your Journal Entry data.  This is slightly different from the Desktop Client as we do not actually paste the data, all data on the selected excel file will be imported to your Journal Entry. 

                                  6505.trx.jpg

Browse to the location of the Excel file, select it on the list and click the Open button.

                trx2.jpg

Upon Clicking the Open button, the Journal Entry lines from the Excel file will be pasted/imported into the window.  A spinning circle indicating that the process is still working will appear between the SmartList link and the User Date on the Microsoft Dynamics GP Menu Bar.  This will disappear once the process has completed.  Please wait for the process to complete before continuing to other activities in your Web Session. 

 

blu.jpg

A report will print only if there are errors detected in the file such as invalid accounts.  

Note: The Paste button will only be enabled if you are entering a new Journal Entry.  Existing Journal Entries are not compatible with this feature in the Web Client or Desktop Client. 

Note: All data on the Excel file will be pasted into a single Journal Entry, so you must have one file per Journal Entry that you are intending to upload.  

Transaction in web client after the above process.

 

            trx3.jpg

For more documentation on our new features please check out our Microsoft Dynamics GP New Feature Blog Series!

Isaac Olson

Microsoft Support

Comments

*This post is locked for comments

  • GPTech Profile Picture GPTech 16
    Posted at
    Hi Isac , Can we just upgrade the Web Client Version Only and leaving Windows Client on as it is on Existing version Dynamics GP 18.00.0628 & Dexterity 18.00.0015. Let me know the best way to approach and resolve the issue. Thanks
  • GPTech Profile Picture GPTech 16
    Posted at
    HI Isac, thanks for your response , You are right , we are on Dynamics GP 18.00.0628 & Dexterity 18.00.0015 , so this is the version limitation on web client , we are planning to look for upgrade and see the out Come. Thanks
  • Isaac Olson Profile Picture Isaac Olson Microsoft Employee
    Posted at
    Hello, This feature was not coded to be fully compatible with Web Client until this feature was released in version 18.2.1013 and higher. Which would have been the October update in 2019. In this case it sounds like you are on GP 2018 R2, which would be before this release so unfortunately this feature would not work until you upgraded to a version with this feature. We had to code it to work completely different in Web Client due to the Browser not being able to talk directly to Excel like the Desktop Application does. If you are on a version 18.2.1013 or higher and you are seeing the behavior that you described, then I would recommend opening a support case with us and we can dig into the issue further with you. I hope this helps, Isaac Olson Microsoft Support
  • GPTech Profile Picture GPTech 16
    Posted at
    HI Isac, I ran with weird behaviour of Web Client , I am using GP2018R2 Excel Paste to GL Transaction to bring entry in to GL Transaction in Web Client for my Excel sheet to be uploaded or read. But instead of open window to select Excel worksheet (upload) , it download an empty the Excel worksheet to the local system from where i connecting to web client, The Excel Paste to GL Transaction function is working well in Windows GP Client Installation. Have anyone face the similar issue , any suggestion ? . Environment : Windows Server 2019-office 2016 , widows 10 , office 2016 & 19 Thanks ,