Vânzări facturate pe produse — Pro
Perioadă și gestiune → produse → documente, fără identificatori tehnici afișați.
Alegi perioada nativă și, opțional, filtrezi lista de gestiuni; deschizi gestiunea și apeși Produsele gestiunii. Abia atunci se execută raportul pentru acea singură gestiune. Dintr-un produs deschizi documentele lui, în aceeași perioadă. Prima listă este selectorul de gestiuni, nu un raport gol sau o scanare a întregii firme. Cheile tehnice sunt ascunse; nume, coduri, UM, clase și date sunt vizibile în carduri sau Detalii. Statistica include facturile clienți obișnuite, validate și neanulate, nu toate canalele de vânzare: nu adună separat bonuri fiscale, rapoarte Z sau avize, evitând dublarea acelor documente. Clasamentul este după valoarea vânzărilor fără TVA, NU după profit sau procent de marjă. Folosește valoarea liniilor din ERP, rotunjită pe linie la doi zecimali; nu aplică discountul încă o dată și nu face conversie valutară. Valorile acestei surse sunt în RON; valuta originală a facturii este un concept separat. Retururile/corecțiile negative rămân. Un produs cu UM diferite apare separat. Nu aduna numărul de facturi între produse (aceeași factură poate avea mai multe produse) și nici cantități cu UM diferite. Detaliile arată clienții, facturile, produsul, cantitatea și sumele fără/cu TVA. Manuale: https://www.docs.nexuserp.ro/articol/citire-facturi-clienti/4340 și https://www.docs.nexuserp.ro/articol/citire-facturi-clienti-linii/4341 . Citire live fără refresh global; maximum 10.000 de rânduri afișate per nivel. Pentru intervale mari restrânge perioada; totalurile se calculează înaintea limitei de afișare. Necesită Pro, iOS 1.1.0 build 336 / Android 1.1.0 build 284 sau mai nou. Funcțiile și vizualizările standard trebuie să fie accesibile contului read-only. Configurație comunitară neoficială.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Vânzări facturate pe produse — gestiuni
- Details: Produsele gestiunii
- Details: Facturile produsului
- Sub-button: Produse facturate
- Sub-button: Liniile de factură ale produsului
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CONCAT(g.pct_lcr,'|',g.id) AS warehouse_key,
g.pct_lcr AS warehouse_pl,g.id AS warehouse_id,g.nume AS warehouse_name,
CAST(:period_from AS date) AS period_date,
CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,
CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to
FROM dbo.gestiuni gstatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(b.pl_gest,'|',b.id_gest) AS warehouse_key,CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to,
CONCAT(b.pl_gest, '|', b.id_gest, '|', v.pl_pr, '|', v.id_pr, '|', RTRIM(v.um)) AS row_key,
b.pl_gest AS warehouse_pl,
b.id_gest AS warehouse_id,
v.pl_pr AS product_pl,
v.id_pr AS product_id,
MAX(b.nume_gest) AS warehouse_name,
MAX(v.denpr) AS product_name,
MAX(RTRIM(v.cod_ext)) AS product_code,
RTRIM(v.um) AS unit,
MAX(v.nume_grupa) AS product_group,
MAX(v.nume_clasa) AS product_class,
MAX(v.nume_subcl) AS product_subclass,
SUM(v.cantitate) AS quantity,
SUM(ROUND(v.valoare, 2)) AS sales_without_vat_ron,
COUNT_BIG(*) AS line_count,
COUNT(DISTINCT CONCAT(b.anluna, '|', b.pct_lcr, '|', b.id)) AS invoice_count,
MIN(b.data_doc) AS first_invoice_date,
MAX(b.data_doc) AS last_invoice_date,
CONVERT(varchar(10), CAST(:period_from AS date), 23) AS period_from,
CONVERT(varchar(10), CAST(:period_until AS date), 23) AS period_until,
CAST(:period_from AS date) AS period_date
FROM dbo.cli_browse_view b
INNER JOIN dbo.linfactclienti_view v
ON b.anluna = v.anluna AND b.pct_lcr = v.pl_cli AND b.id = v.id_cli
WHERE b.data_doc >= :period_from AND b.data_doc < :period_until
AND b.valid = 1 AND b.anulat = 0
AND b.pl_gest = CAST(:pl_gest AS decimal(38,0)) AND b.id_gest = CAST(:id_gest AS decimal(38,0))
AND LTRIM(RTRIM(b.tip_doc)) LIKE 'Factura%'
GROUP BY b.pl_gest, b.id_gest, v.pl_pr, v.id_pr, RTRIM(v.um)static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(b.pl_gest,'|',b.id_gest,'|',v.pl_pr,'|',v.id_pr,'|',RTRIM(v.um)) AS product_key,CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to,
CONCAT(v.anluna, '|', v.pct_lcr, '|', v.id) AS row_key,
b.nr_doc AS document_number,
b.data_doc AS document_date,
b.tip_doc AS document_type,
p.nume AS customer_name,
b.nume_gest AS warehouse_name,
v.denpr AS product_name,
RTRIM(v.cod_ext) AS product_code,
v.cantitate AS quantity,
RTRIM(v.um) AS unit,
ROUND(v.valoare, 2) AS sales_without_vat_ron,
ROUND(v.val_tva, 2) AS sales_with_vat_ron,
v.nume_clasa AS product_class,
v.nume_subcl AS product_subclass
FROM dbo.cli_browse_view b
INNER JOIN dbo.linfactclienti_view v
ON b.anluna = v.anluna AND b.pct_lcr = v.pl_cli AND b.id = v.id_cli
LEFT JOIN dbo.parteneri p ON p.pct_lcr = b.pl_411 AND p.id = b.id_411
WHERE b.data_doc >= :period_from AND b.data_doc < :period_until
AND b.valid = 1 AND b.anulat = 0
AND b.pl_gest = CAST(:pl_gest AS decimal(38,0)) AND b.id_gest = CAST(:id_gest AS decimal(38,0))
AND LTRIM(RTRIM(b.tip_doc)) LIKE 'Factura%'
AND v.pl_pr = CAST(:pl_pr AS decimal(38,0)) AND v.id_pr = CAST(:id_pr AS decimal(38,0)) AND RTRIM(v.um) = :unitstatic read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server",
"id": "EDD8F193-5C01-5824-A8E2-5B1691277114",
"kind": "sqlServer",
"requiredObjects": [
"dbo.gestiuni",
"dbo.cli_browse_view",
"dbo.linfactclienti_view",
"dbo.parteneri"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "B8917D7E-E4B6-5C62-9667-6B050C3FA426",
"key": "warehouse_name",
"type": "text"
}
],
"id": "00BCDFB8-965F-516B-A523-99E66778CD4F",
"mappings": [
{
"commonFieldKey": "",
"key": "warehouse_key",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_pl",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_pl",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_id",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_name",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_name",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "period_from",
"label": "Început intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_from",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "Sfârșit exclusiv intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "Perioada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_from",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_to",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Vânzări facturate pe produse — gestiuni",
"primaryKey": "warehouse_key",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "9436BECD-918B-5CF7-8899-8364DDDABBD2",
"name": "period_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "634ED9CD-14CE-5E00-BA3E-2063DCBF129E",
"name": "period_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"warehouse_name",
"date_from",
"date_to"
],
"sourceID": "EDD8F193-5C01-5824-A8E2-5B1691277114",
"sqlQuery": "SELECT CONCAT(g.pct_lcr,'|',g.id) AS warehouse_key,\n g.pct_lcr AS warehouse_pl,g.id AS warehouse_id,g.nume AS warehouse_name,\n CAST(:period_from AS date) AS period_date,\n CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,\n CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to\nFROM dbo.gestiuni g",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "D1C5791D-6991-5E5E-90E3-35368FC37276",
"key": "sales_without_vat_ron",
"type": "number"
},
{
"direction": "ascending",
"id": "7EB9EDD8-6AA7-5E4D-83E5-5268A490EA2D",
"key": "row_key",
"type": "text"
}
],
"id": "F73D67E4-F314-5B2A-BEBF-C60586E0C732",
"mappings": [
{
"commonFieldKey": "",
"key": "row_key",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_key",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_pl",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_pl",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_id",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_pl",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_pl",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_id",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_name",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_name",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_name",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "product_code",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_code",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "unit",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "unit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "product_group",
"label": "Grupă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_group",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_class",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_class",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_subclass",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_subclass",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "quantity",
"label": "Cantitate facturată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "quantity",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "sales_without_vat_ron",
"label": "Vânzări fără TVA (RON)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sales_without_vat_ron",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "line_count",
"label": "Linii de factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "line_count",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "invoice_count",
"label": "Facturi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "invoice_count",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "first_invoice_date",
"label": "Prima factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "first_invoice_date",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "last_invoice_date",
"label": "Ultima factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "last_invoice_date",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_from",
"label": "Început intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_from",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "Sfârșit exclusiv intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "Perioada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_from",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_to",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Produse facturate",
"primaryKey": "row_key",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "4975184A-D76E-5F7F-AA8D-04923CB238DC",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "E9318B68-7D61-53D8-9CEB-1ECB2C144C69",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "warehouse_pl",
"id": "0A16A3BA-9856-53E0-8F90-464FB06917BE",
"name": "pl_gest",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "warehouse_id",
"id": "816A2691-310C-5648-B664-A60BD3D8BA33",
"name": "id_gest",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"warehouse_name",
"product_name",
"product_code",
"unit",
"product_group",
"product_class",
"product_subclass",
"quantity",
"sales_without_vat_ron",
"line_count",
"invoice_count",
"first_invoice_date",
"last_invoice_date",
"date_from",
"date_to"
],
"sourceID": "EDD8F193-5C01-5824-A8E2-5B1691277114",
"sqlQuery": "SELECT CONCAT(b.pl_gest,'|',b.id_gest) AS warehouse_key,CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to,\n CONCAT(b.pl_gest, '|', b.id_gest, '|', v.pl_pr, '|', v.id_pr, '|', RTRIM(v.um)) AS row_key,\n b.pl_gest AS warehouse_pl,\n b.id_gest AS warehouse_id,\n v.pl_pr AS product_pl,\n v.id_pr AS product_id,\n MAX(b.nume_gest) AS warehouse_name,\n MAX(v.denpr) AS product_name,\n MAX(RTRIM(v.cod_ext)) AS product_code,\n RTRIM(v.um) AS unit,\n MAX(v.nume_grupa) AS product_group,\n MAX(v.nume_clasa) AS product_class,\n MAX(v.nume_subcl) AS product_subclass,\n SUM(v.cantitate) AS quantity,\n SUM(ROUND(v.valoare, 2)) AS sales_without_vat_ron,\n COUNT_BIG(*) AS line_count,\n COUNT(DISTINCT CONCAT(b.anluna, '|', b.pct_lcr, '|', b.id)) AS invoice_count,\n MIN(b.data_doc) AS first_invoice_date,\n MAX(b.data_doc) AS last_invoice_date,\n CONVERT(varchar(10), CAST(:period_from AS date), 23) AS period_from,\n CONVERT(varchar(10), CAST(:period_until AS date), 23) AS period_until,\n CAST(:period_from AS date) AS period_date\nFROM dbo.cli_browse_view b\nINNER JOIN dbo.linfactclienti_view v\n ON b.anluna = v.anluna AND b.pct_lcr = v.pl_cli AND b.id = v.id_cli\nWHERE b.data_doc >= :period_from AND b.data_doc < :period_until\n AND b.valid = 1 AND b.anulat = 0\n AND b.pl_gest = CAST(:pl_gest AS decimal(38,0)) AND b.id_gest = CAST(:id_gest AS decimal(38,0))\n AND LTRIM(RTRIM(b.tip_doc)) LIKE 'Factura%'\nGROUP BY b.pl_gest, b.id_gest, v.pl_pr, v.id_pr, RTRIM(v.um)",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "D1C5791D-6991-5E5E-90E3-35368FC37276",
"key": "sales_without_vat_ron",
"type": "number"
},
{
"direction": "ascending",
"id": "7EB9EDD8-6AA7-5E4D-83E5-5268A490EA2D",
"key": "row_key",
"type": "text"
}
],
"id": "B5B7C3F4-A94C-52B4-AAA1-695079A9D6B8",
"mappings": [
{
"commonFieldKey": "",
"key": "row_key",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_key",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "document_number",
"label": "Factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document_number",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "document_date",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document_date",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "document_type",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document_type",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "customer_name",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "customer_name",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "warehouse_name",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_name",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_name",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "product_code",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_code",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "quantity",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "quantity",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "unit",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "unit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "sales_without_vat_ron",
"label": "Valoare fără TVA (RON)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sales_without_vat_ron",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "sales_with_vat_ron",
"label": "Valoare cu TVA (RON)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sales_with_vat_ron",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_class",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_class",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_subclass",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_subclass",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_from",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_to",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Liniile de factură ale produsului",
"primaryKey": "row_key",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "5D38B4CC-0DBA-504C-8F89-FCFB850F1BE6",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "4CBF152E-8AA3-5465-A1AC-F26BF18D72C2",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "warehouse_pl",
"id": "7071B467-B117-52CD-B415-5E72A1ACB360",
"name": "pl_gest",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "warehouse_id",
"id": "1F8865CE-9F01-51F5-8687-7EB3CC04C28F",
"name": "id_gest",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_pl",
"id": "31986137-E91B-5955-A4CE-887DE34D3DB4",
"name": "pl_pr",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_id",
"id": "FA1FCA1C-88A7-55A9-AF83-CC241CD56697",
"name": "id_pr",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "unit",
"id": "D9B01C37-6AF0-5375-A5C5-C73D654A969A",
"name": "unit",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"document_number",
"document_date",
"document_type",
"customer_name",
"warehouse_name",
"product_name",
"product_code",
"quantity",
"unit",
"sales_without_vat_ron",
"sales_with_vat_ron",
"product_class",
"product_subclass",
"date_from",
"date_to"
],
"sourceID": "EDD8F193-5C01-5824-A8E2-5B1691277114",
"sqlQuery": "SELECT CONCAT(b.pl_gest,'|',b.id_gest,'|',v.pl_pr,'|',v.id_pr,'|',RTRIM(v.um)) AS product_key,CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to,\n CONCAT(v.anluna, '|', v.pct_lcr, '|', v.id) AS row_key,\n b.nr_doc AS document_number,\n b.data_doc AS document_date,\n b.tip_doc AS document_type,\n p.nume AS customer_name,\n b.nume_gest AS warehouse_name,\n v.denpr AS product_name,\n RTRIM(v.cod_ext) AS product_code,\n v.cantitate AS quantity,\n RTRIM(v.um) AS unit,\n ROUND(v.valoare, 2) AS sales_without_vat_ron,\n ROUND(v.val_tva, 2) AS sales_with_vat_ron,\n v.nume_clasa AS product_class,\n v.nume_subcl AS product_subclass\nFROM dbo.cli_browse_view b\nINNER JOIN dbo.linfactclienti_view v\n ON b.anluna = v.anluna AND b.pct_lcr = v.pl_cli AND b.id = v.id_cli\nLEFT JOIN dbo.parteneri p ON p.pct_lcr = b.pl_411 AND p.id = b.id_411\nWHERE b.data_doc >= :period_from AND b.data_doc < :period_until\n AND b.valid = 1 AND b.anulat = 0\n AND b.pl_gest = CAST(:pl_gest AS decimal(38,0)) AND b.id_gest = CAST(:id_gest AS decimal(38,0))\n AND LTRIM(RTRIM(b.tip_doc)) LIKE 'Factura%'\n AND v.pl_pr = CAST(:pl_pr AS decimal(38,0)) AND v.id_pr = CAST(:id_pr AS decimal(38,0)) AND RTRIM(v.um) = :unit",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "C2F88EC9-27BF-5712-A427-D2EFF745A91D",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "78E9B900-A6F4-5745-87C7-66A1B367A753",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "F73D67E4-F314-5B2A-BEBF-C60586E0C732",
"title": "Produsele gestiunii",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [],
"datasetID": "00BCDFB8-965F-516B-A523-99E66778CD4F",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "4CD4442E-5158-55D1-8D03-7C07E222057A",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "29D21788-D854-5711-A259-BD3A7286DB06",
"includeAllOption": false,
"key": "period_date",
"title": "Perioadă",
"type": "date"
},
{
"id": "E54AC030-0A7A-579D-B6CB-D4960E165E06",
"includeAllOption": true,
"key": "warehouse_name",
"title": "Gestiune",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "B8917D7E-E4B6-5C62-9667-6B050C3FA426",
"key": "warehouse_name",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "",
"systemImage": "chart.bar",
"title": "Vânzări facturate pe produse — gestiuni",
"titleKey": "warehouse_name"
},
{
"actions": [
{
"id": "D8E3A8BA-4E86-5DE3-9208-2BB2507E9FBC",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "C02C5C50-8CDE-56AA-A4B5-FB0316506D3D",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "B5B7C3F4-A94C-52B4-AAA1-695079A9D6B8",
"title": "Facturile produsului",
"urlKey": ""
}
],
"badgeKey": "sales_without_vat_ron",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "unit",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "quantity",
"label": "Cantitate facturată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "invoice_count",
"label": "Facturi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "F73D67E4-F314-5B2A-BEBF-C60586E0C732",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "warehouse_name",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "unit",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "product_group",
"label": "Grupă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "product_class",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "product_subclass",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "quantity",
"label": "Cantitate facturată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "line_count",
"label": "Linii de factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "invoice_count",
"label": "Facturi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "first_invoice_date",
"label": "Prima factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "last_invoice_date",
"label": "Ultima factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "BD09976C-C0DF-5BC5-8981-59D3DEDD221D",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "D1C5791D-6991-5E5E-90E3-35368FC37276",
"key": "sales_without_vat_ron",
"type": "number"
},
{
"direction": "ascending",
"id": "7EB9EDD8-6AA7-5E4D-83E5-5268A490EA2D",
"key": "row_key",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "product_code",
"systemImage": "chart.bar",
"title": "Produse facturate",
"titleKey": "product_name"
},
{
"actions": [],
"badgeKey": "sales_without_vat_ron",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "document_date",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "product_name",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "quantity",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "unit",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B5B7C3F4-A94C-52B4-AAA1-695079A9D6B8",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "document_date",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "document_type",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "warehouse_name",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "product_name",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "product_code",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "quantity",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "unit",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sales_with_vat_ron",
"label": "Valoare cu TVA (RON)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "product_class",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "product_subclass",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "024DCAC4-292D-5EAD-8324-91900B7B48D6",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "D1C5791D-6991-5E5E-90E3-35368FC37276",
"key": "sales_without_vat_ron",
"type": "number"
},
{
"direction": "ascending",
"id": "7EB9EDD8-6AA7-5E4D-83E5-5268A490EA2D",
"key": "row_key",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "document_number",
"systemImage": "chart.bar",
"title": "Liniile de factură ale produsului",
"titleKey": "customer_name"
}
],
"relations": [
{
"childDatasetID": "F73D67E4-F314-5B2A-BEBF-C60586E0C732",
"childKey": "warehouse_key",
"id": "78E9B900-A6F4-5745-87C7-66A1B367A753",
"name": "Produsele gestiunii",
"parentDatasetID": "00BCDFB8-965F-516B-A523-99E66778CD4F",
"parentKey": "warehouse_key"
},
{
"childDatasetID": "B5B7C3F4-A94C-52B4-AAA1-695079A9D6B8",
"childKey": "product_key",
"id": "C02C5C50-8CDE-56AA-A4B5-FB0316506D3D",
"name": "Facturile produsului",
"parentDatasetID": "F73D67E4-F314-5B2A-BEBF-C60586E0C732",
"parentKey": "row_key"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-27T08:13:52Z",
"description": "Alegi perioada nativă și, opțional, filtrezi lista de gestiuni; deschizi gestiunea și apeși Produsele gestiunii. Abia atunci se execută raportul pentru acea singură gestiune. Dintr-un produs deschizi documentele lui, în aceeași perioadă. Prima listă este selectorul de gestiuni, nu un raport gol sau o scanare a întregii firme. Cheile tehnice sunt ascunse; nume, coduri, UM, clase și date sunt vizibile în carduri sau Detalii. Statistica include facturile clienți obișnuite, validate și neanulate, nu toate canalele de vânzare: nu adună separat bonuri fiscale, rapoarte Z sau avize, evitând dublarea acelor documente. Clasamentul este după valoarea vânzărilor fără TVA, NU după profit sau procent de marjă. Folosește valoarea liniilor din ERP, rotunjită pe linie la doi zecimali; nu aplică discountul încă o dată și nu face conversie valutară. Valorile acestei surse sunt în RON; valuta originală a facturii este un concept separat. Retururile/corecțiile negative rămân. Un produs cu UM diferite apare separat. Nu aduna numărul de facturi între produse (aceeași factură poate avea mai multe produse) și nici cantități cu UM diferite. Detaliile arată clienții, facturile, produsul, cantitatea și sumele fără/cu TVA. Manuale: https://www.docs.nexuserp.ro/articol/citire-facturi-clienti/4340 și https://www.docs.nexuserp.ro/articol/citire-facturi-clienti-linii/4341 . Citire live fără refresh global; maximum 10.000 de rânduri afișate per nivel. Pentru intervale mari restrânge perioada; totalurile se calculează înaintea limitei de afișare. Necesită Pro, iOS 1.1.0 build 336 / Android 1.1.0 build 284 sau mai nou. Funcțiile și vizualizările standard trebuie să fie accesibile contului read-only. Configurație comunitară neoficială.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "F5DB1C69-FF7F-55FC-BE10-A3FB1A05581D",
"rootButtonCount": 1,
"summary": "Perioadă și gestiune → produse → documente, fără identificatori tehnici afișați.",
"tags": [
"NexusERP",
"vânzări",
"Pro"
],
"title": "Vânzări facturate pe produse — Pro"
}
}