Facturi clienți restante — Pro
Facturile validate și neanulate, cu rest pozitiv și scadență depășită. Vezi clientul, documentul, restul și zilele de întârziere.
Lista urmărește facturile din accesex_facturi_clienti, nu întregul sold contabil al clientului. Scadența trebuie să fie înainte de ziua curentă; facturile scadente astăzi sau fără scadență nu sunt incluse. Restul se citește din sold, fără recalculare sau conversie valutară. Moneda este cea din document; nu există un total care să amestece monede diferite. Scadențele anterioare datei facturii sunt semnalate, nu corectate automat. Poți filtra după gestiune, monedă sau agent. Datele de antet sunt completate de liniile reale ale facturii prin Detalii produse.
Manuale Nexus: https://www.docs.nexuserp.ro/articol/interogare-date-prin-nexus-api/4237 ; https://www.docs.nexuserp.ro/articol/afisare-camp-calculat-in-modul/4911 . Adaptare SQL Server verificată read-only pe schema Nexus; nu este o configurație oficială Nexus.
Cache automat la 60 de minute, maximum 100.000 de rânduri. Numai citire; plan Pro pentru SQL personalizat.
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Facturi clienți restante
- Details: Produsele facturii
- Sub-button: Linii factura client
Sources are mapped locally and verified before applying.
Custom queriesPRO1 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 h.id_document, h.den_client, h.numar_document, h.serie_document, h.data_document, h.data_lim, h.den_gestiune, h.moneda, h.valoare_cu_tva, h.valoare_incasata, h.sold, h.den_agent, DATEDIFF(day, CAST(h.data_lim AS date), CAST(GETDATE() AS date)) AS zile_intarziere, CASE WHEN h.data_lim < h.data_document THEN N'Verifică scadența documentului' ELSE N'Restantă' END AS situatie FROM dbo.accesex_facturi_clienti AS h WHERE h.validare = 1 AND h.anulare = 0 AND h.sold > 0 AND h.data_lim < CAST(GETDATE() AS date)
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP",
"id": "07CCDBE4-28FC-5270-8BB5-3224A3152756",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_facturi_clienti",
"dbo.accesex_facturi_clienti_lin"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "A98483BD-DF28-5EA3-ABC1-42DD84EB1ABD",
"key": "zile_intarziere",
"type": "number"
},
{
"direction": "ascending",
"id": "ADCBE1E7-97C5-55A5-8864-AEA9260338B5",
"key": "numar_document",
"type": "text"
}
],
"id": "8A178CBA-54BE-547E-AF86-D6F770E62BD2",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "Cheie document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_client",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "numar_document",
"label": "Număr factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_lim",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_cu_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "valoare_incasata",
"label": "Încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_incasata",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sold",
"label": "Rest de încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sold",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_agent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "zile_intarziere",
"label": "Zile întârziere",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_intarziere",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "situatie",
"label": "Situație",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "situatie",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 100000,
"name": "Facturi clienți restante",
"primaryKey": "id_document",
"queryParameters": [],
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_client",
"numar_document",
"serie_document",
"den_gestiune",
"moneda",
"den_agent",
"situatie"
],
"sourceID": "07CCDBE4-28FC-5270-8BB5-3224A3152756",
"sqlQuery": "SELECT\n h.id_document, h.den_client, h.numar_document, h.serie_document,\n h.data_document, h.data_lim, h.den_gestiune, h.moneda,\n h.valoare_cu_tva, h.valoare_incasata, h.sold, h.den_agent,\n DATEDIFF(day, CAST(h.data_lim AS date), CAST(GETDATE() AS date)) AS zile_intarziere,\n CASE WHEN h.data_lim < h.data_document THEN N'Verifică scadența documentului' ELSE N'Restantă' END AS situatie\nFROM dbo.accesex_facturi_clienti AS h\nWHERE h.validare = 1 AND h.anulare = 0 AND h.sold > 0\n AND h.data_lim < CAST(GETDATE() AS date)",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [],
"id": "BAA4F2A6-08A0-5614-9A41-0DFCDCE02BA7",
"mappings": [
{
"commonFieldKey": "",
"key": "id_linie_document",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_linie_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_produs",
"label": "ID produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_produs",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "product_code",
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "product_name",
"key": "den_produs",
"label": "Produs / serviciu",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "denumire_sup",
"label": "Denumire suplimentară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "denumire_sup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "quantity",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cota_tva_ies",
"label": "Cotă TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cota_tva_ies",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "procent_discount",
"label": "Discount (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "procent_discount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_brand",
"label": "Brand",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_brand",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "serie_produs",
"label": "Serie produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_aviz",
"label": "Număr aviz",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_aviz",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_aviz",
"label": "Data avizului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_aviz",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_comanda",
"label": "Număr comandă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_comanda",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_comanda",
"label": "Data comenzii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_comanda",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_expirare",
"label": "Data expirării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_expirare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Linii facturi clienți",
"primaryKey": "id_linie_document",
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cod_produs",
"den_produs",
"denumire_sup",
"den_brand",
"serie_produs",
"data_aviz",
"numar_comanda"
],
"sourceID": "07CCDBE4-28FC-5270-8BB5-3224A3152756",
"sqlQuery": "",
"tableName": "dbo.accesex_facturi_clienti_lin"
}
],
"pages": [
{
"actions": [
{
"id": "5B23FDFD-E84F-55CF-B320-3DBEAC44CF63",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "BFFDDC69-03D8-5F98-A683-9AA52005A367",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "BAA4F2A6-08A0-5614-9A41-0DFCDCE02BA7",
"title": "Detalii produse",
"urlKey": ""
}
],
"badgeKey": "sold",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sold",
"label": "Rest de încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_intarziere",
"label": "Zile întârziere",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "situatie",
"label": "Situație",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "8A178CBA-54BE-547E-AF86-D6F770E62BD2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_incasata",
"label": "Încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sold",
"label": "Rest de încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_intarziere",
"label": "Zile întârziere",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "situatie",
"label": "Situație",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "B2C96377-8AE0-5B6B-97E8-B4153937F3C5",
"openFilters": [
{
"id": "35EB1D9B-BCAC-58EC-B53A-1C2AE05876F4",
"includeAllOption": true,
"key": "den_gestiune",
"title": "Gestiune",
"type": "text"
},
{
"id": "50262EBF-A30E-520A-877D-A837BC9DACF4",
"includeAllOption": true,
"key": "moneda",
"title": "Monedă",
"type": "text"
},
{
"id": "DE027FB0-81C9-5847-A64A-4FE4832F317A",
"includeAllOption": true,
"key": "den_agent",
"title": "Agent",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "A98483BD-DF28-5EA3-ABC1-42DD84EB1ABD",
"key": "zile_intarziere",
"type": "number"
},
{
"direction": "ascending",
"id": "ADCBE1E7-97C5-55A5-8864-AEA9260338B5",
"key": "numar_document",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "numar_document",
"systemImage": "calendar.badge.clock",
"title": "Facturi clienți restante",
"titleKey": "den_client"
},
{
"actions": [],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs / serviciu",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "BAA4F2A6-08A0-5614-9A41-0DFCDCE02BA7",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod produs",
"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": "denumire_sup",
"label": "Denumire suplimentară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantitati si preturi",
"detailRole": "highlight",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantitati si preturi",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantitati si preturi",
"detailRole": "highlight",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantitati si preturi",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_ies",
"label": "Cotă TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantitati si preturi",
"detailRole": "information",
"isVisible": true,
"key": "procent_discount",
"label": "Discount (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_brand",
"label": "Brand",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_produs",
"label": "Serie produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documente asociate",
"detailRole": "information",
"isVisible": true,
"key": "numar_aviz",
"label": "Număr aviz",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documente asociate",
"detailRole": "information",
"isVisible": true,
"key": "data_aviz",
"label": "Data avizului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documente asociate",
"detailRole": "information",
"isVisible": true,
"key": "numar_comanda",
"label": "Număr comandă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documente asociate",
"detailRole": "information",
"isVisible": true,
"key": "data_comanda",
"label": "Data comenzii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Data expirării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "AF1C1E0F-2454-5BA4-92E0-CF19291D3E6F",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "list.bullet.rectangle",
"title": "Linii factura client",
"titleKey": "den_produs"
}
],
"relations": [
{
"childDatasetID": "BAA4F2A6-08A0-5614-9A41-0DFCDCE02BA7",
"childKey": "id_document",
"id": "BFFDDC69-03D8-5F98-A683-9AA52005A367",
"name": "Produsele facturii",
"parentDatasetID": "8A178CBA-54BE-547E-AF86-D6F770E62BD2",
"parentKey": "id_document"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-24T13:20:32Z",
"description": "Lista urmărește facturile din accesex_facturi_clienti, nu întregul sold contabil al clientului. Scadența trebuie să fie înainte de ziua curentă; facturile scadente astăzi sau fără scadență nu sunt incluse. Restul se citește din sold, fără recalculare sau conversie valutară. Moneda este cea din document; nu există un total care să amestece monede diferite. Scadențele anterioare datei facturii sunt semnalate, nu corectate automat. Poți filtra după gestiune, monedă sau agent. Datele de antet sunt completate de liniile reale ale facturii prin Detalii produse.\n\nManuale Nexus: https://www.docs.nexuserp.ro/articol/interogare-date-prin-nexus-api/4237 ; https://www.docs.nexuserp.ro/articol/afisare-camp-calculat-in-modul/4911 . Adaptare SQL Server verificată read-only pe schema Nexus; nu este o configurație oficială Nexus.\n\nCache automat la 60 de minute, maximum 100.000 de rânduri. Numai citire; plan Pro pentru SQL personalizat.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0",
"minimumPlan": "pro",
"packageID": "B74CADB4-EB20-5D52-9530-A09452C7ADE2",
"rootButtonCount": 1,
"summary": "Facturile validate și neanulate, cu rest pozitiv și scadență depășită. Vezi clientul, documentul, restul și zilele de întârziere.",
"tags": [
"NexusERP",
"read-only",
"scadențe"
],
"title": "Facturi clienți restante — Pro"
}
}