Încasări & plăți — bancă & card
Încasări și plăți prin bancă și card (OP, BO, card, CEC, extras), cu sens, filtre și drill pe facturile achitate; read-only, live.
Încasări și plăți prin BANCĂ și CARD din NexusERP (read-only, live). Acoperă Ordin de plată, Bilet la ordin, Card bancar, C.E.C., Extras de cont și Foaie de vărsământ — exclude numerarul (casa).
Ce arată: fiecare document cu Data, Tipul (OP/BO/Card/CEC/Extras), Sensul (Încasare sau Plată), Partenerul, Suma, Moneda și explicațiile. La deschidere alegi filtrele (Sens, Tip document, Perioadă) și apeși afișare.
Drill: atinge un document → vezi FACTURILE pe care le-a stins (serie/număr, dată, sumă achitată) — reconciliat exact cu suma documentului.
Widget-uri: Total încasări, Total plăți, defalcare pe tip de document și pe lună.
Cum se calculează: sursa este dbo.accesex_incasari_plati_view (+ _lin_view pentru repartizarea pe facturi), filtrat pe tip_financiar bancar (BAL/BAD); Sensul din câmpul plata (0=încasare, 1=plată). Fereastra: ultimele 120 de zile. Fără funcții custom — merge pe orice instalare NexusERP.
Pregătire: login SQL read-only cu SELECT pe dbo.accesex_incasari_plati_view și dbo.accesex_incasari_plati_lin_view; acces securizat (VPN/TLS). Necesită Pro (SQL personalizat).
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Bancă & card
- Details: Facturile documentului
Sources are mapped locally and verified before applying.
Custom queriesPRO2 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
LTRIM(RTRIM(v.id_document)) AS id_document,
MAX(CAST(v.data_document AS date)) AS data,
DATEFROMPARTS(YEAR(MAX(v.data_document)), MONTH(MAX(v.data_document)), 1) AS luna,
MAX(LTRIM(RTRIM(ISNULL(v.tip_document, N'-')))) AS tip_document,
MAX(CASE WHEN v.plata = 1 THEN N'Plata' ELSE N'Incasare' END) AS sens,
MAX(LTRIM(RTRIM(ISNULL(v.serie_document, N''))) + N' ' + LTRIM(RTRIM(ISNULL(v.numar_document, N'')))) AS document,
MAX(NULLIF(LTRIM(RTRIM(ISNULL(v.den_coresp, N''))), N'')) AS partener,
MAX(LTRIM(RTRIM(ISNULL(v.moneda, N'RON')))) AS moneda,
CAST(SUM(ISNULL(v.suma, 0)) AS decimal(18, 2)) AS suma,
CAST(SUM(CASE WHEN v.plata = 0 THEN ISNULL(v.suma, 0) ELSE 0 END) AS decimal(18, 2)) AS incasari,
CAST(SUM(CASE WHEN v.plata = 1 THEN ISNULL(v.suma, 0) ELSE 0 END) AS decimal(18, 2)) AS plati,
MAX(LTRIM(RTRIM(ISNULL(v.explicatii, N'')))) AS explicatii,
MAX(LTRIM(RTRIM(ISNULL(v.den_agent, N'')))) AS agent,
MAX(LTRIM(RTRIM(ISNULL(v.den_centru_profit, N'')))) AS centru_profit
FROM dbo.accesex_incasari_plati_view v
WHERE v.tip_financiar IN ('BAL', 'BAD')
AND v.data_document >= DATEADD(day, -120, CAST(GETDATE() AS date))
GROUP BY LTRIM(RTRIM(v.id_document))static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT
CONCAT(LTRIM(RTRIM(l.id_document)), N'|', LTRIM(RTRIM(l.id_factura))) AS row_id,
LTRIM(RTRIM(l.id_document)) AS id_document,
CASE WHEN l.tip_factura = 'FUR' THEN N'Factura furnizor'
WHEN l.tip_factura = 'CLI' THEN N'Factura client'
ELSE LTRIM(RTRIM(ISNULL(l.tip_factura, N'-'))) END AS tip_factura,
LTRIM(RTRIM(ISNULL(l.serie_factura, N''))) + N' ' + LTRIM(RTRIM(ISNULL(l.numar_factura, N''))) AS factura,
CAST(l.data_factura AS date) AS data_factura,
CAST(ISNULL(l.suma_repartizata, 0) AS decimal(18, 2)) AS suma_achitata
FROM dbo.accesex_incasari_plati_lin_view l
INNER JOIN dbo.accesex_incasari_plati_view v ON v.id_document = l.id_document
WHERE v.tip_financiar IN ('BAL', 'BAD')
AND v.data_document >= DATEADD(day, -120, CAST(GETDATE() AS date))static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server (AccesEx)",
"id": "8B777432-C0F0-5C59-9FA2-EA7FF27F895E",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_incasari_plati_view",
"dbo.accesex_incasari_plati_lin_view"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "18BDBE81-C082-54F7-8966-141F1F0EA2F8",
"key": "data",
"type": "date"
}
],
"id": "1B0B166C-C627-5FC9-8ABE-53A51D8738B2",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "document_date",
"key": "data",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "luna",
"label": "Luna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "luna",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "sens",
"label": "Sens",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sens",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "document",
"label": "Serie / număr",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "partner_name",
"key": "partener",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "partener",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "amount",
"key": "suma",
"label": "Sumă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "suma",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "incasari",
"label": "Încasări (lei)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "incasari",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "plati",
"label": "Plăți (lei)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "plati",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "explicatii",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "agent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "centru_profit",
"label": "Centru de profit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "centru_profit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 15000,
"name": "Documente bancă/card",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"partener",
"explicatii",
"tip_document",
"document"
],
"sourceID": "8B777432-C0F0-5C59-9FA2-EA7FF27F895E",
"sqlQuery": "SELECT\n LTRIM(RTRIM(v.id_document)) AS id_document,\n MAX(CAST(v.data_document AS date)) AS data,\n DATEFROMPARTS(YEAR(MAX(v.data_document)), MONTH(MAX(v.data_document)), 1) AS luna,\n MAX(LTRIM(RTRIM(ISNULL(v.tip_document, N'-')))) AS tip_document,\n MAX(CASE WHEN v.plata = 1 THEN N'Plata' ELSE N'Incasare' END) AS sens,\n MAX(LTRIM(RTRIM(ISNULL(v.serie_document, N''))) + N' ' + LTRIM(RTRIM(ISNULL(v.numar_document, N'')))) AS document,\n MAX(NULLIF(LTRIM(RTRIM(ISNULL(v.den_coresp, N''))), N'')) AS partener,\n MAX(LTRIM(RTRIM(ISNULL(v.moneda, N'RON')))) AS moneda,\n CAST(SUM(ISNULL(v.suma, 0)) AS decimal(18, 2)) AS suma,\n CAST(SUM(CASE WHEN v.plata = 0 THEN ISNULL(v.suma, 0) ELSE 0 END) AS decimal(18, 2)) AS incasari,\n CAST(SUM(CASE WHEN v.plata = 1 THEN ISNULL(v.suma, 0) ELSE 0 END) AS decimal(18, 2)) AS plati,\n MAX(LTRIM(RTRIM(ISNULL(v.explicatii, N'')))) AS explicatii,\n MAX(LTRIM(RTRIM(ISNULL(v.den_agent, N'')))) AS agent,\n MAX(LTRIM(RTRIM(ISNULL(v.den_centru_profit, N'')))) AS centru_profit\nFROM dbo.accesex_incasari_plati_view v\nWHERE v.tip_financiar IN ('BAL', 'BAD')\n AND v.data_document >= DATEADD(day, -120, CAST(GETDATE() AS date))\nGROUP BY LTRIM(RTRIM(v.id_document))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "D15BC29C-D4BA-57B6-8FE7-E0F2A088E620",
"key": "data_factura",
"type": "date"
}
],
"id": "6439CA7D-2AB6-5783-99BC-7E5816B48743",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_document",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_factura",
"label": "Tip factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_number",
"key": "factura",
"label": "Factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "data_factura",
"label": "Data factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_factura",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "amount",
"key": "suma_achitata",
"label": "Sumă achitată (lei)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "suma_achitata",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Facturi achitate",
"primaryKey": "row_id",
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"factura",
"tip_factura"
],
"sourceID": "8B777432-C0F0-5C59-9FA2-EA7FF27F895E",
"sqlQuery": "SELECT\n CONCAT(LTRIM(RTRIM(l.id_document)), N'|', LTRIM(RTRIM(l.id_factura))) AS row_id,\n LTRIM(RTRIM(l.id_document)) AS id_document,\n CASE WHEN l.tip_factura = 'FUR' THEN N'Factura furnizor'\n WHEN l.tip_factura = 'CLI' THEN N'Factura client'\n ELSE LTRIM(RTRIM(ISNULL(l.tip_factura, N'-'))) END AS tip_factura,\n LTRIM(RTRIM(ISNULL(l.serie_factura, N''))) + N' ' + LTRIM(RTRIM(ISNULL(l.numar_factura, N''))) AS factura,\n CAST(l.data_factura AS date) AS data_factura,\n CAST(ISNULL(l.suma_repartizata, 0) AS decimal(18, 2)) AS suma_achitata\nFROM dbo.accesex_incasari_plati_lin_view l\nINNER JOIN dbo.accesex_incasari_plati_view v ON v.id_document = l.id_document\nWHERE v.tip_financiar IN ('BAL', 'BAD')\n AND v.data_document >= DATEADD(day, -120, CAST(GETDATE() AS date))",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "A8E0F43B-17E1-5C2A-9E8E-40B4E561D6C7",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "AA410AB5-260F-5E36-96C2-A2107DB7E060",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "6439CA7D-2AB6-5783-99BC-7E5816B48743",
"title": "Facturi achitate",
"urlKey": ""
}
],
"badgeKey": "sens",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data",
"label": "Data",
"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": "sens",
"label": "Sens",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "partener",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "suma",
"label": "Sumă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "1B0B166C-C627-5FC9-8ABE-53A51D8738B2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "document",
"label": "Serie / număr",
"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": "sens",
"label": "Sens",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "partener",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "suma",
"label": "Sumă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "incasari",
"label": "Încasări (lei)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "plati",
"label": "Plăți (lei)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "centru_profit",
"label": "Centru de profit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "4AF75A35-AA49-5F88-87C4-30DAD67F5ABA",
"openFilters": [
{
"id": "5442BE31-83C9-502A-BD6A-DBB9F1FABA7A",
"includeAllOption": true,
"key": "sens",
"title": "Sens (Încasare/Plată)",
"type": "text"
},
{
"id": "5DD55FB7-29EE-5119-A583-A501CD2DF4BD",
"includeAllOption": true,
"key": "tip_document",
"title": "Tip document",
"type": "text"
},
{
"datePeriodOptions": [
"today",
"last7Days",
"last30Days",
"currentMonth",
"last90Days"
],
"id": "9B89B9CE-2C74-5B05-A46B-3E6255200C68",
"includeAllOption": false,
"key": "data",
"title": "Perioadă",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "18BDBE81-C082-54F7-8966-141F1F0EA2F8",
"key": "data",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "partener",
"systemImage": "creditcard",
"title": "Bancă & card",
"titleKey": "tip_document"
}
],
"relations": [
{
"childDatasetID": "6439CA7D-2AB6-5783-99BC-7E5816B48743",
"childKey": "id_document",
"id": "AA410AB5-260F-5E36-96C2-A2107DB7E060",
"name": "Facturile documentului",
"parentDatasetID": "1B0B166C-C627-5FC9-8ABE-53A51D8738B2",
"parentKey": "id_document"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-08-20T16:18:21Z",
"description": "Încasări și plăți prin BANCĂ și CARD din NexusERP (read-only, live). Acoperă Ordin de plată, Bilet la ordin, Card bancar, C.E.C., Extras de cont și Foaie de vărsământ — exclude numerarul (casa).\n\nCe arată: fiecare document cu Data, Tipul (OP/BO/Card/CEC/Extras), Sensul (Încasare sau Plată), Partenerul, Suma, Moneda și explicațiile. La deschidere alegi filtrele (Sens, Tip document, Perioadă) și apeși afișare.\n\nDrill: atinge un document → vezi FACTURILE pe care le-a stins (serie/număr, dată, sumă achitată) — reconciliat exact cu suma documentului.\n\nWidget-uri: Total încasări, Total plăți, defalcare pe tip de document și pe lună.\n\nCum se calculează: sursa este dbo.accesex_incasari_plati_view (+ _lin_view pentru repartizarea pe facturi), filtrat pe tip_financiar bancar (BAL/BAD); Sensul din câmpul plata (0=încasare, 1=plată). Fereastra: ultimele 120 de zile. Fără funcții custom — merge pe orice instalare NexusERP.\n\nPregătire: login SQL read-only cu SELECT pe dbo.accesex_incasari_plati_view și dbo.accesex_incasari_plati_lin_view; acces securizat (VPN/TLS). Necesită Pro (SQL personalizat).",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0",
"minimumPlan": "pro",
"packageID": "188544CA-4519-54F6-B6BA-78D2C755580A",
"rootButtonCount": 1,
"summary": "Încasări și plăți prin bancă și card (OP, BO, card, CEC, extras), cu sens, filtre și drill pe facturile achitate; read-only, live.",
"tags": [
"NexusERP",
"banca",
"card",
"incasari",
"plati",
"OP",
"bilet la ordin",
"extras",
"trezorerie"
],
"title": "Încasări & plăți — bancă & card"
}
}