Did you know that you can Copy/Paste data from Excel spreadsheet to Microsoft Dynamics GP's Journal Entry screen easily? With the latest version, you also allow to copy the Analytical Accounting, which is the Dimension code too. Refer to steps below on how to do it. Copy/Paste Excel (without Analytical Accounting) i. Prepare a spreadsheet with 4 columns in order as shown below screenshot. ii. Copy only the data area, not including the header, or it will gives you error message. iii. Select "Paste" in the Financial Transaction Entry. iv. What is being copied from spreadsheet will be pasted accordingly. To proceed, fill up the Batch ID and Reference field. Copy/Paste Excel (with Analytical Accounting) i. Same steps to prepare spreadsheet with analytical accounting (AA) data, just add additional new column "Alias" to include the AA info. (Alias need to setup in GP before proceed with this Copy/Paste feature) ii. Continue copy and ...
Act as Microsoft Dynamics GP Consultant nearly 10 years now, based in Malaysia. Following an early career as statutory auditors and independent accountants to a range of growing businesses in the finance industry, later moved into the area of IT in business with the expansion of technology. Offering implementation, support and training Microsoft Dynamics GP to customers for more than 10 projects across ASEAN region. Now we are offering Dynamics 365 Business Central implementation too.