Skip to content

Instantly share code, notes, and snippets.

@SiddiqueAhmad
Last active Feb 2, 2022
Embed
What would you like to do?
importing n level of chart of accounts in axelor under any company
code parent_code name accountType.technicalTypeSelect reconcileOk company_code
0 Company Name view false company_code
BAL 0 Balance Sheet view false company_code
A000 BAL Fixed assets view false company_code
A010 A000 Intangible assets view false company_code
1000 A000 Software fixed_assets false company_code
1100 A000 Software Depreciation fixed_assets false company_code
2000 A000 Patents & Trademarks fixed_assets false company_code
2100 A000 Patents & Trademarks Depreciation fixed_assets false company_code
PNL 0 Profit and Loss view false company_code
F000 PNL Turnover view false company_code
400000 F000 Sales category 1 income false company_code
400100 F000 Sales category 2 income false company_code
400200 F000 Sales category 3 income false company_code
400300 F000 Sales category 4 income false company_code
G000 PNL Cost of sale view false company_code
500000 G000 Cost of sale 1 charge false company_code
500100 G000 Cost of sale 2 charge false company_code
500200 G000 Cost of sale 3 charge false company_code
<?xml version="1.0" encoding="UTF-8"?>
<csv-inputs xmlns="http://axelor.com/xml/ns/data-import"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://axelor.com/xml/ns/data-import http://axelor.com/xml/ns/data-import/data-import_5.4.xsd">
<input file="accounts_data.csv" separator="," type="com.axelor.apps.account.db.Account"
search="self.code = :code AND self.company.code = :company_code">
<bind to="parentAccount"
search="self.code = :parent_code AND self.company.code = :company_code" />
<bind to="company" search="self.code = :company_code" />
</input>
</csv-inputs>
@SiddiqueAhmad
Copy link
Author

SiddiqueAhmad commented Feb 2, 2022

code column for coa table is case sensitive.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment