Copy/Paste A Journal Entry Into Dynamics 365 Business Central

-
Originally posted January 29, 2020

One of my favorite features within Dynamics 365 Business Central is the ability to copy & paste into a General Journal entry. This is something I always train super users on during implementation and it’s one of the most exciting features in my opinion. 

In order to be able to copy/paste into the journal formatting may need to be done beforehand. What I mean by this is your Excel spreadsheet must have the same number of columns as the journal does within BC. Below is an example of how I have my journal columns setup within BC. You can see I also have my Excel spreadsheet setup the same.

Setup

Business Central:



Excel:


Copy/Paste

Excel:

Simply highlight the information with Excel that you're looking to paste into BC. Tip: there is no need to include the header row in this selection.


Business Central:
Within BC open the General Journal and right click within the Posting Date field and select Paste. While the system is pasting the information into BC it is also validating the information making sure the Account Type and Account No. are correct. The system will not validate that the entry is in balance however.
Before:


 After:


Account Number Doesn't Exist


If the account number isn't correct or doesn't exist within BC then you'll get an error message as shown below. Once an issue is detected the rest of the entry will not paste into BC. Simply fix the issue within Excel or BC and delete out the lines that have pasted within BC and re-paste everything again.  





Comments

Post a Comment

Popular posts from this blog

Microsoft Dynamics 365 Business Central: adding new licensed users to BC

-
Image
Adding a new licensed user isn't hard to do within Business Central (BC).  Prerequisite: license is purchased and available to assign to user. You also must be an Internal Admin or have proper security within BC to complete these tasks.  Microsoft 365 admin center Assign BC license to user. Dynamics 365 Business Central Navigate to Users page. Select Process > Update users from Microsoft 365 Update users from Microsoft 365 > Next Update users from Microsoft 365 > Next Update users from Microsoft 365. Review the updates within this window and click finish. Lastly assign user group or permission sets and assign company access.  Version: US Business Central 22.1 (Platform 22.0.58213.0 + Application 22.1.55890.56216) Written by: Kristen Hosman, Microsoft MVP
Read more

Dynamics 365 Business Central - Is this a feature or a bug? Filtering and posting General Journal lines

-
Image
This blog is inspired by something I just learned from James Bowles .  Scenario: I have a General Journal with multiple lines and only want to post certain transactions/lines.  In my example I am going to filter on the Posting Date field so only the 04/30 transaction is posted. Once the posting is completed you will see the remaining lines in the journal.  Review the General Ledger Entries and you see only entry posted was the 04/30. Written by: Kristen Hosman, Microsoft MVP
Read more

Invited External Accountant in Dynamics 365 Business Central now what?

-
Image
This blog describes what comes next after you invite an External Accountant. If you need to invite an External Accountant than visit this blog:  Invite External Accountant in Dynamics 365 Business Central (kristenhosman.com) You've invited an External Accountant now what? What happens after you've successfully invited an External Accountant? You receive the below message in Dynamics 365 Business Central and your external accountant receives an email.  Steps your External Accountant should take Have your external accountant look for an email with a subject line: You have been invited to Microsoft Dynamics 365 Business Central. The external accountant should click on the link provided in the email. They will be redirected to a Microsoft sign in window. In my case the external accountant email isn't listed so I'm going to select use another account. Enter email. Next window suggests that a code was sent to email. Go pull code from email and enter into next window. Accept t
Read more