Facturi clienți — Pro
Facturi și linii, sold client și neîncasate accesibile direct din detaliu.
Facturi clienți read-only, construite din antetul și liniile AccesEx confirmate live. Câmpul sold a fost verificat pe toate rândurile active din instalarea de test și corespunde diferenței dintre valoarea cu TVA și valoarea încasată.
Varianta Free oferă două intrări clare: facturile filtrate obligatoriu pe o perioadă și lista facturilor cu rest de încasat; ambele pot deschide liniile documentului. Varianta Pro păstrează un singur ecran principal mai bogat și adaugă în detaliul facturii sub-butoanele „Facturi neîncasate ale clientului” și „Sold și rulaje client”, plus două indicatoare compacte pe Home. Gestiunea și starea rămân filtre utile, dar perioada împiedică încărcarea accidentală a unui istoric foarte mare.
Configurare:
1. Creează un login SQL read-only cu SELECT numai pe obiectele cerute.
2. Adaugă sursa SQL Server în Cifru, activează TLS și testează structura.
3. Importă pachetul, mapează slotul și rulează testul local.
Soldul Pro pe client provine din funcția read-only urmarire_parteneri, aceeași familie de date folosită de MAXapp pentru modalul de sold. Lista neîncasatelor folosește sold > 0 și exclude documentele anulate. Pachet neoficial, fără afiliere NexusERP.
What this package creates
2 Home5 Details5 lists1 sources to map
- Home: Clienți cu sold
- Home: Facturi clienți
- Details: Linii factură
- Details: Neîncasate client
- Details: Linii factură neîncasată
- Details: Sold client
- Details: Facturile neîncasate ale clientului
- Sub-button: Linii factură client
- Sub-button: Facturi neîncasate ale clientului
- Sub-button: Sold contabil (411) și rulaje
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.2.sqlQuerySELECT
f.id_document, f.id_client, f.serie_document, f.numar_document,
f.data_document, f.den_client, f.cif_client, f.den_gestiune,
f.valoare, f.valoare_cu_tva, f.valoare_incasata, f.sold,
f.stare_factura, f.data_lim, f.moneda, f.mod_plata,
f.den_agent, f.den_facturist, f.user_creare,
DATEDIFF(day, f.data_lim, CAST(GETDATE() AS date)) AS zile_fata_de_scadenta
FROM dbo.accesex_facturi_clienti f WITH (NOLOCK)
WHERE ISNULL(f.anulare, 0) = 0
AND ISNULL(f.sold, 0) > 0.005static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT
CONCAT(CAST(id AS varchar(30)), '(', CAST(pct_lcr AS varchar(10)), ')') AS id_partener,
LTRIM(RTRIM(nume)) AS client,
LTRIM(RTRIM(cod_fiscal)) AS cif,
CAST(SdFnCrt411 AS decimal(19, 2)) AS sold_client,
CAST(sold_cu_efecte_411 AS decimal(19, 2)) AS sold_cu_efecte,
CAST(TotVanzAn AS decimal(19, 2)) AS vanzari_an,
CAST(TotIncAn AS decimal(19, 2)) AS incasari_an,
CAST(pr_inc AS decimal(19, 2)) AS termen_mediu_incasare
FROM dbo.urmarire_parteneri(dbo.anluna(GETDATE()), 'C', NULL, NULL, NULL, 1)static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.4.sqlQuerySELECT
LTRIM(RTRIM(den_client)) AS client,
MAX(LTRIM(RTRIM(ISNULL(cif_client, N'')))) AS cif,
CAST(SUM(ISNULL(sold, 0)) AS decimal(19, 2)) AS sold_restant,
CAST(SUM(CASE WHEN ISNULL(sold, 0) > 0.005 THEN 1 ELSE 0 END) AS int) AS nr_neincasate,
CAST(SUM(ISNULL(valoare_cu_tva, 0)) AS decimal(19, 2)) AS total_facturat,
CAST(SUM(ISNULL(valoare_incasata, 0)) AS decimal(19, 2)) AS total_incasat,
MAX(CONVERT(varchar(10), data_lim, 23)) AS ultima_scadenta
FROM dbo.accesex_facturi_clienti WITH (NOLOCK)
WHERE ISNULL(anulare, 0) = 0
GROUP BY LTRIM(RTRIM(den_client))
HAVING SUM(ISNULL(sold, 0)) > 0.005static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server (AccesEx)",
"id": "932B1EE8-1ED4-56A6-B9EF-9B2844229026",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_facturi_clienti",
"dbo.accesex_facturi_clienti_lin",
"dbo.urmarire_parteneri"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"id": "519E43E0-D53D-55C1-8F8C-4102156DD070",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_client",
"label": "ID client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_client",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_number",
"key": "numar_document",
"label": "Număr factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "data_document",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "customer_name",
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_client",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cif_client",
"label": "CIF client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cif_client",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_cu_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare_incasata",
"label": "Valoare încasată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_incasata",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sold",
"label": "Rest pe factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sold",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "stare_factura",
"label": "Stare factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stare_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_lim",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "mod_plata",
"label": "Mod de plată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "mod_plata",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_agent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_facturist",
"label": "Facturist",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_facturist",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "user_creare",
"label": "Creată de",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "user_creare",
"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": "numar_awb",
"label": "AWB",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_awb",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cod_uit",
"label": "Cod UIT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_uit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_adresa",
"label": "Adresă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_adresa",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "localitate_livrare",
"label": "Localitate livrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "localitate_livrare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "judet_livrare",
"label": "Județ livrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "judet_livrare",
"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": "validare",
"label": "Validată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "validare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "anulare",
"label": "Anulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "anulare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_cr",
"label": "Creată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_cr",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_md",
"label": "Modificată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_md",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 3000,
"name": "Facturi clienți",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_document",
"id_client",
"serie_document",
"numar_document",
"data_document"
],
"sourceID": "932B1EE8-1ED4-56A6-B9EF-9B2844229026",
"sqlQuery": "",
"tableName": "dbo.accesex_facturi_clienti"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [],
"id": "F92268B2-ADF7-51BB-89EF-FA06BB838D37",
"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": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_linie_document",
"id_document",
"id_produs",
"cod_produs",
"den_produs"
],
"sourceID": "932B1EE8-1ED4-56A6-B9EF-9B2844229026",
"sqlQuery": "",
"tableName": "dbo.accesex_facturi_clienti_lin"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "8644B1A8-84F2-568A-A8D9-D145ADFD968D",
"key": "data_lim",
"type": "date"
}
],
"id": "7ACA3A28-8114-58CA-9A9C-1E0A42B12CE0",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_client",
"label": "ID client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_client",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_number",
"key": "numar_document",
"label": "Număr factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "data_document",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "customer_name",
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_client",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cif_client",
"label": "CIF client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cif_client",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_cu_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare_incasata",
"label": "Valoare încasată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_incasata",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sold",
"label": "Rest pe factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sold",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "stare_factura",
"label": "Stare factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stare_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_lim",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "mod_plata",
"label": "Mod de plată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "mod_plata",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_agent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_facturist",
"label": "Facturist",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_facturist",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "user_creare",
"label": "Creată de",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "user_creare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "zile_fata_de_scadenta",
"label": "Zile față de scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zile_fata_de_scadenta",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 5000,
"name": "Facturi neîncasate",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_document",
"id_client",
"serie_document",
"numar_document",
"data_document"
],
"sourceID": "932B1EE8-1ED4-56A6-B9EF-9B2844229026",
"sqlQuery": "SELECT\n f.id_document, f.id_client, f.serie_document, f.numar_document,\n f.data_document, f.den_client, f.cif_client, f.den_gestiune,\n f.valoare, f.valoare_cu_tva, f.valoare_incasata, f.sold,\n f.stare_factura, f.data_lim, f.moneda, f.mod_plata,\n f.den_agent, f.den_facturist, f.user_creare,\n DATEDIFF(day, f.data_lim, CAST(GETDATE() AS date)) AS zile_fata_de_scadenta\nFROM dbo.accesex_facturi_clienti f WITH (NOLOCK)\nWHERE ISNULL(f.anulare, 0) = 0\n AND ISNULL(f.sold, 0) > 0.005",
"tableName": ""
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [],
"id": "83A902D4-03EA-52CA-B0FB-95BBC9B6DCE8",
"mappings": [
{
"commonFieldKey": "",
"key": "id_partener",
"label": "ID client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_partener",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "client",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cif",
"label": "CIF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cif",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sold_client",
"label": "Sold contabil (411)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sold_client",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "sold_cu_efecte",
"label": "Sold cu efecte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sold_cu_efecte",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "vanzari_an",
"label": "Vânzări în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "vanzari_an",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "incasari_an",
"label": "Încasări în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "incasari_an",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "termen_mediu_incasare",
"label": "Termen mediu de încasare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "termen_mediu_incasare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Sold clienți",
"primaryKey": "id_partener",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_partener",
"client",
"cif",
"sold_client",
"sold_cu_efecte"
],
"sourceID": "932B1EE8-1ED4-56A6-B9EF-9B2844229026",
"sqlQuery": "SELECT\n CONCAT(CAST(id AS varchar(30)), '(', CAST(pct_lcr AS varchar(10)), ')') AS id_partener,\n LTRIM(RTRIM(nume)) AS client,\n LTRIM(RTRIM(cod_fiscal)) AS cif,\n CAST(SdFnCrt411 AS decimal(19, 2)) AS sold_client,\n CAST(sold_cu_efecte_411 AS decimal(19, 2)) AS sold_cu_efecte,\n CAST(TotVanzAn AS decimal(19, 2)) AS vanzari_an,\n CAST(TotIncAn AS decimal(19, 2)) AS incasari_an,\n CAST(pr_inc AS decimal(19, 2)) AS termen_mediu_incasare\nFROM dbo.urmarire_parteneri(dbo.anluna(GETDATE()), 'C', NULL, NULL, NULL, 1)",
"tableName": ""
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D85685-CC7A-58C4-A822-349CF2210FF1",
"key": "sold_restant",
"type": "number"
}
],
"id": "B2B6B775-0FDD-5F7B-AE11-C66A553CF668",
"mappings": [
{
"commonFieldKey": "customer_name",
"key": "client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "client",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cif",
"label": "CIF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cif",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "amount",
"key": "sold_restant",
"label": "Sold restant (facturi)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sold_restant",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_neincasate",
"label": "Facturi neîncasate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_neincasate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "total_facturat",
"label": "Total facturat cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "total_facturat",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "total_incasat",
"label": "Total încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "total_incasat",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ultima_scadenta",
"label": "Ultima scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ultima_scadenta",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Clienți cu sold restant",
"primaryKey": "client",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 30
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"client",
"cif"
],
"sourceID": "932B1EE8-1ED4-56A6-B9EF-9B2844229026",
"sqlQuery": "SELECT\n LTRIM(RTRIM(den_client)) AS client,\n MAX(LTRIM(RTRIM(ISNULL(cif_client, N'')))) AS cif,\n CAST(SUM(ISNULL(sold, 0)) AS decimal(19, 2)) AS sold_restant,\n CAST(SUM(CASE WHEN ISNULL(sold, 0) > 0.005 THEN 1 ELSE 0 END) AS int) AS nr_neincasate,\n CAST(SUM(ISNULL(valoare_cu_tva, 0)) AS decimal(19, 2)) AS total_facturat,\n CAST(SUM(ISNULL(valoare_incasata, 0)) AS decimal(19, 2)) AS total_incasat,\n MAX(CONVERT(varchar(10), data_lim, 23)) AS ultima_scadenta\nFROM dbo.accesex_facturi_clienti WITH (NOLOCK)\nWHERE ISNULL(anulare, 0) = 0\nGROUP BY LTRIM(RTRIM(den_client))\nHAVING SUM(ISNULL(sold, 0)) > 0.005",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "80A4D7C1-EB3B-56C9-B4A3-33E977E79B80",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "8B5EEBD8-BE10-5F24-8FB9-6565BEC73D76",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "7ACA3A28-8114-58CA-9A9C-1E0A42B12CE0",
"title": "Facturi neîncasate",
"urlKey": ""
}
],
"badgeKey": "sold_restant",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sold_restant",
"label": "Sold restant (facturi)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_neincasate",
"label": "Facturi neîncasate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "total_facturat",
"label": "Total facturat cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B2B6B775-0FDD-5F7B-AE11-C66A553CF668",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cif",
"label": "CIF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "sold_restant",
"label": "Sold restant (facturi)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "nr_neincasate",
"label": "Facturi neîncasate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "total_facturat",
"label": "Total facturat cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "total_incasat",
"label": "Total încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ultima_scadenta",
"label": "Ultima scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "0CB9A91A-0CAD-5B5F-893C-12BB3009BD0D",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05D85685-CC7A-58C4-A822-349CF2210FF1",
"key": "sold_restant",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "cif",
"systemImage": "person.crop.circle.badge.exclamationmark",
"title": "Clienți cu sold",
"titleKey": "client"
},
{
"actions": [
{
"id": "029ABC64-D5A7-5E2A-A9AD-3C9B613EA24E",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "757752E0-E42A-5EF7-AFBD-187D72CB53DA",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "F92268B2-ADF7-51BB-89EF-FA06BB838D37",
"title": "Linii factură",
"urlKey": ""
},
{
"id": "26DAA8E6-BDE5-5F06-97DB-9E76B65C005D",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "4173178B-07C9-5FF3-AB00-2449FB929309",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "7ACA3A28-8114-58CA-9A9C-1E0A42B12CE0",
"title": "Facturi neîncasate ale clientului",
"urlKey": ""
},
{
"id": "824DF271-EB84-5006-9F0B-63FF68163E43",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "3E41099F-7158-544D-B2FB-97C9176D36D8",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "83A902D4-03EA-52CA-B0FB-95BBC9B6DCE8",
"title": "Sold și rulaje client",
"urlKey": ""
}
],
"badgeKey": "sold",
"cardEnrichments": [
{
"fields": [
{
"childKey": "sold_client",
"id": "7B4B6576-68C5-5165-83A4-D4B50779D087",
"label": "Sold client",
"presentation": "text"
}
],
"id": "76BB41AA-1BE8-57F3-A444-2F8AE484726F",
"relationID": "3E41099F-7158-544D-B2FB-97C9176D36D8",
"title": "Situație client"
}
],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Client",
"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": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sold",
"label": "Rest pe factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stare_factura",
"label": "Stare 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": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "519E43E0-D53D-55C1-8F8C-4102156DD070",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_client",
"label": "ID client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_document",
"label": "Serie",
"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_document",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cif_client",
"label": "CIF client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori",
"detailRole": "highlight",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori",
"detailRole": "information",
"isVisible": true,
"key": "valoare_incasata",
"label": "Valoare încasată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori",
"detailRole": "highlight",
"isVisible": true,
"key": "sold",
"label": "Rest pe factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Încasare",
"detailRole": "information",
"isVisible": true,
"key": "stare_factura",
"label": "Stare factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Încasare",
"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": "Încasare",
"detailRole": "information",
"isVisible": true,
"key": "mod_plata",
"label": "Mod de plată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Responsabili",
"detailRole": "information",
"isVisible": true,
"key": "den_agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Responsabili",
"detailRole": "information",
"isVisible": true,
"key": "den_facturist",
"label": "Facturist",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Responsabili",
"detailRole": "information",
"isVisible": true,
"key": "user_creare",
"label": "Creată de",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_comanda",
"label": "Număr comandă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_awb",
"label": "AWB",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_uit",
"label": "Cod UIT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Livrare",
"detailRole": "information",
"isVisible": true,
"key": "den_adresa",
"label": "Adresă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Livrare",
"detailRole": "information",
"isVisible": true,
"key": "localitate_livrare",
"label": "Localitate livrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Livrare",
"detailRole": "information",
"isVisible": true,
"key": "judet_livrare",
"label": "Județ livrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "observatii",
"label": "Observații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "validare",
"label": "Validată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "anulare",
"label": "Anulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_cr",
"label": "Creată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_md",
"label": "Modificată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "7E224F55-A8F6-5418-A3D9-7B304317B863",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "061E50EE-00A0-5BBF-A1C5-24FDEC73DDDD",
"includeAllOption": false,
"key": "data_document",
"title": "Perioadă",
"type": "date"
},
{
"id": "35EB1D9B-BCAC-58EC-B53A-1C2AE05876F4",
"includeAllOption": true,
"key": "den_gestiune",
"title": "Gestiune",
"type": "text"
},
{
"id": "AFADBBD3-C2D6-5E70-A762-D9B3D48D979C",
"includeAllOption": true,
"key": "stare_factura",
"title": "Stare factură",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "den_client",
"systemImage": "doc.text",
"title": "Facturi clienți",
"titleKey": "numar_document"
},
{
"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": "information",
"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": "F92268B2-ADF7-51BB-89EF-FA06BB838D37",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_linie_document",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_produs",
"label": "ID produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"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": "",
"detailRole": "highlight",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_ies",
"label": "Cotă TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"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": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_aviz",
"label": "Număr aviz",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_aviz",
"label": "Data avizului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_comanda",
"label": "Număr comandă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"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": "402E79E1-08BD-5A9B-ABAB-CB4BCFD33B24",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "list.bullet.rectangle",
"title": "Linii factură client",
"titleKey": "den_produs"
},
{
"actions": [
{
"id": "029ABC64-D5A7-5E2A-A9AD-3C9B613EA24E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "FFF8FB10-1A5D-5D81-B5D8-66FAE98F9551",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "F92268B2-ADF7-51BB-89EF-FA06BB838D37",
"title": "Linii factură",
"urlKey": ""
}
],
"badgeKey": "sold",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Client",
"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": "sold",
"label": "Rest pe factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zile_fata_de_scadenta",
"label": "Zile față de scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "7ACA3A28-8114-58CA-9A9C-1E0A42B12CE0",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_client",
"label": "ID client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_document",
"label": "Serie",
"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_document",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cif_client",
"label": "CIF client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare fără TVA",
"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": "Valoare încasată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "sold",
"label": "Rest pe factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stare_factura",
"label": "Stare 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": "mod_plata",
"label": "Mod de plată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_facturist",
"label": "Facturist",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "user_creare",
"label": "Creată de",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "zile_fata_de_scadenta",
"label": "Zile față de scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "632F9C46-5A3E-50E4-A2C1-3D59DFD06C1B",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "8644B1A8-84F2-568A-A8D9-D145ADFD968D",
"key": "data_lim",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "den_client",
"systemImage": "exclamationmark.circle",
"title": "Facturi neîncasate ale clientului",
"titleKey": "numar_document"
},
{
"actions": [],
"badgeKey": "sold_client",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sold_client",
"label": "Sold client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "vanzari_an",
"label": "Vânzări în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "incasari_an",
"label": "Încasări în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "83A902D4-03EA-52CA-B0FB-95BBC9B6DCE8",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_partener",
"label": "ID client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cif",
"label": "CIF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "sold_client",
"label": "Sold client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sold_cu_efecte",
"label": "Sold cu efecte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "vanzari_an",
"label": "Vânzări în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "incasari_an",
"label": "Încasări în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "termen_mediu_incasare",
"label": "Termen mediu de încasare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "81661857-4C1C-5689-9F12-A4C3D9E8C6EC",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "",
"systemImage": "creditcard",
"title": "Sold contabil (411) și rulaje",
"titleKey": "client"
}
],
"relations": [
{
"childDatasetID": "F92268B2-ADF7-51BB-89EF-FA06BB838D37",
"childKey": "id_document",
"id": "757752E0-E42A-5EF7-AFBD-187D72CB53DA",
"name": "Linii factură",
"parentDatasetID": "519E43E0-D53D-55C1-8F8C-4102156DD070",
"parentKey": "id_document"
},
{
"childDatasetID": "7ACA3A28-8114-58CA-9A9C-1E0A42B12CE0",
"childKey": "id_client",
"id": "4173178B-07C9-5FF3-AB00-2449FB929309",
"name": "Neîncasate client",
"parentDatasetID": "519E43E0-D53D-55C1-8F8C-4102156DD070",
"parentKey": "id_client"
},
{
"childDatasetID": "F92268B2-ADF7-51BB-89EF-FA06BB838D37",
"childKey": "id_document",
"id": "FFF8FB10-1A5D-5D81-B5D8-66FAE98F9551",
"name": "Linii factură neîncasată",
"parentDatasetID": "7ACA3A28-8114-58CA-9A9C-1E0A42B12CE0",
"parentKey": "id_document"
},
{
"childDatasetID": "83A902D4-03EA-52CA-B0FB-95BBC9B6DCE8",
"childKey": "id_partener",
"id": "3E41099F-7158-544D-B2FB-97C9176D36D8",
"name": "Sold client",
"parentDatasetID": "519E43E0-D53D-55C1-8F8C-4102156DD070",
"parentKey": "id_client"
},
{
"childDatasetID": "7ACA3A28-8114-58CA-9A9C-1E0A42B12CE0",
"childKey": "den_client",
"id": "8B5EEBD8-BE10-5F24-8FB9-6565BEC73D76",
"name": "Facturile neîncasate ale clientului",
"parentDatasetID": "B2B6B775-0FDD-5F7B-AE11-C66A553CF668",
"parentKey": "client"
}
],
"widgets": [
{
"cacheMode": "cached",
"chartAggregation": "count",
"chartStyle": "line",
"chartXAxisKey": "",
"datasetID": "7ACA3A28-8114-58CA-9A9C-1E0A42B12CE0",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"filterSourceMode": "custom",
"filters": [],
"id": "46D39E24-416F-5803-8FD7-E7EA4EF0AB5A",
"kind": "count",
"limit": 10,
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"showInExternalWidgets": false,
"sortRules": [],
"subtitleKey": "",
"title": "Facturi neîncasate",
"titleKey": "",
"valueKey": ""
},
{
"cacheMode": "cached",
"chartAggregation": "count",
"chartStyle": "line",
"chartXAxisKey": "",
"datasetID": "7ACA3A28-8114-58CA-9A9C-1E0A42B12CE0",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"filterSourceMode": "custom",
"filters": [],
"id": "C5A10126-EF30-5132-8B07-BECD283F0E42",
"kind": "sum",
"limit": 10,
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"showInExternalWidgets": false,
"sortRules": [],
"subtitleKey": "",
"title": "Total rămas de încasat",
"titleKey": "",
"valueKey": "sold"
}
]
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-07-28T07:30:50Z",
"description": "Facturi clienți read-only, construite din antetul și liniile AccesEx confirmate live. Câmpul sold a fost verificat pe toate rândurile active din instalarea de test și corespunde diferenței dintre valoarea cu TVA și valoarea încasată.\n\nVarianta Free oferă două intrări clare: facturile filtrate obligatoriu pe o perioadă și lista facturilor cu rest de încasat; ambele pot deschide liniile documentului. Varianta Pro păstrează un singur ecran principal mai bogat și adaugă în detaliul facturii sub-butoanele „Facturi neîncasate ale clientului” și „Sold și rulaje client”, plus două indicatoare compacte pe Home. Gestiunea și starea rămân filtre utile, dar perioada împiedică încărcarea accidentală a unui istoric foarte mare.\n\nConfigurare:\n1. Creează un login SQL read-only cu SELECT numai pe obiectele cerute.\n2. Adaugă sursa SQL Server în Cifru, activează TLS și testează structura.\n3. Importă pachetul, mapează slotul și rulează testul local.\n\nSoldul Pro pe client provine din funcția read-only urmarire_parteneri, aceeași familie de date folosită de MAXapp pentru modalul de sold. Lista neîncasatelor folosește sold > 0 și exclude documentele anulate. Pachet neoficial, fără afiliere NexusERP.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0",
"minimumPlan": "pro",
"packageID": "1EDE248F-90D0-5309-94B8-70D50B40497A",
"rootButtonCount": 2,
"summary": "Facturi și linii, sold client și neîncasate accesibile direct din detaliu.",
"tags": [
"NexusERP",
"facturi clienți",
"neîncasate",
"sold",
"read-only"
],
"title": "Facturi clienți — Pro"
}
}