NIR — Pro
Recepții cu linii, trasabilitate, factura furnizorului și sumar lunar.
Note de intrare-recepție read-only, cu antet și linii separate și legate prin id_document. Cheile au fost verificate live: antetele și liniile au identificatori unici, iar toate liniile testate au antet corespondent.
Varianta Free conține datele necesare recepției: număr, dată, furnizor, gestiune, valoare și produse. Varianta Pro organizează suplimentar factura furnizorului, trasabilitatea, conturile și adaugă două indicatoare exacte pentru luna curentă. Nu presupune că NIR și factura sunt același document și nu construiește join după numărul liber al facturii.
Configurare:
1. Creează un login SQL read-only cu SELECT pe cele două obiecte AccesEx.
2. Adaugă sursa SQL Server în Cifru cu TLS și testează structura.
3. Importă pachetul, mapează slotul și rulează testul local.
Pachet neoficial, fără afiliere NexusERP.
What this package creates
1 Home1 Details3 lists1 sources to map
- Home: Note de intrare-recepție
- Details: Linii NIR
- Sub-button: Linii recepție
- Sub-button: Sumar NIR
Sources are mapped locally and verified before applying.
Custom queriesPRO1 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT
CAST('luna_curenta' AS varchar(30)) AS row_id,
COUNT_BIG(*) AS nr_nir,
COUNT(DISTINCT id_furnizor) AS nr_furnizori,
COUNT(DISTINCT id_gestiune) AS nr_gestiuni,
CAST(SUM(ISNULL(valoare, 0)) AS decimal(19, 2)) AS valoare_receptionata
FROM dbo.accesex_note_de_intrare_receptie WITH (NOLOCK)
WHERE data_document >= DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1)
AND data_document < DATEADD(month, 1, DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1))
AND ISNULL(anulare, 0) = 0static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server (AccesEx)",
"id": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_note_de_intrare_receptie",
"dbo.accesex_note_de_intrare_receptie_lin"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"id": "53031BAF-CFAD-5398-BCD1-A90B0FC51FE5",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_furnizor",
"label": "ID furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_furnizor",
"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 NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "data_document",
"label": "Data NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "supplier_name",
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cif_furnizor",
"label": "CIF furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cif_furnizor",
"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 recepție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "numar_factura",
"label": "Număr factură furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_factura",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_factura",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nir_amanunt",
"label": "NIR cu amănunt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nir_amanunt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_clasificare",
"label": "Clasificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_clasificare",
"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": "Note de intrare-recepție",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_document",
"id_furnizor",
"serie_document",
"numar_document",
"data_document"
],
"sourceID": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"sqlQuery": "",
"tableName": "dbo.accesex_note_de_intrare_receptie"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [],
"id": "21C6C760-01AA-593A-BB27-1BD71BED12CC",
"mappings": [
{
"commonFieldKey": "",
"key": "id_intern",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_intern",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID NIR",
"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",
"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": "",
"key": "serie_produs",
"label": "Serie produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_produs",
"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": "cantitate_2",
"label": "Cantitate secundară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate_2",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pret_achizitie",
"label": "Preț achiziție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_achizitie",
"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": false
},
{
"commonFieldKey": "",
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cota_tva_int",
"label": "Cotă TVA intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cota_tva_int",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cota_tva_ies",
"label": "Cotă TVA ieșire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cota_tva_ies",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cont_produs",
"label": "Cont produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cont_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_intrare",
"label": "Data intrării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_intrare",
"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
},
{
"commonFieldKey": "",
"key": "procent_rabat",
"label": "Rabat (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "procent_rabat",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Linii NIR",
"primaryKey": "id_intern",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_intern",
"id_document",
"id_produs",
"cod_produs",
"den_produs"
],
"sourceID": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"sqlQuery": "",
"tableName": "dbo.accesex_note_de_intrare_receptie_lin"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [],
"id": "02C27544-F7D7-5D29-9D89-74979667D8C1",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_nir",
"label": "NIR în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_nir",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_furnizori",
"label": "Furnizori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_furnizori",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_gestiuni",
"label": "Gestiuni",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_gestiuni",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "valoare_receptionata",
"label": "Valoare recepționată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_receptionata",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1,
"name": "Sumar NIR",
"primaryKey": "row_id",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"row_id",
"nr_nir",
"nr_furnizori",
"nr_gestiuni",
"valoare_receptionata"
],
"sourceID": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"sqlQuery": "SELECT\n CAST('luna_curenta' AS varchar(30)) AS row_id,\n COUNT_BIG(*) AS nr_nir,\n COUNT(DISTINCT id_furnizor) AS nr_furnizori,\n COUNT(DISTINCT id_gestiune) AS nr_gestiuni,\n CAST(SUM(ISNULL(valoare, 0)) AS decimal(19, 2)) AS valoare_receptionata\nFROM dbo.accesex_note_de_intrare_receptie WITH (NOLOCK)\nWHERE data_document >= DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1)\n AND data_document < DATEADD(month, 1, DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1))\n AND ISNULL(anulare, 0) = 0",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "4E8CA39E-A759-5017-8DD3-21E61399B689",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "07503C26-3FAA-5868-A89D-25C7B093344B",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "21C6C760-01AA-593A-BB27-1BD71BED12CC",
"title": "Linii recepție",
"urlKey": ""
}
],
"badgeKey": "valoare",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data NIR",
"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 recepție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_factura",
"label": "Număr factură furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_factura",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "53031BAF-CFAD-5398-BCD1-A90B0FC51FE5",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_furnizor",
"label": "ID furnizor",
"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 NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cif_furnizor",
"label": "CIF furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "valoare",
"label": "Valoare recepție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Factura furnizorului",
"detailRole": "highlight",
"isVisible": true,
"key": "numar_factura",
"label": "Număr factură furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Factura furnizorului",
"detailRole": "information",
"isVisible": true,
"key": "data_factura",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nir_amanunt",
"label": "NIR cu amănunt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_clasificare",
"label": "Clasificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "observatii",
"label": "Observații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Control document",
"detailRole": "information",
"isVisible": true,
"key": "validare",
"label": "Validată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Control document",
"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": "9905A91D-169B-5E47-BC15-6FD46A435F92",
"openFilters": [
{
"id": "35EB1D9B-BCAC-58EC-B53A-1C2AE05876F4",
"includeAllOption": true,
"key": "den_gestiune",
"title": "Gestiune",
"type": "text"
},
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "723E8DB4-9D57-5F9E-A5AC-8C76D8CF30AE",
"includeAllOption": false,
"key": "data_document",
"title": "Perioadă",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "den_furnizor",
"systemImage": "shippingbox",
"title": "Note de intrare-recepție",
"titleKey": "numar_document"
},
{
"actions": [],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "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": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție",
"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 produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "21C6C760-01AA-593A-BB27-1BD71BED12CC",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_intern",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID NIR",
"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",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "denumire_sup",
"label": "Denumire suplimentară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Trasabilitate",
"detailRole": "information",
"isVisible": true,
"key": "serie_produs",
"label": "Serie produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantități și prețuri",
"detailRole": "highlight",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantități și prețuri",
"detailRole": "information",
"isVisible": true,
"key": "cantitate_2",
"label": "Cantitate secundară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantități și prețuri",
"detailRole": "highlight",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantități și prețuri",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț vânzare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantități și prețuri",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_int",
"label": "Cotă TVA intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_ies",
"label": "Cotă TVA ieșire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cont_produs",
"label": "Cont produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Trasabilitate",
"detailRole": "information",
"isVisible": true,
"key": "data_intrare",
"label": "Data intrării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Trasabilitate",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Data expirării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "procent_rabat",
"label": "Rabat (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "D92C86DB-0C1B-52BE-A440-C123C12B1D41",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "list.bullet.rectangle",
"title": "Linii recepție",
"titleKey": "den_produs"
},
{
"actions": [],
"badgeKey": "valoare_receptionata",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_nir",
"label": "NIR în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_furnizori",
"label": "Furnizori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_receptionata",
"label": "Valoare recepționată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "02C27544-F7D7-5D29-9D89-74979667D8C1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "row_id",
"label": "Perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_nir",
"label": "NIR în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_furnizori",
"label": "Furnizori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_gestiuni",
"label": "Gestiuni",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "valoare_receptionata",
"label": "Valoare recepționată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "B70EB616-F728-50F4-94B4-391F14A6D087",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "",
"systemImage": "chart.bar",
"title": "Sumar NIR",
"titleKey": "row_id"
}
],
"relations": [
{
"childDatasetID": "21C6C760-01AA-593A-BB27-1BD71BED12CC",
"childKey": "id_document",
"id": "07503C26-3FAA-5868-A89D-25C7B093344B",
"name": "Linii NIR",
"parentDatasetID": "53031BAF-CFAD-5398-BCD1-A90B0FC51FE5",
"parentKey": "id_document"
}
],
"widgets": [
{
"cacheMode": "cached",
"chartAggregation": "count",
"chartStyle": "line",
"chartXAxisKey": "",
"datasetID": "02C27544-F7D7-5D29-9D89-74979667D8C1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"filterSourceMode": "custom",
"filters": [],
"id": "910E10C9-268A-51A5-9DFB-A4C02B1D2C1A",
"kind": "currentValue",
"limit": 10,
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"showInExternalWidgets": false,
"sortRules": [],
"subtitleKey": "",
"title": "NIR luna curentă",
"titleKey": "",
"valueKey": "nr_nir"
},
{
"cacheMode": "cached",
"chartAggregation": "count",
"chartStyle": "line",
"chartXAxisKey": "",
"datasetID": "02C27544-F7D7-5D29-9D89-74979667D8C1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"filterSourceMode": "custom",
"filters": [],
"id": "1729C3F6-9B69-58EC-A477-81A58DD254A7",
"kind": "currentValue",
"limit": 10,
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"showInExternalWidgets": false,
"sortRules": [],
"subtitleKey": "",
"title": "Valoare recepționată luna curentă",
"titleKey": "",
"valueKey": "valoare_receptionata"
}
]
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-07-28T06:20:15Z",
"description": "Note de intrare-recepție read-only, cu antet și linii separate și legate prin id_document. Cheile au fost verificate live: antetele și liniile au identificatori unici, iar toate liniile testate au antet corespondent.\n\nVarianta Free conține datele necesare recepției: număr, dată, furnizor, gestiune, valoare și produse. Varianta Pro organizează suplimentar factura furnizorului, trasabilitatea, conturile și adaugă două indicatoare exacte pentru luna curentă. Nu presupune că NIR și factura sunt același document și nu construiește join după numărul liber al facturii.\n\nConfigurare:\n1. Creează un login SQL read-only cu SELECT pe cele două obiecte AccesEx.\n2. Adaugă sursa SQL Server în Cifru cu TLS și testează structura.\n3. Importă pachetul, mapează slotul și rulează testul local.\n\nPachet neoficial, fără afiliere NexusERP.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0",
"minimumPlan": "pro",
"packageID": "BB3E3BA1-167C-5AF3-97E4-5BD34D3017D3",
"rootButtonCount": 1,
"summary": "Recepții cu linii, trasabilitate, factura furnizorului și sumar lunar.",
"tags": [
"NexusERP",
"NIR",
"recepții",
"stoc",
"read-only"
],
"title": "NIR — Pro"
}
}