Products (products.ProductsByCategory)

Every row of this data table is a Product.

User guide: The products plugin.

Columns

  • ID (id) : See ID.

  • Designation (name) : A one-line designation for this product.

  • Designation (de) (name_de) : See Designation (de).

  • Designation (fr) (name_fr) : See Designation (fr).

  • Designation (et) (name_et) : See Designation (et).

  • Category (category) : The category of this product.

  • VAT class (vat_class) : The VAT class. Injected by lino_xl.lib.vat. If that plugin is not installed, vat_class is a dummy field.

Detail layout

      • Designation (name) : A one-line designation for this product.

      • Designation (de) (name_de) : See Designation (de).

      • Designation (fr) (name_fr) : See Designation (fr).

      • Designation (et) (name_et) : See Designation (et).

      • ID (id) : See ID.

      • Product type (product_type) : The type of this product.

      • Category (category) : The category of this product.

      • Delivery unit (delivery_unit) : Pointer to DeliveryUnits

      • Long description (body) : The long description of this product.

      • Body (de) (body_de) : See Body (de).

      • Body (fr) (body_fr) : See Body (fr).

      • Body (et) (body_et) : See Body (et).

      • Sales price (sales_price) : See Sales price.

      • VAT class (vat_class) : The VAT class. Injected by lino_xl.lib.vat. If that plugin is not installed, vat_class is a dummy field.

      • Sales account (sales_account) : See Sales account.

    • Trading invoice items (trading.InvoiceItemsByProduct)

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 Product.

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

  • Duplicate (clone_row) : Insert a new Product 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')>).

  • 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.

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

  • None (grid) : See (unformatted: <lino.core.actions.ShowTable grid>).

  • None (open_help) : Open Help Window

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

  • Save (submit_detail) : Save changes in this form

Hidden columns

  • Long description (body) : The long description of this product.

  • Body (de) (body_de) : See Body (de).

  • Body (fr) (body_fr) : See Body (fr).

  • Body (et) (body_et) : See Body (et).

  • Preview (body_short_preview) : See lino.modlib.memo.Previewable.body_short_preview.

  • Preview (de) (body_short_preview_de) : See Preview (de).

  • Preview (fr) (body_short_preview_fr) : See Preview (fr).

  • Preview (et) (body_short_preview_et) : See Preview (et).

  • Preview (full) (body_full_preview) : See lino.modlib.memo.Previewable.body_full_preview.

  • Preview (full) (de) (body_full_preview_de) : See Preview (full) (de).

  • Preview (full) (fr) (body_full_preview_fr) : See Preview (full) (fr).

  • Preview (full) (et) (body_full_preview_et) : See Preview (full) (et).

  • Storage management (storage_management) : See Storage management.

  • Delivery unit (delivery_unit) : Pointer to DeliveryUnits

  • Pieces per unit (pieces_per_unit) : See Pieces per unit.

  • Product type (product_type) : The type of this product.

  • Subtotal (subtotal) : See Subtotal.

  • Sales account (sales_account) : See Sales account.

  • Sales price (sales_price) : See Sales price.

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