This question has been flagged
2439 Views

I have a problem doing a method, it turns out that I want to make a ledger but the code I try to do does not work for me, the idea is that with a date filter it shows me the account and all the movements, for this I have a table that contains All the data I need. The document detail table contains the debit and credit along with the company id and the id account, as well as the date the movement was made. As I said before I tried to make a code that would call me that data to the pdf report but it did not work, can you guide me how to solve the problem please.

class Reportledger (models.AbstractModel):

_name = 'reports.project_rc.ledger_view'

@api.model
def _get_report_values ​​(self, docids, data = None):
    start_date = data ['form'] ['start_date']
    end_date = data ['form'] ['end_date']


    docs = []
    document_detail = self.env ['project_rc.detail_document']. search ([
        ('date', '> =', start_date.strftime (DATETIME_FORMAT)),
        ('date', '<=', end_date.strftime (DATETIME_FORMAT)),
        ('title', '=', account.id),
        ('name', '=', razon_social.id),
        ('debit', '=', total_debit),
        ('credit', '=', total_credit),
        ])

        docs.append ({
            'title': self.detail_document.account_id.title,
            'date': detail_document.date,
            'name': self.detail_document.company_id.name,
            'must': detail_document.total_debit,
            'credit': detail_document.total_credit,
        })

    return {
        'doc_ids': data ['ids'],
        'doc_model': data ['model'],
        'start_date': start_date,
        'end_date': end_date,
        'docs': docs,
   }

Avatar
Discard