This app exports data from Microsoft Business Central in accordance with the tax amendment law $121 paragraph 3 and the federal tax code $132 paragraph 3.
Current Version: 1.0.0.0as of Business Central 21.
Manual
Creation date: 2024/11/22 The current version of this manual can be found at:
☰ Contents
General
App *BAO Export* The BAO Export app exports data from Microsoft Business Central in accordance with the tax amendment law $121 paragraph 3 and the federal tax code $132 paragraph 3...
Tasks
Working with the App
Appendix
Release Notes
Docs / NVXBAOE BAO Export / General General
The BAO Export app exports data from Microsoft Business Central in accordance with the tax amendment law $121 paragraph 3 and the federal tax code $132 paragraph 3.
The following exports are available:
BAO G/L Entry Export
BAO G/L Account Export
BAO G/L Register Export
BAO Customer Export/li>
BAO Customer Entry Export
BAO Vendor Export
BAO Vendor Entry Export
BAO FA Depreciation Book Export
BAO FA Entry Export
The app writes the data in CSV files, i.e. separate files are created for G/L entries, customer entries, fixed assets, vendor entries, etc.
A CSV file is a text file in ASCII format with delimited characters and can be opened directly with MS Excel.
This makes it possible to check the data in Excel in advance.
Docs / NVXBAOE BAO Export / Tasks Working with the App
The following exports are available with the app:
BAO G/L Entry Export
1. Select the Search action and enter the term BAO G/L Entry Export and select the report.
2. The Request Page opens:
The report exports the following fields:
G/L Account No.
G/L Account Name
Posting Date
Description
Amount
VAT Amount
Field
Description
Field Separator
Here you can specify a separator. The default delimiter is tabulator (TAB).
Export EB
You can set a checkmark into the field if you also want to export the G/L account balance (balance to date) and use a date filter. The application sets the dimension filter 1 and 2 automatically.
Export Advanced Information
If you want to export extended information (Entry No., Document Type, Document No., Source Type, Source No., Source Name, Gen. Posting Type, Gen. Bus. Posting Group, VAT Bus. Posting Group, Gen. Prod. Posting Group, VAT Prod. Posting Group), set a checkmark to the field.
BAO G/L Account Export
1. Select the Search action and enter the term BAO G/L Account Export and select the report.
2. The Request Page opens:
The report exports the following fields:
No.
Name
Income/Balance
Net Change
Field
Description
Field Separator
Here you can specify a separator. The default delimiter is tabulator (TAB).
Export EB
You can set a checkmark into the field if you also want to export the G/L account balance (balance to date) and use a date filter.
Export Advanced Information
If you want to export extended information (Balance at Date, No. 2), set a checkmark to the field.
BAO G/L Register Export
1. Select the Search action and enter the term BAO G/L Register Export and select the report.
2. The Request Page opens:
The report exports the following fields:
G/L Register No.
G/L Register
Creation Date
G/L Register From Entry No.
G/L Register To Entry No.
Entry No.
G/L Account No.
G/L Account Name
Posting Date
Document Type
Document No.
Description
Gen. Posting Type
Gen. Bus. Posting Group
VAT Bus. Posting Group
Gen. Prod. Posting Group
VAT Prod. Posting Group
Amount
VAT Amount
Field
Description
Field Separator
Here you can specify a separator. The default delimiter is tabulator (TAB).
Date Filter (G/L Entry)
Here you can specify a date filter.
Export Advanced Information
If you want to export extended information (Source Type, Source No., Source Name, Bal. Account No.), set a checkmark to the field.
BAO Customer Export
1. Select the Search action and enter the term BAO Customer Export and select the report.
2. The Request Page opens:
The report exports the following fields:
No
Name
Net Change (LCY)
Field
Description
Field Separator
Here you can specify a separator. The default delimiter is tabulator (TAB).
Export EB
You can set a checkmark into the field if you also want to export the customer account balance (balance to date) and use a date filter.
Export Advanced Information
If you want to export extended information (Balance (LCY), Balance at Date (LCY)), set a checkmark to the field.
BAO Customer Entry Export
1. Select the Search action and enter the term BAO Customer Entry Export and select the report.
2. The Request Page opens:
The report exports the following fields:
Customer No.
Customer Name
Posting Date
Amount (LCY)
Remaining Amt. (LCY)
Field
Description
Field Separator
Here you can specify a separator. The default delimiter is tabulator (TAB).
Export EB
You can set a checkmark into the field if you also want to export the customer account balance (balance to date) and use a date filter.
Export Advanced Information
If you want to export extended information (Entry No., Document Type, Document No.), set a checkmark to the field.
BAO Vendor Export
1. Select the Search action and enter the term BAO Vendor Export and select the report.
2. The Request Page opens:
The report exports the following fields:
No.
Name
Net Change (LCY)
Field
Description
Field Separator
Here you can specify a separator. The default delimiter is tabulator (TAB).
Export EB
You can set a checkmark into the field if you also want to export the vendor account balance (balance to date) and use a date filter.
Export Advanced Information
If you want to export extended information (Balance (LCY), Balance at Date (LCY)), set a checkmark to the field.
BAO Vendor Entry Export
1. Select the Search action and enter the term BAO Vendor Entry Export and select the report.
2. The Request Page opens:
The report exports the following fields:
Vendor No.
Vendor Name
Posting Date
Amount (LCY)
Remaining Amt. (LCY)
Field
Description
Field Separator
Here you can specify a separator. The default delimiter is tabulator (TAB).
Export EB
You can set a checkmark into the field if you also want to export the vendor account balance (balance to date) and use a date filter.
Export Advanced Information
If you want to export extended information (Entry No., Document Type, Document No.), set a checkmark to the field.
BAO FA Depreciation Book Export
1. Select the Search action and enter the term BAO FA Depreciation Book Export and select the report.
2. The Request Page opens:
The report exports the following fields:
FA No.
Fixed Asset Description
Department Code
Depreciation Book Code
No. of Depreciation Years
Depreciation Starting Date
Acquisition Cost
Depreciation
Book Value
Proceeds on Disposal
Custom 2
Field
Description
Field Separator
Here you can specify a separator. The default delimiter is tabulator (TAB).
BAO FA Entry Export
1. Select the Search action and enter the term BAO FA Entry Export and select the report.
2. The Request Page opens:
The report exports the following fields:
Entry No.
G/L Entry No.
Tax Area Code
FA No.
Fixed Asset Description
FA Posting Date
Posting Date
Document Type
Document No.
Document Date
Description
Starting Date
Depreciation Book Code
FA Posting Category
FA Posting Type
Amount
VAT Amount
Debit Amount
Credit Amount
Reclassification Entry
Part of Book Value
Part of Depreciable Basis
Disposal Calculation Method
Disposal Entry No.
No. of Depreciation Days
Quantity
FA No./Budgeted FA No.
Straight-Line %
No. of Depreciation Years
Fixed Depr. Amount
Declining-Balance %
Depreciation Table Code
Bal. Account Type
Gen. Posting Type
Gen. Bus. Posting Group
Gen. Prod. Posting Group
FA Class Code
Field
Description
Field Separator
Here you can specify a separator. The default delimiter is tabulator (TAB).
Docs / NVXBAOE BAO Export / Appendix Release Notes
Would you like to know what has changed in the extension? Below you'll find an overview of the new features and changes made in the updates.
Build-Overview in DevOps