Ledger invoices (vat.Invoices)

The table of all VatAccountInvoice objects. (more)

Inherits from lino_xl.lib.accounting.PartnerVouchers, lino_xl.lib.accounting.Vouchers

Every row of this data table is a Ledger invoice.

User guide: The vat plugin.

Columns

  • Entry date (entry_date) : The date of the journal entry, i.e. when this voucher is to be booked.

  • ID (id) : See ID.

  • No. (number_with_year) : Shows the accounting year and the number of this voucher within its journal.

  • Partner (partner) : The recipient of this document. This can be a person, an organization or any type of business partner.

  • Total incl. VAT (total_incl) : The amount VAT included.

  • Author (user) : The author of this database object.

Detail layout

          • No. (number) : The sequence number of this voucher within its journal.

          • Partner (partner) : The recipient of this document. This can be a person, an organization or any type of business partner.

          • Entry date (entry_date) : The date of the journal entry, i.e. when this voucher is to be booked.

          • Accounting period (accounting_period) : The accounting period to use when booking this voucher. The default value is determined from entry_date.

          • Provider’s invoice number (your_ref) : The reference used by the business partner for referring to this voucher.

          • VAT regime (vat_regime) : The VAT regime to be used in this document.

        • Match (match) : The movement to be matched.

        • Payment term (payment_term) : The payment term to apply for this transaction.

        • Due date (due_date) : The date when the invoice is expected to have been paid.

        • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

        • Total excl. VAT (total_base) : The amount VAT excluded.

        • VAT (total_vat) : The amount of VAT.

        • Total incl. VAT (total_incl) : The amount VAT included.

    • Content (vat.ItemsByInvoice)

          • Journal (journal) : The journal into which this voucher has been booked.

          • Author (user) : The author of this database object.

          • Narration (narration) : A short explanation to explain the subject matter of this journal entry.

          • ID (id) : See ID.

      • Upload files (uploads.UploadsByController1) : See Upload files.

    • Movements (vat.MovementsByVoucher1) : See Movements.

Toolbar actions

  • Table (landscape) (as_pdf) : See (unformatted: <lino_xl.lib.appypod.mixins.PrintTableAction as_pdf ('Table (landscape)')>).

  • Table (portrait) (as_pdf_p) : See (unformatted: <lino_xl.lib.appypod.mixins.PortraitPrintTableAction as_pdf_p ('Table (portrait)')>).

  • Export to .xls (export_excel) : Export this table as an .xls document

  • None (grid_post) : See (unformatted: <lino.core.actions.CreateRow grid_post>).

  • None (grid_put) : See (unformatted: <lino.core.actions.SaveGridCell grid_put>).

  • New (insert) : Insert a new Ledger invoice.

  • Create (submit_insert) : Submit this form, i.e. send your data to the server.

  • Duplicate (clone_row) : Insert a new Ledger invoice as a copy of this.

  • Delete (delete_selected) : Delete this record

  • Show data problems (show_problems) : See (unformatted: <lino.core.actions.ShowSlaveTable show_problems ('Show data problems')>).

  • Upload files (show_uploads) : Opens a data window with the uploaded files associated to this database object.

  • Check data (check_data) : Update data problem messages for this database object, also removing messages that no longer exist. This action does not change anything else in the database.

  • None (compute_sums) : Calls ComputeSums for this document.

  • Fix data problems (fix_problems) : Update data problem messages and repair those which are automatically fixable.

  • None (grid) : The table of all VatAccountInvoice objects.

  • None (open_help) : Open Help Window

  • Send now (send_now) : See (unformatted: <lino_xl.lib.peppol.mixins.SendNow send_now ('Send now')>).

  • Toggle state (toggle_state) : Toggle between “registered” and “draft” state.

  • None (validate) : See (unformatted: <lino.core.actions.ValidateForm validate>).

  • Save (submit_detail) : Save changes in this form

Filter parameters

  • None (None) : See None.

  • Voucher state (state) : See state.

  • Partner (partner) : See partner.

  • Show cleared vouchers (cleared) : See cleared.

  • Fiscal year (year) : See year.

  • Journal (journal) : See journal.

  • Period from (start_period) : Start of observed period range.

  • Period until (end_period) : Optional end of observed period range. Leave empty to observe only the start period.

  • Author (user) : The author of this database object.

Hidden columns

  • Journal (journal) : The journal into which this voucher has been booked.

  • Voucher date (voucher_date) : The date on the voucher (i.e. when it has been issued by its emitter).

  • Fiscal year (fiscal_year) : See Fiscal year.

  • Accounting period (accounting_period) : The accounting period to use when booking this voucher. The default value is determined from entry_date.

  • No. (number) : The sequence number of this voucher within its journal.

  • Narration (narration) : A short explanation to explain the subject matter of this journal entry.

  • Payment term (payment_term) : The payment term to apply for this transaction.

  • Due date (due_date) : The date when the invoice is expected to have been paid.

  • Match (match) : The movement to be matched.

  • Total excl. VAT (total_base) : The amount VAT excluded.

  • VAT (total_vat) : The amount of VAT.

  • Voucher state (state) : The state of this voucher. It decides among others whether you can edit this voucher or not.

  • VAT regime (vat_regime) : The VAT regime to be used in this document.

  • items edited (items_edited) : An automatically managed boolean field which says whether the user has manually edited the items of this document. If this is False and edit_totals is True, Lino will automatically update the only invoice item according to partner and vat_regime and total_incl.

  • Provider’s invoice number (your_ref) : The reference used by the business partner for referring to this voucher.

  • Select multiple rows (rowselect) : See Select multiple rows.