Skip to main content

How to Import Data from Excel in Business Central

Did you know you can use Excel to import data such as Payable and Receivable transaction into Business Central? This feature is available in both BC On Prem and BC Cloud.

 

Page: General Journals


            1.       To start preparing data in Excel, first, you will need to prepare a “Template” from BC, so that it gives you a guide where to key in the data that you need in Excel later. Create an entry in General Journals screen.


    Note: You can exclude the fields by hiding some of the columns on the General Journal page, you can use the Personalise feature to hide the unused columns. Click here to check how you can customise the fields in General Journal page.



        2.        You will need to copy the entry created. To select the line, select Option > Select More.



            3.       Once the line is selected, copy the line by using the keyboard shortcut key [CTRL + C]. You should see a message pop up saying, “1 row copied”.






            4.       Paste the data to Excel. A “Template” is now created in Excel. Take note that the user must not add additional column in between the “Template”, as all the field is mapped according to BC General Journal field.





            5.       Once the data is prepared, copy the field in Excel that need to import to BC.






            6.       Select the new line in General Journals and click on the “More Option” area which just next to the Posting Date field (refer to screen show below with light blue color area). Select the keyboard shortcut key for Paste [CTRL + P] to paste the data.






            7.       The data copied is now pasted into the field the same as prepared in Excel. You may proceed to verify the data before posting.



















Comments

Popular posts from this blog

How to Reverse Posted Documents in Business Central

  If you need to amend or change a posted documents in Business Central, there are few ways to do it instead of having you to manually create a reversal journal or Credit Memo to rectify a Posted Document. Before you proceed to Correct or Cancel any document that posted in Business Central, you need to identify the origin of the posted document, as the method of cancellation depends on the document type.   There are 2 types of documents that posted in Business Central. i.                      Journals – E.g., General Journals, Purchase Journals, Payment Journals, Sales Journals, Receipt Journals etc. ii.                    Documents – E.g., Purchase Invoice, Purchase Credit Memo, Sales Invoice, Sales Credit Memo etc.   A.       A.     C orrecting ...

Foreign Currency Revaluation in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central (BC) allow users to account for foreign currency transactions. BC also able to translate the registered foreign currency amount into functional currency that setup in the entity using the conversion rates which setup in Exchange Table.   Due to the exchange rates fluctuate constantly, as a dollar worth in foreign currency today might not equivalent to the same foreign currency worth the next day. Hence, users are required to adjust the open documents that transact in foreign currency which include open invoices, credit memos, and advance payments. Once the open documents transacted in foreign currency is revalued, the gain and loss which calculate after comparing the closing rates at the period end will be posted to profit and loss as unrealised gain and loss, ensuring that the subledgers and general ledger can be reconciled.   This process can be done using Adjust Exchange Rate in BC, a batch job to adjust the exchange rates fo...

Disposal of Fixed Asset in Business Central

You can perform Fixed Asset Disposal in Business Central in Fixed Asset G/L Journals . The reason for performing fixed asset disposal may be result of several events: i.                       An asset is fully depreciated and must be disposed of ii.                        An asset needs to be removed due to unforeseen events (EG., theft) iii.                     An asset was captured with wrong information and need to be reversed   In the following example here, the user has registered the asset in the fixed asset book, and there is depreciation being perform too, but later identified that the asset was registered with wrong date. It will be easier to dispose this asset and capture again using new Fixed Asset ID...