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
- Księgowość
- Zapasy
- PoS
- Project
- MRP
To pytanie dostało ostrzeżenie
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?
Podoba Ci się ta dyskusja? Dołącz do niej!
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj sięPowiązane posty | Odpowiedzi | Widoki | Czynność | |
---|---|---|---|---|
|
2
maj 24
|
1803 | ||
|
2
cze 23
|
4440 | ||
How to create Excel report in odoo9 ?
Rozwiązane
|
|
7
kwi 19
|
15334 | |
Excel/CSV report - Odoo 8
Rozwiązane
|
|
8
cze 17
|
16900 | |
|
1
mar 15
|
7822 |