Is it possible to add items into an invoice from another entity (not products)?
Target: We want to create something like a balance sheet, where a PDF Template will generate a file, with data from 2 entities - Assets and Liabilities
We thought that Sales pack could provide that functionality with Invoice's, but as far as I understand you can only select items from products.
So what we want in the end is like a pdf table, that displays data from 2 entities in a column sorted by date.
I understand that even in the base version of Espo, I can create another separate entity, link Assets and Liabilities to it, and display it in a PDF with {{#each assets}} and {{#each liabilities}} - but that will fetch me 2 separate tables, where I want to join them so they are displayed in 1 table and sort them by Date column
Target: We want to create something like a balance sheet, where a PDF Template will generate a file, with data from 2 entities - Assets and Liabilities
We thought that Sales pack could provide that functionality with Invoice's, but as far as I understand you can only select items from products.
So what we want in the end is like a pdf table, that displays data from 2 entities in a column sorted by date.
I understand that even in the base version of Espo, I can create another separate entity, link Assets and Liabilities to it, and display it in a PDF with {{#each assets}} and {{#each liabilities}} - but that will fetch me 2 separate tables, where I want to join them so they are displayed in 1 table and sort them by Date column
Comment