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.
Regards,
Natarajan S
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.
Regards,
Natarajan S
No comments:
Post a Comment