Venituri pe centre și conturi — Pro
Perioadă → centre cu totaluri → conturi → înregistrări și explicații; corecții negative păstrate.
Venituri înregistrate în analiza centrelor de profit Nexus: alegi perioada nativă Cifru, apoi centrul și contul prin carduri. Vezi totalul și corecțiile negative, numărul de conturi/înregistrări; sub-butoanele deschid conturile centrului și înregistrările contului, cu document, produs/serviciu, partener, cantitate, explicații și modulul de proveniență. Perioada este aplicată ÎNAINTE de agregare și transmisă explicit la fiecare nivel. Citirile pentru conturi/linii sunt restrânse la centrul și contul selectat, nu la întreg istoricul. Sumele provin direct din câmpul venit al analizei Nexus: zero este exclus, corecțiile negative rămân. Nu se calculează din cantitate × preț, nu se face conversie valutară și nu se însumează câmpuri deviz. Nu este balanță contabilă sau profit net certificat; depinde de colectarea/repartizarea din ERP. Un centru fără identificator este separat ca „Fără centru atribuit”; legăturile folosesc chei ascunse, nu numele. Live, fără refresh automat global; maximum 10.000 de rânduri per nivel. Pentru perioade foarte mari, restrânge intervalul. Totalurile includ toate înregistrările care corespund filtrului, dar lista de înregistrări poate afișa cel mult 10.000; nu confunda limita afișării cu un total parțial. Necesită Pro, iOS 1.1.0 build 336 / Android 1.1.0 build 284 sau mai nou pentru parametrii de perioadă. Configurație comunitară neoficială, read-only. Manual: https://www.docs.nexuserp.ro/articol/citire-analiza-centre-profit/4371 .
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Venituri pe centre
- Details: Conturile centrului
- Details: Înregistrările contului
- Sub-button: Venituri pe conturi
- Sub-button: Înregistrări venituri
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 b.center_key AS row_id,b.center_key,
MAX(b.centru) AS centru,
SUM(b.venit) AS suma,
SUM(CASE WHEN b.venit>0 THEN b.venit ELSE 0 END) AS sume_pozitive,
SUM(CASE WHEN b.venit<0 THEN b.venit ELSE 0 END) AS corectii_negative,
COUNT_BIG(*) AS nr_inregistrari,
COUNT(DISTINCT b.account_key) AS nr_conturi,
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 data_de_la,
DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la
FROM (SELECT a.*, CASE WHEN a.id_centru_profit IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.id_centru_profit)) END AS center_key, CASE WHEN a.cont IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.cont)) END AS account_key,
COALESCE(NULLIF(LTRIM(RTRIM(a.den_centru_profit)),N''),N'Fără centru atribuit') AS centru,
COALESCE(NULLIF(LTRIM(RTRIM(a.cont)),N''),N'Fără cont atribuit') AS cont_afisat
FROM dbo.accesex_analiza_centre_profit_view a
WHERE a.data_document >= :period_from AND a.data_document < :period_until
AND COALESCE(a.venit,0) <> 0) b
GROUP BY b.center_keystatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(LEN(b.center_key),N':',b.center_key,b.account_key) AS row_id,b.center_key,
MAX(b.centru) AS centru,
b.account_key, MAX(b.cont_afisat) AS cont,
SUM(b.venit) AS suma,
SUM(CASE WHEN b.venit>0 THEN b.venit ELSE 0 END) AS sume_pozitive,
SUM(CASE WHEN b.venit<0 THEN b.venit ELSE 0 END) AS corectii_negative,
COUNT_BIG(*) AS nr_inregistrari,
COUNT(DISTINCT b.account_key) AS nr_conturi,
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 data_de_la,
DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la
FROM (SELECT a.*, CASE WHEN a.id_centru_profit IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.id_centru_profit)) END AS center_key, CASE WHEN a.cont IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.cont)) END AS account_key,
COALESCE(NULLIF(LTRIM(RTRIM(a.den_centru_profit)),N''),N'Fără centru atribuit') AS centru,
COALESCE(NULLIF(LTRIM(RTRIM(a.cont)),N''),N'Fără cont atribuit') AS cont_afisat
FROM dbo.accesex_analiza_centre_profit_view a
WHERE a.data_document >= :period_from AND a.data_document < :period_until
AND COALESCE(a.venit,0) <> 0
AND CASE WHEN a.id_centru_profit IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.id_centru_profit)) END = :center_key) b
GROUP BY b.center_key,b.account_keystatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONVERT(varchar(40),b.id) AS row_id,b.center_key,b.account_key,
b.centru,b.cont_afisat AS cont,b.venit AS suma,
b.data_document,b.tip_document,b.numar_document,
b.den_modul,b.nume_furnizor,b.den_produs,b.cod_extern,b.um,b.cantitate,b.detalii,
COALESCE(NULLIF(LTRIM(RTRIM(b.den_produs)),N''),NULLIF(LTRIM(RTRIM(b.nume_furnizor)),N''),
NULLIF(LTRIM(RTRIM(b.tip_document)),N''),N'Înregistrare contabilă') AS titlu,
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 data_de_la,
DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la
FROM (SELECT a.*, CASE WHEN a.id_centru_profit IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.id_centru_profit)) END AS center_key, CASE WHEN a.cont IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.cont)) END AS account_key,
COALESCE(NULLIF(LTRIM(RTRIM(a.den_centru_profit)),N''),N'Fără centru atribuit') AS centru,
COALESCE(NULLIF(LTRIM(RTRIM(a.cont)),N''),N'Fără cont atribuit') AS cont_afisat
FROM dbo.accesex_analiza_centre_profit_view a
WHERE a.data_document >= :period_from AND a.data_document < :period_until
AND COALESCE(a.venit,0) <> 0
AND CASE WHEN a.id_centru_profit IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.id_centru_profit)) END = :center_key
AND CASE WHEN a.cont IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.cont)) END = :account_key) bstatic read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server",
"id": "FC90DDC2-7B2C-5DC4-A121-008494DA5729",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_analiza_centre_profit_view"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "CBDFE8EC-F9CE-51F5-A3BE-ED257FC396B3",
"key": "suma",
"type": "number"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "30610B53-E2CF-5FCF-BCAD-9FFBB10CAF79",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Cheie grup",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "center_key",
"label": "Cheie centru",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "center_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "centru",
"label": "Centru de profit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "centru",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "suma",
"label": "Venituri înregistrate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "suma",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_conturi",
"label": "Conturi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_conturi",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_inregistrari",
"label": "Înregistrări",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_inregistrari",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "sume_pozitive",
"label": "Sume pozitive",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sume_pozitive",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "corectii_negative",
"label": "Corecții negative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "corectii_negative",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "Perioada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"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": "data_de_la",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_de_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_pana_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Venituri pe centre",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "BF8672F0-6FCC-533C-AEE7-ED10CCF04FEF",
"name": "period_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "43453C0F-EC52-591B-844D-1ACC9CB986D5",
"name": "period_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"centru",
"suma",
"nr_conturi",
"nr_inregistrari",
"sume_pozitive",
"corectii_negative",
"data_de_la",
"data_pana_la"
],
"sourceID": "FC90DDC2-7B2C-5DC4-A121-008494DA5729",
"sqlQuery": "SELECT b.center_key AS row_id,b.center_key,\n MAX(b.centru) AS centru,\n \n SUM(b.venit) AS suma,\n SUM(CASE WHEN b.venit>0 THEN b.venit ELSE 0 END) AS sume_pozitive,\n SUM(CASE WHEN b.venit<0 THEN b.venit ELSE 0 END) AS corectii_negative,\n COUNT_BIG(*) AS nr_inregistrari,\n COUNT(DISTINCT b.account_key) AS nr_conturi,\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,\n CAST(:period_from AS date) AS data_de_la,\n DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la\nFROM (SELECT a.*, CASE WHEN a.id_centru_profit IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.id_centru_profit)) END AS center_key, CASE WHEN a.cont IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.cont)) END AS account_key,\n COALESCE(NULLIF(LTRIM(RTRIM(a.den_centru_profit)),N''),N'Fără centru atribuit') AS centru,\n COALESCE(NULLIF(LTRIM(RTRIM(a.cont)),N''),N'Fără cont atribuit') AS cont_afisat\nFROM dbo.accesex_analiza_centre_profit_view a\nWHERE a.data_document >= :period_from AND a.data_document < :period_until\n AND COALESCE(a.venit,0) <> 0) b\nGROUP BY b.center_key",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "CBDFE8EC-F9CE-51F5-A3BE-ED257FC396B3",
"key": "suma",
"type": "number"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "158B3344-A6F7-5EEE-9609-D1C29D1F5F87",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Cheie grup",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "center_key",
"label": "Cheie centru",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "center_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "centru",
"label": "Centru de profit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "centru",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "account_key",
"label": "Cheie cont",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "account_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cont",
"label": "Cont",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cont",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "suma",
"label": "Venituri înregistrate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "suma",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_conturi",
"label": "Conturi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_conturi",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_inregistrari",
"label": "Înregistrări",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_inregistrari",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "sume_pozitive",
"label": "Sume pozitive",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sume_pozitive",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "corectii_negative",
"label": "Corecții negative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "corectii_negative",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "Perioada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"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": "data_de_la",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_de_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_pana_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Venituri pe conturi",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "6EC0C7E4-FE8B-54BB-BFF2-A93878968D60",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "9267C0CD-4A18-54F6-8640-11CFB87F784F",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "center_key",
"id": "06C12BDA-9A25-5DA6-A4AC-A2E6AEE6855B",
"name": "center_key",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"centru",
"cont",
"suma",
"nr_inregistrari",
"sume_pozitive",
"corectii_negative",
"data_de_la",
"data_pana_la"
],
"sourceID": "FC90DDC2-7B2C-5DC4-A121-008494DA5729",
"sqlQuery": "SELECT CONCAT(LEN(b.center_key),N':',b.center_key,b.account_key) AS row_id,b.center_key,\n MAX(b.centru) AS centru,\n b.account_key, MAX(b.cont_afisat) AS cont,\n SUM(b.venit) AS suma,\n SUM(CASE WHEN b.venit>0 THEN b.venit ELSE 0 END) AS sume_pozitive,\n SUM(CASE WHEN b.venit<0 THEN b.venit ELSE 0 END) AS corectii_negative,\n COUNT_BIG(*) AS nr_inregistrari,\n COUNT(DISTINCT b.account_key) AS nr_conturi,\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,\n CAST(:period_from AS date) AS data_de_la,\n DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la\nFROM (SELECT a.*, CASE WHEN a.id_centru_profit IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.id_centru_profit)) END AS center_key, CASE WHEN a.cont IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.cont)) END AS account_key,\n COALESCE(NULLIF(LTRIM(RTRIM(a.den_centru_profit)),N''),N'Fără centru atribuit') AS centru,\n COALESCE(NULLIF(LTRIM(RTRIM(a.cont)),N''),N'Fără cont atribuit') AS cont_afisat\nFROM dbo.accesex_analiza_centre_profit_view a\nWHERE a.data_document >= :period_from AND a.data_document < :period_until\n AND COALESCE(a.venit,0) <> 0\n AND CASE WHEN a.id_centru_profit IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.id_centru_profit)) END = :center_key) b\nGROUP BY b.center_key,b.account_key",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "59576284-E15B-50F7-A265-942499D4BF00",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Cheie înregistrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "center_key",
"label": "Cheie centru",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "center_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "account_key",
"label": "Cheie cont",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "account_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "titlu",
"label": "Produs / serviciu / document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "titlu",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "centru",
"label": "Centru de profit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "centru",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cont",
"label": "Cont",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cont",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "suma",
"label": "Venituri înregistrate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "suma",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "numar_document",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_modul",
"label": "Modul Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_modul",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume_furnizor",
"label": "Partener înregistrat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_produs",
"label": "Produs / serviciu",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cod_extern",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_extern",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "um",
"label": "Unitate de măsură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "um",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "detalii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "detalii",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "Perioada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"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": "data_de_la",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_de_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_pana_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Înregistrări venituri",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "096BDA2C-6E77-5478-A846-9ED0E26FF9AE",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "016A97CA-C085-511A-B97F-5184EA894E39",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "center_key",
"id": "3D8E7A9E-505A-5413-B442-455DC3D2AE2E",
"name": "center_key",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "account_key",
"id": "9259D6C5-A89B-5CE4-8984-4AC4B525244B",
"name": "account_key",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"titlu",
"centru",
"cont",
"suma",
"data_document",
"tip_document",
"numar_document",
"den_modul",
"nume_furnizor",
"den_produs",
"cod_extern",
"um",
"cantitate",
"detalii",
"data_de_la",
"data_pana_la"
],
"sourceID": "FC90DDC2-7B2C-5DC4-A121-008494DA5729",
"sqlQuery": "SELECT CONVERT(varchar(40),b.id) AS row_id,b.center_key,b.account_key,\n b.centru,b.cont_afisat AS cont,b.venit AS suma,\n b.data_document,b.tip_document,b.numar_document,\n b.den_modul,b.nume_furnizor,b.den_produs,b.cod_extern,b.um,b.cantitate,b.detalii,\n COALESCE(NULLIF(LTRIM(RTRIM(b.den_produs)),N''),NULLIF(LTRIM(RTRIM(b.nume_furnizor)),N''),\n NULLIF(LTRIM(RTRIM(b.tip_document)),N''),N'Înregistrare contabilă') AS titlu,\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,\n CAST(:period_from AS date) AS data_de_la,\n DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la\nFROM (SELECT a.*, CASE WHEN a.id_centru_profit IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.id_centru_profit)) END AS center_key, CASE WHEN a.cont IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.cont)) END AS account_key,\n COALESCE(NULLIF(LTRIM(RTRIM(a.den_centru_profit)),N''),N'Fără centru atribuit') AS centru,\n COALESCE(NULLIF(LTRIM(RTRIM(a.cont)),N''),N'Fără cont atribuit') AS cont_afisat\nFROM dbo.accesex_analiza_centre_profit_view a\nWHERE a.data_document >= :period_from AND a.data_document < :period_until\n AND COALESCE(a.venit,0) <> 0\n AND CASE WHEN a.id_centru_profit IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.id_centru_profit)) END = :center_key\n AND CASE WHEN a.cont IS NULL THEN N'N' ELSE N'V'+LTRIM(RTRIM(a.cont)) END = :account_key) b",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "F41FCFAD-663B-54E5-9968-061228AFB93E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "90079E2F-7C94-52AD-8901-66B1D6EFEB99",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "158B3344-A6F7-5EEE-9609-D1C29D1F5F87",
"title": "Conturile centrului",
"urlKey": ""
}
],
"badgeKey": "suma",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_conturi",
"label": "Conturi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_inregistrari",
"label": "Înregistrări",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "corectii_negative",
"label": "Corecții negative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "30610B53-E2CF-5FCF-BCAD-9FFBB10CAF79",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_conturi",
"label": "Conturi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_inregistrari",
"label": "Înregistrări",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sume_pozitive",
"label": "Sume pozitive",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "corectii_negative",
"label": "Corecții negative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_de_la",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "DBE43301-73CA-5030-A60C-0444FEEBB023",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "62237B8E-90D1-514A-A3EF-9A87CE4668BD",
"includeAllOption": false,
"key": "period_date",
"title": "Perioada",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "CBDFE8EC-F9CE-51F5-A3BE-ED257FC396B3",
"key": "suma",
"type": "number"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "",
"systemImage": "chart.bar",
"title": "Venituri pe centre",
"titleKey": "centru"
},
{
"actions": [
{
"id": "D563B700-B02A-55F6-AEEB-EAE761CB10F2",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "298A3F1D-0A9E-5E70-BD3F-980C4A0AD3A2",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "59576284-E15B-50F7-A265-942499D4BF00",
"title": "Înregistrările contului",
"urlKey": ""
}
],
"badgeKey": "suma",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_inregistrari",
"label": "Înregistrări",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "corectii_negative",
"label": "Corecții negative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "158B3344-A6F7-5EEE-9609-D1C29D1F5F87",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_inregistrari",
"label": "Înregistrări",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sume_pozitive",
"label": "Sume pozitive",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "corectii_negative",
"label": "Corecții negative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_de_la",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "347D52A4-1737-5D33-8A62-18DA60CD7284",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "CBDFE8EC-F9CE-51F5-A3BE-ED257FC396B3",
"key": "suma",
"type": "number"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "centru",
"systemImage": "chart.bar",
"title": "Venituri pe conturi",
"titleKey": "cont"
},
{
"actions": [],
"badgeKey": "suma",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cont",
"label": "Cont",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "59576284-E15B-50F7-A265-942499D4BF00",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "centru",
"label": "Centru de profit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cont",
"label": "Cont",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_modul",
"label": "Modul Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_furnizor",
"label": "Partener înregistrat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs / serviciu",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_extern",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "um",
"label": "Unitate de măsură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "detalii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_de_la",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "272C9CD9-E2B5-543D-8A23-8A517A8D0FB3",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "numar_document",
"systemImage": "doc.text",
"title": "Înregistrări venituri",
"titleKey": "titlu"
}
],
"relations": [
{
"childDatasetID": "158B3344-A6F7-5EEE-9609-D1C29D1F5F87",
"childKey": "center_key",
"id": "90079E2F-7C94-52AD-8901-66B1D6EFEB99",
"name": "Conturile centrului",
"parentDatasetID": "30610B53-E2CF-5FCF-BCAD-9FFBB10CAF79",
"parentKey": "center_key"
},
{
"childDatasetID": "59576284-E15B-50F7-A265-942499D4BF00",
"childKey": "account_key",
"id": "298A3F1D-0A9E-5E70-BD3F-980C4A0AD3A2",
"name": "Înregistrările contului",
"parentDatasetID": "158B3344-A6F7-5EEE-9609-D1C29D1F5F87",
"parentKey": "account_key"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-27T08:02:07Z",
"description": "Venituri înregistrate în analiza centrelor de profit Nexus: alegi perioada nativă Cifru, apoi centrul și contul prin carduri. Vezi totalul și corecțiile negative, numărul de conturi/înregistrări; sub-butoanele deschid conturile centrului și înregistrările contului, cu document, produs/serviciu, partener, cantitate, explicații și modulul de proveniență. Perioada este aplicată ÎNAINTE de agregare și transmisă explicit la fiecare nivel. Citirile pentru conturi/linii sunt restrânse la centrul și contul selectat, nu la întreg istoricul. Sumele provin direct din câmpul venit al analizei Nexus: zero este exclus, corecțiile negative rămân. Nu se calculează din cantitate × preț, nu se face conversie valutară și nu se însumează câmpuri deviz. Nu este balanță contabilă sau profit net certificat; depinde de colectarea/repartizarea din ERP. Un centru fără identificator este separat ca „Fără centru atribuit”; legăturile folosesc chei ascunse, nu numele. Live, fără refresh automat global; maximum 10.000 de rânduri per nivel. Pentru perioade foarte mari, restrânge intervalul. Totalurile includ toate înregistrările care corespund filtrului, dar lista de înregistrări poate afișa cel mult 10.000; nu confunda limita afișării cu un total parțial. Necesită Pro, iOS 1.1.0 build 336 / Android 1.1.0 build 284 sau mai nou pentru parametrii de perioadă. Configurație comunitară neoficială, read-only. Manual: https://www.docs.nexuserp.ro/articol/citire-analiza-centre-profit/4371 .",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "EAD657B8-8154-5CDD-85A0-9DE24DDA1780",
"rootButtonCount": 1,
"summary": "Perioadă → centre cu totaluri → conturi → înregistrări și explicații; corecții negative păstrate.",
"tags": [
"NexusERP",
"contabilitate",
"financiar",
"Pro"
],
"title": "Venituri pe centre și conturi — Pro"
}
}