I'm trying to customize my balance sheet and P&L
I know that this is referring to my Expenses journal, but how can I verify this?
Where does it show that 15 = Expenses Journal?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
2
Antwoorden
6826
Weergaven
A better answer would be to show you how you can find this information yourself. The account types are in the database in table account_account_type, but you cannot find that list in a menu, so you can not simply export them with their ID's. But you CAN export the Chart of Accounts and make sure Account Type and Account Type ID are included in the fields.
- Go to your chart of accounts in list view
- select all rows
- click on the gear icon > select export
- include Account Type and Account Type ID
- Export to Excel
- Remove Duplicates in Excel
N.B. A much more user friendly way is to use Account Tags instead of the ID's. You's still need the tag id's, but fortunately the do come with a menu so you can export that with the ID's or look for the ID in the URL of the tag.
Love it thanks!
These are the IDs for Odoo 13
| ID | Account Type | Type |
| 1 | Receivable | Receivable |
| 2 | Payable | Payable |
| 3 | Bank and Cash | Liquidity |
| 4 | Credit Card | Liquidity |
| 5 | Current Assets | Regular |
| 6 | Non-current Assets | Regular |
| 7 | Prepayments | Regular |
| 8 | Fixed Assets | Regular |
| 9 | Current Liabilities | Regular |
| 10 | Non-current Liabilities | Regular |
| 11 | Equity | Regular |
| 12 | Current Year Earnings | Regular |
| 13 | Income | Regular |
| 14 | Other Income | Regular |
| 15 | Expenses | Regular |
| 16 | Depreciation | Regular |
| 17 | Cost of Revenue | Regular |
| 18 | Off-Balance Sheet | Regular |
EDIT: This list is from account.account.type and I think it's changed slightly between Odoo versions.
Consider "teaching how to fish"? How did you get this information?
Fair point, Ray. I created a new menu option for Model account.account.type and used that to download data to Excel.
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden
"Question about domain" is not a question - I have edited the title on your post - please consider posting a question that explains what you want so readers don't have to open your post to understand what you ask.