Parteneri (Pro)
Sold și limită credit → facturi neîncasate cu scadență → produse, prețuri și lot. Identitate corectă, fără amestecarea omonimilor.
Partener → facturi neîncasate → produse. Păstrează datele de contact, agentul, localitatea, limita de credit, soldul clientului (411), soldul precedent, vânzările și încasările anului. Legăturile folosesc identitatea compusă Nexus, nu numele partenerului: omonimii nu se amestecă. Depășirea limitei este partea pozitivă a sold minus limită; un sold indisponibil rămâne necunoscut, nu devine zero. Acesta este sold CLIENT (411), nu sold furnizor (401). Facturile validate și neanulate cu sold pozitiv sunt citite numai pentru partenerul ales, fără a elimina facturile vechi încă neîncasate. Cardul facturii arată dată, scadență, monedă, valoare, încasat, sold, întârziere și gestiune; sub-butonul deschide produsele cu denumire, cod, cantitate, prețuri, TVA și serie/lot. Soldul contabil nu trebuie confundat cu suma facturilor din această sursă; avansurile, efectele sau notele pot produce diferențe. Moneda documentului este păstrată, fără conversii Cifru. Cache-ul principal rămâne 100.000 rânduri, refresh automat la 720 minute; funcția globală de sold poate dura pe baze mari. Facturile și produsele sunt live, la cerere, până la 5.000 rânduri. Pro, numai citire; capturi cu parteneri și valori DEMO. Manuale: https://www.docs.nexuserp.ro/articol/utilizare-urmarire-clienti/3213 ; https://www.docs.nexuserp.ro/articol/citire-facturi-clienti/4340 ; https://www.docs.nexuserp.ro/articol/citire-facturi-clienti-linii/4341 .
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Parteneri
- Details: Facturi neîncasate
- Details: Produsele facturii
- Sub-button: Facturi neîncasate
- Sub-button: Produsele facturii
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 p.id_intern AS row_id,p.cif_cnp,p.denumire,
CASE WHEN p.pers_fizica=1 THEN N'Da' WHEN p.pers_fizica=0 THEN N'Nu' ELSE N'Nespecificat' END AS pers_fizica,p.den_agent,
p.telefon,p.email,p.den_localitate,CAST(p.limita_credit AS decimal(20,2)) AS limita_credit,
p.termen_incasare,p.termen_plata,
CASE WHEN p.platitor_tva=1 THEN N'Da' WHEN p.platitor_tva=0 THEN N'Nu' ELSE N'Nespecificat' END AS platitor_tva,p.observatii,
CAST(b.sold_curent AS decimal(20,2)) AS sold_curent,CAST(b.sold_an_prec AS decimal(20,2)) AS sold_an_prec,
CAST(b.vanzari_an AS decimal(20,2)) AS vanzari_an,CAST(b.incasari_an AS decimal(20,2)) AS incasari_an,
CAST(CASE WHEN b.sold_curent IS NULL OR p.limita_credit IS NULL THEN NULL
WHEN b.sold_curent>p.limita_credit THEN b.sold_curent-p.limita_credit ELSE 0 END AS decimal(20,2)) AS depasire_credit,
CASE WHEN b.id IS NULL THEN N'Sold client indisponibil' ELSE N'Sold client din Nexus (411)' END AS situatie_sold
FROM dbo.accesex_parteneri_view p
LEFT JOIN (SELECT id,pct_lcr,SUM(SdFnCrt411) AS sold_curent,SUM(si_411) AS sold_an_prec,
SUM(TotVanzAn) AS vanzari_an,SUM(TotIncAn) AS incasari_an
FROM dbo.urmarire_parteneri(dbo.anluna(GETDATE()),'C',NULL,NULL,NULL,1)
GROUP BY id,pct_lcr) b
ON p.id_intern=CONCAT(CONVERT(varchar(30),b.id),'(',CONVERT(varchar(10),b.pct_lcr),')')static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT f.id_document AS row_id,f.id_client,f.den_client,f.tip_document, f.serie_document,f.numar_document,f.data_document,f.data_lim,f.den_gestiune,f.den_agent,f.moneda, f.valoare_cu_tva AS valoare,f.valoare_incasata AS incasat,f.sold AS rest,f.stare_factura, CASE WHEN f.data_lim<CAST(GETDATE() AS date) THEN DATEDIFF(day,f.data_lim,CAST(GETDATE() AS date)) ELSE 0 END AS zile_intarziere FROM dbo.accesex_facturi_clienti f WHERE f.id_client=:partner_id AND f.validare=1 AND f.anulare=0 AND f.sold>0
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT l.id_intern AS row_id,l.id_document, l.den_produs,l.cod_produs,l.cantitate,l.pret_vanzare,l.pret_vanzare_tva,l.cont_produs,l.serie_produs,l.cota_tva_ies FROM dbo.accesex_facturi_clienti_lin l WHERE l.id_document=:invoice_id
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server (AccesEx + parteneri)",
"id": "0B738D5E-15AD-4F83-84FB-12B254835546",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_parteneri_view",
"dbo.urmarire_parteneri",
"dbo.accesex_facturi_clienti",
"dbo.accesex_facturi_clienti_lin"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "36080092-4A9A-4BC9-866D-C4E0449A1112",
"key": "sold_curent",
"type": "number"
}
],
"id": "8D8E77BA-670E-4DA2-A8AB-AAC759A8F350",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "denumire",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "denumire",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cif_cnp",
"label": "CIF / CNP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cif_cnp",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pers_fizica",
"label": "Persoană fizică",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pers_fizica",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_agent",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_localitate",
"label": "Localitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_localitate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "telefon",
"label": "Telefon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "telefon",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "email",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "email",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sold_curent",
"label": "Sold curent (411)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sold_curent",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "depasire_credit",
"label": "Depășire față de limită",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "depasire_credit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "limita_credit",
"label": "Limită credit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "limita_credit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "sold_an_prec",
"label": "Sold an precedent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sold_an_prec",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "vanzari_an",
"label": "Vânzări an",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "vanzari_an",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "incasari_an",
"label": "Încasări an",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "incasari_an",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "termen_incasare",
"label": "Termen încasare (zile)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "termen_incasare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "termen_plata",
"label": "Termen plată (zile)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "termen_plata",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "platitor_tva",
"label": "Plătitor TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "platitor_tva",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "observatii",
"label": "Observații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "observatii",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "situatie_sold",
"label": "Disponibilitatea soldului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "situatie_sold",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 100000,
"name": "Parteneri",
"primaryKey": "row_id",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 720
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"denumire",
"cif_cnp",
"den_agent",
"telefon",
"email"
],
"sourceID": "0B738D5E-15AD-4F83-84FB-12B254835546",
"sqlQuery": "SELECT p.id_intern AS row_id,p.cif_cnp,p.denumire,\n CASE WHEN p.pers_fizica=1 THEN N'Da' WHEN p.pers_fizica=0 THEN N'Nu' ELSE N'Nespecificat' END AS pers_fizica,p.den_agent,\n p.telefon,p.email,p.den_localitate,CAST(p.limita_credit AS decimal(20,2)) AS limita_credit,\n p.termen_incasare,p.termen_plata,\n CASE WHEN p.platitor_tva=1 THEN N'Da' WHEN p.platitor_tva=0 THEN N'Nu' ELSE N'Nespecificat' END AS platitor_tva,p.observatii,\n CAST(b.sold_curent AS decimal(20,2)) AS sold_curent,CAST(b.sold_an_prec AS decimal(20,2)) AS sold_an_prec,\n CAST(b.vanzari_an AS decimal(20,2)) AS vanzari_an,CAST(b.incasari_an AS decimal(20,2)) AS incasari_an,\n CAST(CASE WHEN b.sold_curent IS NULL OR p.limita_credit IS NULL THEN NULL\n WHEN b.sold_curent>p.limita_credit THEN b.sold_curent-p.limita_credit ELSE 0 END AS decimal(20,2)) AS depasire_credit,\n CASE WHEN b.id IS NULL THEN N'Sold client indisponibil' ELSE N'Sold client din Nexus (411)' END AS situatie_sold\nFROM dbo.accesex_parteneri_view p\nLEFT JOIN (SELECT id,pct_lcr,SUM(SdFnCrt411) AS sold_curent,SUM(si_411) AS sold_an_prec,\n SUM(TotVanzAn) AS vanzari_an,SUM(TotIncAn) AS incasari_an\n FROM dbo.urmarire_parteneri(dbo.anluna(GETDATE()),'C',NULL,NULL,NULL,1)\n GROUP BY id,pct_lcr) b\n ON p.id_intern=CONCAT(CONVERT(varchar(30),b.id),'(',CONVERT(varchar(10),b.pct_lcr),')')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "9F30289E-0E02-4709-BB46-22A211C4C415",
"key": "data_document",
"type": "date"
}
],
"id": "50A8651C-B498-4ED4-BD8B-FC24D73F1408",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_client",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_document",
"label": "Tip",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "numar_document",
"label": "Număr",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "incasat",
"label": "Încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "incasat",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "rest",
"label": "Rest de încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "rest",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "stare_factura",
"label": "Stare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stare_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_client",
"label": "id_client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_client",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_lim",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Monedă document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"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 de întârziere",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_intarziere",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 5000,
"name": "Facturi neîncasate",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "row_id",
"id": "BD114A3D-90D9-587E-94B6-69535470BF45",
"name": "partner_id",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_client",
"tip_document",
"serie_document",
"numar_document",
"data_document",
"valoare",
"incasat",
"rest",
"stare_factura",
"data_lim",
"moneda",
"den_gestiune",
"den_agent",
"zile_intarziere"
],
"sourceID": "0B738D5E-15AD-4F83-84FB-12B254835546",
"sqlQuery": "SELECT f.id_document AS row_id,f.id_client,f.den_client,f.tip_document,\n f.serie_document,f.numar_document,f.data_document,f.data_lim,f.den_gestiune,f.den_agent,f.moneda,\n f.valoare_cu_tva AS valoare,f.valoare_incasata AS incasat,f.sold AS rest,f.stare_factura,\n CASE WHEN f.data_lim<CAST(GETDATE() AS date) THEN DATEDIFF(day,f.data_lim,CAST(GETDATE() AS date)) ELSE 0 END AS zile_intarziere\nFROM dbo.accesex_facturi_clienti f\nWHERE f.id_client=:partner_id AND f.validare=1 AND f.anulare=0 AND f.sold>0",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "C0662EC4-4556-524F-9B67-210C0C480C6C",
"key": "den_produs",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "8C4504A0-477A-5072-AC76-8F176301D05C",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"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": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare",
"label": "Preț vânzare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cont_produs",
"label": "Cont produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cont_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "serie_produs",
"label": "Serie / lot",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cota_tva_ies",
"label": "Cotă TVA (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cota_tva_ies",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Produsele facturii",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "row_id",
"id": "DC9D26C7-8EBF-5A1C-ACE2-F49B5A605F35",
"name": "invoice_id",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_produs",
"cod_produs",
"cantitate",
"pret_vanzare",
"pret_vanzare_tva",
"cont_produs",
"serie_produs",
"cota_tva_ies"
],
"sourceID": "0B738D5E-15AD-4F83-84FB-12B254835546",
"sqlQuery": "SELECT l.id_intern AS row_id,l.id_document,\n l.den_produs,l.cod_produs,l.cantitate,l.pret_vanzare,l.pret_vanzare_tva,l.cont_produs,l.serie_produs,l.cota_tva_ies\nFROM dbo.accesex_facturi_clienti_lin l WHERE l.id_document=:invoice_id",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "28F28FAF-C639-4484-A6BB-4785F78BDE53",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "9B16A4F8-B89B-4132-89AF-061200341718",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "50A8651C-B498-4ED4-BD8B-FC24D73F1408",
"title": "Facturi neîncasate",
"urlKey": ""
}
],
"badgeKey": "sold_curent",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "denumire",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cif_cnp",
"label": "CIF / CNP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sold_curent",
"label": "Sold curent (411)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "limita_credit",
"label": "Limită credit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "depasire_credit",
"label": "Depășire față de limită",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "situatie_sold",
"label": "Disponibilitatea soldului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "8D8E77BA-670E-4DA2-A8AB-AAC759A8F350",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identificare și contact",
"detailRole": "information",
"isVisible": true,
"key": "denumire",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identificare și contact",
"detailRole": "information",
"isVisible": true,
"key": "cif_cnp",
"label": "CIF / CNP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identificare și contact",
"detailRole": "information",
"isVisible": true,
"key": "pers_fizica",
"label": "Persoană fizică",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identificare și contact",
"detailRole": "information",
"isVisible": true,
"key": "den_agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identificare și contact",
"detailRole": "information",
"isVisible": true,
"key": "den_localitate",
"label": "Localitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identificare și contact",
"detailRole": "information",
"isVisible": true,
"key": "telefon",
"label": "Telefon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identificare și contact",
"detailRole": "information",
"isVisible": true,
"key": "email",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Situație client și credit",
"detailRole": "information",
"isVisible": true,
"key": "sold_curent",
"label": "Sold curent (411)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Situație client și credit",
"detailRole": "information",
"isVisible": true,
"key": "depasire_credit",
"label": "Depășire față de limită",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Situație client și credit",
"detailRole": "information",
"isVisible": true,
"key": "limita_credit",
"label": "Limită credit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Situație client și credit",
"detailRole": "information",
"isVisible": true,
"key": "sold_an_prec",
"label": "Sold an precedent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Situație client și credit",
"detailRole": "information",
"isVisible": true,
"key": "vanzari_an",
"label": "Vânzări an",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Situație client și credit",
"detailRole": "information",
"isVisible": true,
"key": "incasari_an",
"label": "Încasări an",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Situație client și credit",
"detailRole": "information",
"isVisible": true,
"key": "termen_incasare",
"label": "Termen încasare (zile)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Situație client și credit",
"detailRole": "information",
"isVisible": true,
"key": "termen_plata",
"label": "Termen plată (zile)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identificare și contact",
"detailRole": "information",
"isVisible": true,
"key": "platitor_tva",
"label": "Plătitor TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identificare și contact",
"detailRole": "information",
"isVisible": true,
"key": "observatii",
"label": "Observații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Situație client și credit",
"detailRole": "information",
"isVisible": true,
"key": "situatie_sold",
"label": "Disponibilitatea soldului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "CA9AAF5B-74EE-4334-B768-3290F4E1C920",
"openFilters": [
{
"id": "958C4887-7AE9-43E4-B074-A18F4882FACA",
"includeAllOption": true,
"key": "den_agent",
"title": "Alege agentul",
"type": "text"
},
{
"id": "A05E165A-2646-4A5A-A9BB-034100762BDC",
"includeAllOption": true,
"key": "pers_fizica",
"title": "Persoană fizică? (1=da, 0=firmă)",
"type": "number"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "7AD27948-2F32-407E-8D8E-DF209C03F3B3",
"key": "sold_curent",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "den_agent",
"systemImage": "person.2",
"title": "Parteneri",
"titleKey": "denumire"
},
{
"actions": [
{
"id": "EEB1D6E5-5B7F-58DA-ACA7-C9FCCBFE7179",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "AB5F49A1-C88F-514D-BBF5-87AFCE279710",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8C4504A0-477A-5072-AC76-8F176301D05C",
"title": "Produsele facturii",
"urlKey": ""
}
],
"badgeKey": "rest",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"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ă document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "incasat",
"label": "Încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_intarziere",
"label": "Zile de întârziere",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "50A8651C-B498-4ED4-BD8B-FC24D73F1408",
"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": "tip_document",
"label": "Tip",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "incasat",
"label": "Încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stare_factura",
"label": "Stare",
"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ă document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"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 de întârziere",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "1792C903-630D-4FB4-ABCB-3FD804E82FC2",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "AF6BF87F-DFAD-4F42-9A85-C4C7144FB10A",
"key": "data_document",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "serie_document",
"systemImage": "doc.text",
"title": "Facturi neîncasate",
"titleKey": "numar_document"
},
{
"actions": [],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț vânzare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "8C4504A0-477A-5072-AC76-8F176301D05C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț vânzare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cont_produs",
"label": "Cont produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_produs",
"label": "Serie / lot",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_ies",
"label": "Cotă TVA (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "EB48E1B8-FEE6-582D-9918-E2298111BEA7",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "C0662EC4-4556-524F-9B67-210C0C480C6C",
"key": "den_produs",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "doc.text",
"title": "Produsele facturii",
"titleKey": "den_produs"
}
],
"relations": [
{
"childDatasetID": "50A8651C-B498-4ED4-BD8B-FC24D73F1408",
"childKey": "id_client",
"id": "9B16A4F8-B89B-4132-89AF-061200341718",
"name": "Facturi neîncasate",
"parentDatasetID": "8D8E77BA-670E-4DA2-A8AB-AAC759A8F350",
"parentKey": "row_id"
},
{
"childDatasetID": "8C4504A0-477A-5072-AC76-8F176301D05C",
"childKey": "id_document",
"id": "AB5F49A1-C88F-514D-BBF5-87AFCE279710",
"name": "Produsele facturii",
"parentDatasetID": "50A8651C-B498-4ED4-BD8B-FC24D73F1408",
"parentKey": "row_id"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-11T00:00:00Z",
"description": "Partener → facturi neîncasate → produse. Păstrează datele de contact, agentul, localitatea, limita de credit, soldul clientului (411), soldul precedent, vânzările și încasările anului. Legăturile folosesc identitatea compusă Nexus, nu numele partenerului: omonimii nu se amestecă. Depășirea limitei este partea pozitivă a sold minus limită; un sold indisponibil rămâne necunoscut, nu devine zero. Acesta este sold CLIENT (411), nu sold furnizor (401). Facturile validate și neanulate cu sold pozitiv sunt citite numai pentru partenerul ales, fără a elimina facturile vechi încă neîncasate. Cardul facturii arată dată, scadență, monedă, valoare, încasat, sold, întârziere și gestiune; sub-butonul deschide produsele cu denumire, cod, cantitate, prețuri, TVA și serie/lot. Soldul contabil nu trebuie confundat cu suma facturilor din această sursă; avansurile, efectele sau notele pot produce diferențe. Moneda documentului este păstrată, fără conversii Cifru. Cache-ul principal rămâne 100.000 rânduri, refresh automat la 720 minute; funcția globală de sold poate dura pe baze mari. Facturile și produsele sunt live, la cerere, până la 5.000 rânduri. Pro, numai citire; capturi cu parteneri și valori DEMO. Manuale: https://www.docs.nexuserp.ro/articol/utilizare-urmarire-clienti/3213 ; https://www.docs.nexuserp.ro/articol/citire-facturi-clienti/4340 ; https://www.docs.nexuserp.ro/articol/citire-facturi-clienti-linii/4341 .",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "991BF83B-DE2F-4C8C-97E2-238CD8787E2E",
"rootButtonCount": 1,
"summary": "Sold și limită credit → facturi neîncasate cu scadență → produse, prețuri și lot. Identitate corectă, fără amestecarea omonimilor.",
"tags": [
"NexusERP",
"parteneri",
"clienti",
"sold",
"credit",
"restante",
"pro"
],
"title": "Parteneri (Pro)"
}
}