Cheltuieli pe centre și conturi — Pro
Perioadă → centre cu totaluri → conturi → înregistrări și explicații; corecții negative păstrate.
Cheltuieli î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 cheltuieli 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: Cheltuieli pe centre
- Details: Conturile centrului
- Details: Înregistrările contului
- Sub-button: Cheltuieli pe conturi
- Sub-button: Înregistrări cheltuieli
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.cheltuieli) AS suma,
SUM(CASE WHEN b.cheltuieli>0 THEN b.cheltuieli ELSE 0 END) AS sume_pozitive,
SUM(CASE WHEN b.cheltuieli<0 THEN b.cheltuieli 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.cheltuieli,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.cheltuieli) AS suma,
SUM(CASE WHEN b.cheltuieli>0 THEN b.cheltuieli ELSE 0 END) AS sume_pozitive,
SUM(CASE WHEN b.cheltuieli<0 THEN b.cheltuieli 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.cheltuieli,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.cheltuieli 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.cheltuieli,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": "C8811070-5BB6-59BE-A82E-5B48C2B430B1",
"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": "FC200221-9B9D-58BD-8AC6-8AEF51EF835F",
"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": "Cheltuieli î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": "Cheltuieli pe centre",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "42101E85-A729-5617-BD33-3304FEB21034",
"name": "period_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "321C0EFB-A8E1-59D6-A7E7-D1DEB59B35FF",
"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": "C8811070-5BB6-59BE-A82E-5B48C2B430B1",
"sqlQuery": "SELECT b.center_key AS row_id,b.center_key,\n MAX(b.centru) AS centru,\n \n SUM(b.cheltuieli) AS suma,\n SUM(CASE WHEN b.cheltuieli>0 THEN b.cheltuieli ELSE 0 END) AS sume_pozitive,\n SUM(CASE WHEN b.cheltuieli<0 THEN b.cheltuieli 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.cheltuieli,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": "51CFFEFF-081F-5CB3-AAB3-2B5A8581BDB6",
"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": "Cheltuieli î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": "Cheltuieli pe conturi",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "5A61A4FD-49C3-535C-9573-2267F1A307E2",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "A7775D7D-9016-5256-921A-E84C0A217D86",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "center_key",
"id": "D1361CE3-499B-5C83-A0AC-6667370513B0",
"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": "C8811070-5BB6-59BE-A82E-5B48C2B430B1",
"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.cheltuieli) AS suma,\n SUM(CASE WHEN b.cheltuieli>0 THEN b.cheltuieli ELSE 0 END) AS sume_pozitive,\n SUM(CASE WHEN b.cheltuieli<0 THEN b.cheltuieli 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.cheltuieli,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": "2609DF26-F4C0-551F-88E5-0DB53F3ACC5F",
"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": "Cheltuieli î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 cheltuieli",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "F24A75BA-3B1A-5150-BE35-227A199C2AFC",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "3313C9B2-8487-51A2-8A0B-9F90E40C1E6F",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "center_key",
"id": "1C17050A-9C74-50CE-8D98-69FB814B058B",
"name": "center_key",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "account_key",
"id": "D2794FD4-E74C-575C-9F9D-7541D74FED99",
"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": "C8811070-5BB6-59BE-A82E-5B48C2B430B1",
"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.cheltuieli 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.cheltuieli,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": "5DE0D04B-1602-5A60-BD2C-AB6B02B7088B",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "4FC98626-8E2A-52A8-AA5E-F92B526FE2EB",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "51CFFEFF-081F-5CB3-AAB3-2B5A8581BDB6",
"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": "FC200221-9B9D-58BD-8AC6-8AEF51EF835F",
"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": "B0FF5B37-0B84-5EF1-8B51-2EE5983A5A8C",
"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": "Cheltuieli pe centre",
"titleKey": "centru"
},
{
"actions": [
{
"id": "DE36E792-B3CA-54D4-B292-85D6374725DD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "507D716A-3D0A-5200-906B-26D015C885B1",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "2609DF26-F4C0-551F-88E5-0DB53F3ACC5F",
"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": "51CFFEFF-081F-5CB3-AAB3-2B5A8581BDB6",
"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": "8A996A14-62FC-5D2C-993D-76AAC5B1C3F3",
"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": "Cheltuieli 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": "2609DF26-F4C0-551F-88E5-0DB53F3ACC5F",
"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": "D819AF7C-D05C-5A4E-9643-76D973B4AC6B",
"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 cheltuieli",
"titleKey": "titlu"
}
],
"relations": [
{
"childDatasetID": "51CFFEFF-081F-5CB3-AAB3-2B5A8581BDB6",
"childKey": "center_key",
"id": "4FC98626-8E2A-52A8-AA5E-F92B526FE2EB",
"name": "Conturile centrului",
"parentDatasetID": "FC200221-9B9D-58BD-8AC6-8AEF51EF835F",
"parentKey": "center_key"
},
{
"childDatasetID": "2609DF26-F4C0-551F-88E5-0DB53F3ACC5F",
"childKey": "account_key",
"id": "507D716A-3D0A-5200-906B-26D015C885B1",
"name": "Înregistrările contului",
"parentDatasetID": "51CFFEFF-081F-5CB3-AAB3-2B5A8581BDB6",
"parentKey": "account_key"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-27T08:02:07Z",
"description": "Cheltuieli î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 cheltuieli 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": "156B08BA-9228-55BD-9F46-1FB7C79164CE",
"rootButtonCount": 1,
"summary": "Perioadă → centre cu totaluri → conturi → înregistrări și explicații; corecții negative păstrate.",
"tags": [
"NexusERP",
"contabilitate",
"financiar",
"Pro"
],
"title": "Cheltuieli pe centre și conturi — Pro"
}
}