I'm searching a way to print the report of general ledger in Odoo v9, but only I found PDF choice. Some web pages said about a module but all the modules are for less versions. Some advice?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Kế toán
- Tồn kho
- PoS
- Project
- MRP
Câu hỏi này đã bị gắn cờ
go to odoo apps.search general ledger by "pycus".
In development mode try to copy journal items from 'Adviser' sub-menu.
Or if you have got an access to your database try this request
select aml.move_id,aml.date,debit,credit,rcur1.name as functional_currency,aa.code,rp.name as partner,aml.name as details,aml.amount_currency,rcur.name as foreign_currency,rcom.name as company,ai."number" as invoice_numfrom account_move_line as amlleft join account_account as aa on (aml.account_id=aa.id)left join res_partner as rp on (aml.partner_id=rp.id)left join res_currency as rcur on aml.currency_id=rcur.idleft join res_currency as rcur1 on aml.company_currency_id=rcur1.idleft join res_company as rcom on aml.company_id=rcom.idleft join account_invoice as ai on aml.invoice_id=ai.idwhere aml.date between '2016-01-01' and '2016-12-31' and aml.company_id=1 and aa.company_id=1 and rp.company_id=1 and ai.company_id=1order by aml.move_id,aml.date
please change all 'left join' with 'left outer join'
I have the same problem (exporting the journal of my POS) and found no easy solution so far, but my tax auditor demands an easy-to-process Excel version... any ideas anyone?
Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng kýBài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
---|---|---|---|---|
|
2
thg 5 24
|
1815 | ||
|
2
thg 6 23
|
4441 | ||
|
7
thg 4 19
|
15357 | ||
Excel/CSV report - Odoo 8
Đã xử lý
|
|
8
thg 6 17
|
16916 | |
|
1
thg 3 15
|
7856 |