Import opening transactions from Excel

  • 10 minutes

You can use RapidStart Services and Microsoft Excel to import opening transactions of several fixed assets at the same time. This capability could be useful and save time if a company has many fixed assets for which opening transactions should be posted.

Follow these steps to import opening transactions from Excel:

  1. Prepare a RapidStart package. In a new or existing RapidStart package, enter a line for table 5621 - FA Journal Line and select the fields to export to Excel.

  2. Export to Excel.

  3. Enter the opening transactions in Excel.

  4. Import from the Excel file in Business Central.

  5. Apply the package records.

  6. Post the journal lines.

Import opening transactions from Excel

Watch the following video to see a demonstration of importing opening transactions from Excel into Business Central.