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:
- ลูกค้าสัมพันธ์
- e-Commerce
- ระบบบัญชี
- สินค้าคงคลัง
- PoS
- โปรเจกต์
- MRP
คำถามนี้ถูกตั้งค่าสถานะ
2
ตอบกลับ
6849
มุมมอง
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.
สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!
สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!
ลงชื่อ
"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.