Friday, August 29, 2014

Copy to GL functionality in Dynamics GP 2013 R2

In GP 2013 R2, Accountants now have the ability to quickly copy data from an excel file and paste into the Financial Transaction Entry form.

Please find the below precise step to achieve this

1) Make sure accounting distribution excel ready as mentioned in the below format

2) Open the Journal Entry screen, enter the header details

3) Copy the excel values by excluding headers and click Paste Button from this window

4) The Distribution lines paste accordingly mentioned in the excel

Note: if the excel was not in the proper format, GL Transaction Validation Report appears to highlight the missing and format details

Post your comments regarding to this blog.

Natarajan S

No comments:

Post a Comment