NexusERP

Inventare închise și diferențe — Pro

Inventar închis → produse: scriptic / inventariat / diferențe → PV plus/minus și linii cu loturi.

Inventare închise, validate și neanulate → situația produselor cu scriptic, inventariat și diferență → procese verbale plus/minus → liniile PV. Alege luna din lunile existente în documente și gestiunea. Sunt accesibile inclusiv inventarele anilor anteriori, nu doar ultimele 90 zile. Un inventar parțial nu reprezintă întreaga gestiune. Situația folosește funcția nativă inventar_situatie numai pentru inventarul selectat, fără evaluarea tuturor inventarelor la deschidere. Cantitățile și valorile sunt cele calculate de Nexus, nu suma improvizată a colectărilor brute. Nu folosește stocul de azi drept scriptic istoric. Gruparea situației este pe produs, nu pe lot; loturile apar unde sunt înregistrate efectiv în liniile PV. Procesele verbale sunt legate prin referințele lor native. Liniile păstrează semnul, prețul, valoarea, lotul, expirarea, proveniența și conturile. Baza fiscală a antetului PV nu este prezentată drept valoarea semnată a diferențelor. Nu aduna cantități din unități diferite. Nu inventariază, nu ajustează și nu scrie în Nexus. Pro, live, maximum 10.000 inventare și 50.000 produse per sub-listă. La un inventar mai mare decât limita, lista afișată nu trebuie considerată completă; restrânge configurația sau consultă ERP. Capturi DEMO. Manuale: https://www.docs.nexuserp.ro/articol/detalii/4091 ; https://www.docs.nexuserp.ro/articol/inventarierea-stocurilor-gestionate-pe-loturi-prin-intermediul-nexus-transferuri-online/5388 .

What this package creates

1 Home3 Details4 lists1 sources to map
  • Home: Inventare închise
  • Details: Situația produselor
  • Details: Procesele verbale de diferențe
  • Details: Produsele procesului verbal
  • Sub-button: Situația produselor inventariate
  • Sub-button: Procese verbale plus și minus
  • Sub-button: Produsele procesului verbal

Sources are mapped locally and verified before applying.

Custom queriesPRO4 SQL

Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.

Statically verified read-only$.components.workspaceSelection.datasets.0.sqlQuery
SELECT CONCAT(h.anluna,'|',h.pct_lcr,':',h.id) AS row_id,
 h.anluna AS inventory_month,h.pct_lcr AS inventory_pl,h.id AS inventory_id,h.nr_doc,h.data_doc,h.nume_gest,h.nume_clasa,
 CASE WHEN h.partial=1 THEN N'Parțial' ELSE N'Complet' END AS tip_inventar,h.nr_pv_minus,h.nr_pv_plus,
 CONVERT(char(7),h.data_doc,126) AS luna_inventar
FROM dbo.inventar_view h WHERE h.valid=1 AND h.anulat=0 AND h.deschis=0

static read-only checks passed

Statically verified read-only$.components.workspaceSelection.datasets.1.sqlQuery
SELECT CONCAT(CONCAT(:inventory_month,'|',:inventory_pl,':',:inventory_id),'|',x.pl_pr,':',x.id_pr,':',x.cod_pr) AS row_id,
 CONCAT(:inventory_month,'|',:inventory_pl,':',:inventory_id) AS inventory_key,x.cod_ext,x.denpr,x.cant_inv,x.cant_stoc,x.cant_dif,x.val_inv,x.val_stoc,x.val_dif,x.cont,x.nume_cont,
 N'Cantități și valori calculate de situația nativă Nexus pentru inventarul închis. Nu reprezintă stocul curent.' AS explicatie
FROM dbo.inventar_situatie(:inventory_month,:inventory_pl,:inventory_id,0) x

static read-only checks passed

Statically verified read-only$.components.workspaceSelection.datasets.2.sqlQuery
SELECT CONCAT(v.anluna,'|',v.pct_lcr,':',v.id) AS row_id,
 CONCAT(:inventory_month,'|',:inventory_pl,':',:inventory_id) AS inventory_key,v.anluna AS pv_month,v.pct_lcr AS pv_pl,v.id AS pv_id,v.nr_doc,v.data_doc,v.tip_doc,v.nume_gest,v.observatii,
 v.valid,v.anulat
FROM dbo.inventar h JOIN dbo.pvdiferenteinventar_view v ON v.anluna=h.anluna
 AND ((v.pct_lcr=h.pl_pvdi_minus AND v.id=h.id_pvdi_minus) OR (v.pct_lcr=h.pl_pvdi_plus AND v.id=h.id_pvdi_plus))
WHERE h.anluna=:inventory_month AND h.pct_lcr=:inventory_pl AND h.id=:inventory_id

static read-only checks passed

Statically verified read-only$.components.workspaceSelection.datasets.3.sqlQuery
SELECT CONCAT(l.anluna,'|',l.pct_lcr,':',l.id) AS row_id,
 CONCAT(:pv_month,'|',:pv_pl,':',:pv_id) AS pv_key,l.cod_ext,l.denpr,l.um,l.cantitate,l.pu,l.valoare,l.nr_lot,l.data_in,l.data_exp,l.nume_in,l.ctg_db,l.ctg_cr,l.nume_clasa,l.den_sup
FROM dbo.linpvdiferenteinventar_view l WHERE l.anluna=:pv_month AND l.pl_pvd=:pv_pl AND l.id_pvd=:pv_id

static read-only checks passed

View the JSON being importedcollapsed by default

The exact portable content of this version.

{
    "components": {
        "sourceSlots": [
            {
                "displayName": "NexusERP SQL Server",
                "id": "84DC8E7C-B2FF-5B85-A500-6B3DDE1B06DD",
                "kind": "sqlServer",
                "requiredObjects": [
                    "dbo.inventar",
                    "dbo.inventar_view",
                    "dbo.inventar_situatie",
                    "dbo.pvdiferenteinventar_view",
                    "dbo.linpvdiferenteinventar_view"
                ],
                "requiresCustomSQL": true
            }
        ],
        "workspaceSelection": {
            "commonFields": [],
            "datasets": [
                {
                    "cacheMode": "live",
                    "calculatedFields": [],
                    "customQueryIntegrationName": "NexusERP",
                    "endpointPath": "",
                    "fetchSortRules": [
                        {
                            "direction": "descending",
                            "id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
                            "key": "data_doc",
                            "type": "date"
                        },
                        {
                            "direction": "ascending",
                            "id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
                            "key": "row_id",
                            "type": "text"
                        }
                    ],
                    "id": "D19FD481-AFB7-5197-9DD5-65664A6208E1",
                    "mappings": [
                        {
                            "commonFieldKey": "",
                            "key": "row_id",
                            "label": "row_id",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "row_id",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "inventory_month",
                            "label": "inventory_month",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "inventory_month",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "inventory_pl",
                            "label": "inventory_pl",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "inventory_pl",
                            "type": "number",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "inventory_id",
                            "label": "inventory_id",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "inventory_id",
                            "type": "number",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nr_doc",
                            "label": "Inventar nr.",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "nr_doc",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "data_doc",
                            "label": "Data inventarului",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "data_doc",
                            "type": "date",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nume_gest",
                            "label": "Gestiune",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "nume_gest",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nume_clasa",
                            "label": "Clasă",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "nume_clasa",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "tip_inventar",
                            "label": "Acoperire",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "tip_inventar",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nr_pv_minus",
                            "label": "PV minus",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "nr_pv_minus",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nr_pv_plus",
                            "label": "PV plus",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "nr_pv_plus",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "luna_inventar",
                            "label": "Luna inventarului",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "luna_inventar",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        }
                    ],
                    "maxRows": 10000,
                    "name": "Inventare închise",
                    "primaryKey": "row_id",
                    "queryParameters": [],
                    "refreshPolicy": {
                        "enabled": false,
                        "intervalMinutes": 60
                    },
                    "rootArrayPath": "",
                    "rowLimitEnabled": true,
                    "searchKeys": [
                        "nr_doc",
                        "data_doc",
                        "nume_gest",
                        "nume_clasa",
                        "tip_inventar",
                        "nr_pv_minus",
                        "nr_pv_plus",
                        "luna_inventar"
                    ],
                    "sourceID": "84DC8E7C-B2FF-5B85-A500-6B3DDE1B06DD",
                    "sqlQuery": "SELECT CONCAT(h.anluna,'|',h.pct_lcr,':',h.id) AS row_id,\n h.anluna AS inventory_month,h.pct_lcr AS inventory_pl,h.id AS inventory_id,h.nr_doc,h.data_doc,h.nume_gest,h.nume_clasa,\n CASE WHEN h.partial=1 THEN N'Parțial' ELSE N'Complet' END AS tip_inventar,h.nr_pv_minus,h.nr_pv_plus,\n CONVERT(char(7),h.data_doc,126) AS luna_inventar\nFROM dbo.inventar_view h WHERE h.valid=1 AND h.anulat=0 AND h.deschis=0",
                    "tableName": ""
                },
                {
                    "cacheMode": "live",
                    "calculatedFields": [],
                    "customQueryIntegrationName": "NexusERP",
                    "endpointPath": "",
                    "fetchSortRules": [
                        {
                            "direction": "ascending",
                            "id": "FA54A7D7-A679-5E08-8908-E8B4A4A893DC",
                            "key": "denpr",
                            "type": "text"
                        },
                        {
                            "direction": "ascending",
                            "id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
                            "key": "row_id",
                            "type": "text"
                        }
                    ],
                    "id": "776B3984-CE7A-5656-A570-E0E510D49290",
                    "mappings": [
                        {
                            "commonFieldKey": "",
                            "key": "row_id",
                            "label": "row_id",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "row_id",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "inventory_key",
                            "label": "inventory_key",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "inventory_key",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cod_ext",
                            "label": "Cod produs",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "cod_ext",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "denpr",
                            "label": "Produs",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "denpr",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cant_inv",
                            "label": "Cantitate inventariată — situație Nexus",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "cant_inv",
                            "type": "number",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cant_stoc",
                            "label": "Cantitate scriptică",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "cant_stoc",
                            "type": "number",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cant_dif",
                            "label": "Diferență cantitativă",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "cant_dif",
                            "type": "number",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "val_inv",
                            "label": "Valoare inventariată",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "val_inv",
                            "type": "number",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "val_stoc",
                            "label": "Valoare scriptică",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "val_stoc",
                            "type": "number",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "val_dif",
                            "label": "Diferență valorică",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "val_dif",
                            "type": "number",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cont",
                            "label": "Cont",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "cont",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nume_cont",
                            "label": "Denumire cont",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "nume_cont",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "explicatie",
                            "label": "Acoperire",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "explicatie",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        }
                    ],
                    "maxRows": 50000,
                    "name": "Situația produselor inventariate",
                    "primaryKey": "row_id",
                    "queryParameters": [
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "inventory_month",
                            "id": "D0A0B8FE-6D34-5C59-9923-ABC1D6EE16A0",
                            "name": "inventory_month",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "inventory_pl",
                            "id": "61DC713A-013E-5623-AC24-4B560241C73D",
                            "name": "inventory_pl",
                            "source": "parentField",
                            "type": "number"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "inventory_id",
                            "id": "06ACDF22-81D9-5AD1-9DA4-942B0D8EA600",
                            "name": "inventory_id",
                            "source": "parentField",
                            "type": "number"
                        }
                    ],
                    "refreshPolicy": {
                        "enabled": false,
                        "intervalMinutes": 60
                    },
                    "rootArrayPath": "",
                    "rowLimitEnabled": true,
                    "searchKeys": [
                        "cod_ext",
                        "denpr",
                        "cant_inv",
                        "cant_stoc",
                        "cant_dif",
                        "val_inv",
                        "val_stoc",
                        "val_dif",
                        "cont",
                        "nume_cont",
                        "explicatie"
                    ],
                    "sourceID": "84DC8E7C-B2FF-5B85-A500-6B3DDE1B06DD",
                    "sqlQuery": "SELECT CONCAT(CONCAT(:inventory_month,'|',:inventory_pl,':',:inventory_id),'|',x.pl_pr,':',x.id_pr,':',x.cod_pr) AS row_id,\n CONCAT(:inventory_month,'|',:inventory_pl,':',:inventory_id) AS inventory_key,x.cod_ext,x.denpr,x.cant_inv,x.cant_stoc,x.cant_dif,x.val_inv,x.val_stoc,x.val_dif,x.cont,x.nume_cont,\n N'Cantități și valori calculate de situația nativă Nexus pentru inventarul închis. Nu reprezintă stocul curent.' AS explicatie\nFROM dbo.inventar_situatie(:inventory_month,:inventory_pl,:inventory_id,0) x",
                    "tableName": ""
                },
                {
                    "cacheMode": "live",
                    "calculatedFields": [],
                    "customQueryIntegrationName": "NexusERP",
                    "endpointPath": "",
                    "fetchSortRules": [
                        {
                            "direction": "ascending",
                            "id": "E5C16027-FE07-56C5-A63D-49B1F3EA23E7",
                            "key": "tip_doc",
                            "type": "text"
                        },
                        {
                            "direction": "ascending",
                            "id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
                            "key": "row_id",
                            "type": "text"
                        }
                    ],
                    "id": "8AC5EC17-1C09-598A-B7AB-18BF1D2A1515",
                    "mappings": [
                        {
                            "commonFieldKey": "",
                            "key": "row_id",
                            "label": "row_id",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "row_id",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "inventory_key",
                            "label": "inventory_key",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "inventory_key",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "pv_month",
                            "label": "pv_month",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "pv_month",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "pv_pl",
                            "label": "pv_pl",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "pv_pl",
                            "type": "number",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "pv_id",
                            "label": "pv_id",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "pv_id",
                            "type": "number",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nr_doc",
                            "label": "Proces verbal nr.",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "nr_doc",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "data_doc",
                            "label": "Data",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "data_doc",
                            "type": "date",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "tip_doc",
                            "label": "Tip document",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "tip_doc",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nume_gest",
                            "label": "Gestiune",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "nume_gest",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "observatii",
                            "label": "Observații",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "observatii",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "valid",
                            "label": "Validat",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "valid",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "anulat",
                            "label": "Anulat",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "anulat",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        }
                    ],
                    "maxRows": 5000,
                    "name": "Procese verbale plus și minus",
                    "primaryKey": "row_id",
                    "queryParameters": [
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "inventory_month",
                            "id": "D0A0B8FE-6D34-5C59-9923-ABC1D6EE16A0",
                            "name": "inventory_month",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "inventory_pl",
                            "id": "61DC713A-013E-5623-AC24-4B560241C73D",
                            "name": "inventory_pl",
                            "source": "parentField",
                            "type": "number"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "inventory_id",
                            "id": "06ACDF22-81D9-5AD1-9DA4-942B0D8EA600",
                            "name": "inventory_id",
                            "source": "parentField",
                            "type": "number"
                        }
                    ],
                    "refreshPolicy": {
                        "enabled": false,
                        "intervalMinutes": 60
                    },
                    "rootArrayPath": "",
                    "rowLimitEnabled": true,
                    "searchKeys": [
                        "nr_doc",
                        "data_doc",
                        "tip_doc",
                        "nume_gest",
                        "observatii",
                        "valid",
                        "anulat"
                    ],
                    "sourceID": "84DC8E7C-B2FF-5B85-A500-6B3DDE1B06DD",
                    "sqlQuery": "SELECT CONCAT(v.anluna,'|',v.pct_lcr,':',v.id) AS row_id,\n CONCAT(:inventory_month,'|',:inventory_pl,':',:inventory_id) AS inventory_key,v.anluna AS pv_month,v.pct_lcr AS pv_pl,v.id AS pv_id,v.nr_doc,v.data_doc,v.tip_doc,v.nume_gest,v.observatii,\n v.valid,v.anulat\nFROM dbo.inventar h JOIN dbo.pvdiferenteinventar_view v ON v.anluna=h.anluna\n AND ((v.pct_lcr=h.pl_pvdi_minus AND v.id=h.id_pvdi_minus) OR (v.pct_lcr=h.pl_pvdi_plus AND v.id=h.id_pvdi_plus))\nWHERE h.anluna=:inventory_month AND h.pct_lcr=:inventory_pl AND h.id=:inventory_id",
                    "tableName": ""
                },
                {
                    "cacheMode": "live",
                    "calculatedFields": [],
                    "customQueryIntegrationName": "NexusERP",
                    "endpointPath": "",
                    "fetchSortRules": [
                        {
                            "direction": "ascending",
                            "id": "FA54A7D7-A679-5E08-8908-E8B4A4A893DC",
                            "key": "denpr",
                            "type": "text"
                        },
                        {
                            "direction": "ascending",
                            "id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
                            "key": "row_id",
                            "type": "text"
                        }
                    ],
                    "id": "B53005A4-E743-5766-9586-29DB8C81C585",
                    "mappings": [
                        {
                            "commonFieldKey": "",
                            "key": "row_id",
                            "label": "row_id",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "row_id",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "pv_key",
                            "label": "pv_key",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "pv_key",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cod_ext",
                            "label": "Cod produs",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "cod_ext",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "denpr",
                            "label": "Produs",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "denpr",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "um",
                            "label": "UM",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "um",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cantitate",
                            "label": "Cantitate semnată",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "cantitate",
                            "type": "number",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "pu",
                            "label": "Preț înregistrat",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "pu",
                            "type": "number",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "valoare",
                            "label": "Valoare semnată",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "valoare",
                            "type": "number",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nr_lot",
                            "label": "Lot",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "nr_lot",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "data_in",
                            "label": "Data intrării",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "data_in",
                            "type": "date",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "data_exp",
                            "label": "Expirare",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "data_exp",
                            "type": "date",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nume_in",
                            "label": "Proveniență",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "nume_in",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ctg_db",
                            "label": "Cont debit",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "ctg_db",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ctg_cr",
                            "label": "Cont credit",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "ctg_cr",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nume_clasa",
                            "label": "Clasă",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "nume_clasa",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "den_sup",
                            "label": "Denumire suplimentară",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "den_sup",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        }
                    ],
                    "maxRows": 50000,
                    "name": "Produsele procesului verbal",
                    "primaryKey": "row_id",
                    "queryParameters": [
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "pv_month",
                            "id": "AD7D7C02-EDA6-5559-B49C-D5BB7DB068A3",
                            "name": "pv_month",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "pv_pl",
                            "id": "D55A6071-0704-569A-BE24-BBB9FE1548B8",
                            "name": "pv_pl",
                            "source": "parentField",
                            "type": "number"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "pv_id",
                            "id": "AC7D4393-F9E8-59B3-8AF0-2D63727F2842",
                            "name": "pv_id",
                            "source": "parentField",
                            "type": "number"
                        }
                    ],
                    "refreshPolicy": {
                        "enabled": false,
                        "intervalMinutes": 60
                    },
                    "rootArrayPath": "",
                    "rowLimitEnabled": true,
                    "searchKeys": [
                        "cod_ext",
                        "denpr",
                        "um",
                        "cantitate",
                        "pu",
                        "valoare",
                        "nr_lot",
                        "data_in",
                        "data_exp",
                        "nume_in",
                        "ctg_db",
                        "ctg_cr",
                        "nume_clasa",
                        "den_sup"
                    ],
                    "sourceID": "84DC8E7C-B2FF-5B85-A500-6B3DDE1B06DD",
                    "sqlQuery": "SELECT CONCAT(l.anluna,'|',l.pct_lcr,':',l.id) AS row_id,\n CONCAT(:pv_month,'|',:pv_pl,':',:pv_id) AS pv_key,l.cod_ext,l.denpr,l.um,l.cantitate,l.pu,l.valoare,l.nr_lot,l.data_in,l.data_exp,l.nume_in,l.ctg_db,l.ctg_cr,l.nume_clasa,l.den_sup\nFROM dbo.linpvdiferenteinventar_view l WHERE l.anluna=:pv_month AND l.pl_pvd=:pv_pl AND l.id_pvd=:pv_id",
                    "tableName": ""
                }
            ],
            "pages": [
                {
                    "actions": [
                        {
                            "id": "D91FCB21-6A4D-5BB8-982B-6D63530FAE80",
                            "kind": "showRelated",
                            "relatedInitiallyExpanded": false,
                            "relatedPresentation": "separate",
                            "relatedPreviewLimit": 12,
                            "relatedRowStyle": "cards",
                            "relatedShowsCount": true,
                            "relationID": "71DEEFD4-CD16-54A2-BE34-B7E7FA88DB15",
                            "systemImage": "list.bullet.rectangle",
                            "targetDatasetID": "776B3984-CE7A-5656-A570-E0E510D49290",
                            "title": "Situația produselor",
                            "urlKey": ""
                        },
                        {
                            "id": "B30C5472-42AD-563A-A657-D56F5D5B713A",
                            "kind": "showRelated",
                            "relatedInitiallyExpanded": false,
                            "relatedPresentation": "separate",
                            "relatedPreviewLimit": 12,
                            "relatedRowStyle": "cards",
                            "relatedShowsCount": true,
                            "relationID": "5E223EEA-8855-5F6B-A251-B9E3C63E70D2",
                            "systemImage": "list.bullet.rectangle",
                            "targetDatasetID": "8AC5EC17-1C09-598A-B7AB-18BF1D2A1515",
                            "title": "Procesele verbale de diferențe",
                            "urlKey": ""
                        }
                    ],
                    "badgeKey": "",
                    "cardEnrichments": [],
                    "cardFieldLayout": [
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "data_doc",
                            "label": "Data inventarului",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "tip_inventar",
                            "label": "Acoperire",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "luna_inventar",
                            "label": "Luna inventarului",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        }
                    ],
                    "datasetID": "D19FD481-AFB7-5197-9DD5-65664A6208E1",
                    "dateFilterKey": "",
                    "dateFilterLastDays": 7,
                    "dateFilterPreset": "none",
                    "detailFieldLayout": [
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "data_doc",
                            "label": "Data inventarului",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nume_clasa",
                            "label": "Clasă",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "tip_inventar",
                            "label": "Acoperire",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nr_pv_minus",
                            "label": "PV minus",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nr_pv_plus",
                            "label": "PV plus",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "luna_inventar",
                            "label": "Luna inventarului",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        }
                    ],
                    "detailLiveRefreshSeconds": 0,
                    "fixedFilters": [],
                    "id": "9BE2E3DE-B49F-58FD-A789-D8219960D077",
                    "openFilters": [
                        {
                            "id": "8F080CD6-0D2A-58FE-B906-30EB96F7920C",
                            "includeAllOption": true,
                            "key": "luna_inventar",
                            "title": "Luna inventarului",
                            "type": "text"
                        },
                        {
                            "id": "A32D8B92-017B-50F7-B4C9-3673109FCF8D",
                            "includeAllOption": true,
                            "key": "nume_gest",
                            "title": "Gestiune",
                            "type": "text"
                        }
                    ],
                    "pageSize": 100,
                    "requiresOpeningFilterSelection": true,
                    "showOnHome": true,
                    "sortRules": [
                        {
                            "direction": "descending",
                            "id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
                            "key": "data_doc",
                            "type": "date"
                        },
                        {
                            "direction": "ascending",
                            "id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
                            "key": "row_id",
                            "type": "text"
                        }
                    ],
                    "subtitle": "",
                    "subtitleKey": "nr_doc",
                    "systemImage": "person.2",
                    "title": "Inventare închise",
                    "titleKey": "nume_gest"
                },
                {
                    "actions": [],
                    "badgeKey": "cant_dif",
                    "cardEnrichments": [],
                    "cardFieldLayout": [
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cant_inv",
                            "label": "Cantitate inventariată — situație Nexus",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cant_stoc",
                            "label": "Cantitate scriptică",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "val_dif",
                            "label": "Diferență valorică",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        }
                    ],
                    "datasetID": "776B3984-CE7A-5656-A570-E0E510D49290",
                    "dateFilterKey": "",
                    "dateFilterLastDays": 7,
                    "dateFilterPreset": "none",
                    "detailFieldLayout": [
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cant_inv",
                            "label": "Cantitate inventariată — situație Nexus",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cant_stoc",
                            "label": "Cantitate scriptică",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "val_inv",
                            "label": "Valoare inventariată",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "val_stoc",
                            "label": "Valoare scriptică",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "val_dif",
                            "label": "Diferență valorică",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cont",
                            "label": "Cont",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nume_cont",
                            "label": "Denumire cont",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "explicatie",
                            "label": "Acoperire",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        }
                    ],
                    "detailLiveRefreshSeconds": 0,
                    "fixedFilters": [],
                    "id": "0280ABE9-F62B-576F-90B7-7347E46EE0FE",
                    "openFilters": [],
                    "pageSize": 100,
                    "requiresOpeningFilterSelection": false,
                    "showOnHome": false,
                    "sortRules": [
                        {
                            "direction": "ascending",
                            "id": "FA54A7D7-A679-5E08-8908-E8B4A4A893DC",
                            "key": "denpr",
                            "type": "text"
                        },
                        {
                            "direction": "ascending",
                            "id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
                            "key": "row_id",
                            "type": "text"
                        }
                    ],
                    "subtitle": "",
                    "subtitleKey": "cod_ext",
                    "systemImage": "doc.text",
                    "title": "Situația produselor inventariate",
                    "titleKey": "denpr"
                },
                {
                    "actions": [
                        {
                            "id": "9130BF65-8835-5745-82F5-8F2C3A4F6329",
                            "kind": "showRelated",
                            "relatedInitiallyExpanded": false,
                            "relatedPresentation": "separate",
                            "relatedPreviewLimit": 12,
                            "relatedRowStyle": "cards",
                            "relatedShowsCount": true,
                            "relationID": "A4CFD19E-F95E-583A-B826-FD2718C3B1DB",
                            "systemImage": "list.bullet.rectangle",
                            "targetDatasetID": "B53005A4-E743-5766-9586-29DB8C81C585",
                            "title": "Produsele procesului verbal",
                            "urlKey": ""
                        }
                    ],
                    "badgeKey": "",
                    "cardEnrichments": [],
                    "cardFieldLayout": [
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "data_doc",
                            "label": "Data",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nume_gest",
                            "label": "Gestiune",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        }
                    ],
                    "datasetID": "8AC5EC17-1C09-598A-B7AB-18BF1D2A1515",
                    "dateFilterKey": "",
                    "dateFilterLastDays": 7,
                    "dateFilterPreset": "none",
                    "detailFieldLayout": [
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "data_doc",
                            "label": "Data",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nume_gest",
                            "label": "Gestiune",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "observatii",
                            "label": "Observații",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "valid",
                            "label": "Validat",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "anulat",
                            "label": "Anulat",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        }
                    ],
                    "detailLiveRefreshSeconds": 0,
                    "fixedFilters": [],
                    "id": "63D08A4D-6ABA-5C7D-9311-41E844A60EC0",
                    "openFilters": [],
                    "pageSize": 100,
                    "requiresOpeningFilterSelection": false,
                    "showOnHome": false,
                    "sortRules": [
                        {
                            "direction": "ascending",
                            "id": "E5C16027-FE07-56C5-A63D-49B1F3EA23E7",
                            "key": "tip_doc",
                            "type": "text"
                        },
                        {
                            "direction": "ascending",
                            "id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
                            "key": "row_id",
                            "type": "text"
                        }
                    ],
                    "subtitle": "",
                    "subtitleKey": "nr_doc",
                    "systemImage": "doc.text",
                    "title": "Procese verbale plus și minus",
                    "titleKey": "tip_doc"
                },
                {
                    "actions": [],
                    "badgeKey": "valoare",
                    "cardEnrichments": [],
                    "cardFieldLayout": [
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "um",
                            "label": "UM",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cantitate",
                            "label": "Cantitate semnată",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nr_lot",
                            "label": "Lot",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        }
                    ],
                    "datasetID": "B53005A4-E743-5766-9586-29DB8C81C585",
                    "dateFilterKey": "",
                    "dateFilterLastDays": 7,
                    "dateFilterPreset": "none",
                    "detailFieldLayout": [
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "um",
                            "label": "UM",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cantitate",
                            "label": "Cantitate semnată",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "pu",
                            "label": "Preț înregistrat",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nr_lot",
                            "label": "Lot",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "data_in",
                            "label": "Data intrării",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "data_exp",
                            "label": "Expirare",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nume_in",
                            "label": "Proveniență",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ctg_db",
                            "label": "Cont debit",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ctg_cr",
                            "label": "Cont credit",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nume_clasa",
                            "label": "Clasă",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "den_sup",
                            "label": "Denumire suplimentară",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        }
                    ],
                    "detailLiveRefreshSeconds": 0,
                    "fixedFilters": [],
                    "id": "B0B5AE33-4EF6-5B40-8FF3-7FB0876C23CA",
                    "openFilters": [],
                    "pageSize": 100,
                    "requiresOpeningFilterSelection": false,
                    "showOnHome": false,
                    "sortRules": [
                        {
                            "direction": "ascending",
                            "id": "FA54A7D7-A679-5E08-8908-E8B4A4A893DC",
                            "key": "denpr",
                            "type": "text"
                        },
                        {
                            "direction": "ascending",
                            "id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
                            "key": "row_id",
                            "type": "text"
                        }
                    ],
                    "subtitle": "",
                    "subtitleKey": "cod_ext",
                    "systemImage": "doc.text",
                    "title": "Produsele procesului verbal",
                    "titleKey": "denpr"
                }
            ],
            "relations": [
                {
                    "childDatasetID": "776B3984-CE7A-5656-A570-E0E510D49290",
                    "childKey": "inventory_key",
                    "id": "71DEEFD4-CD16-54A2-BE34-B7E7FA88DB15",
                    "name": "Situația produselor",
                    "parentDatasetID": "D19FD481-AFB7-5197-9DD5-65664A6208E1",
                    "parentKey": "row_id"
                },
                {
                    "childDatasetID": "8AC5EC17-1C09-598A-B7AB-18BF1D2A1515",
                    "childKey": "inventory_key",
                    "id": "5E223EEA-8855-5F6B-A251-B9E3C63E70D2",
                    "name": "Procesele verbale de diferențe",
                    "parentDatasetID": "D19FD481-AFB7-5197-9DD5-65664A6208E1",
                    "parentKey": "row_id"
                },
                {
                    "childDatasetID": "B53005A4-E743-5766-9586-29DB8C81C585",
                    "childKey": "pv_key",
                    "id": "A4CFD19E-F95E-583A-B826-FD2718C3B1DB",
                    "name": "Produsele procesului verbal",
                    "parentDatasetID": "8AC5EC17-1C09-598A-B7AB-18BF1D2A1515",
                    "parentKey": "row_id"
                }
            ],
            "widgets": []
        }
    },
    "format": "cifru-configuration-package",
    "formatVersion": 1,
    "manifest": {
        "applicationName": "NexusERP",
        "configurationLanguages": [
            "ro"
        ],
        "countries": [
            "RO"
        ],
        "createdAt": "2026-09-27T10:33:24Z",
        "description": "Inventare închise, validate și neanulate → situația produselor cu scriptic, inventariat și diferență → procese verbale plus/minus → liniile PV. Alege luna din lunile existente în documente și gestiunea. Sunt accesibile inclusiv inventarele anilor anteriori, nu doar ultimele 90 zile. Un inventar parțial nu reprezintă întreaga gestiune. Situația folosește funcția nativă inventar_situatie numai pentru inventarul selectat, fără evaluarea tuturor inventarelor la deschidere. Cantitățile și valorile sunt cele calculate de Nexus, nu suma improvizată a colectărilor brute. Nu folosește stocul de azi drept scriptic istoric. Gruparea situației este pe produs, nu pe lot; loturile apar unde sunt înregistrate efectiv în liniile PV. Procesele verbale sunt legate prin referințele lor native. Liniile păstrează semnul, prețul, valoarea, lotul, expirarea, proveniența și conturile. Baza fiscală a antetului PV nu este prezentată drept valoarea semnată a diferențelor. Nu aduna cantități din unități diferite. Nu inventariază, nu ajustează și nu scrie în Nexus. Pro, live, maximum 10.000 inventare și 50.000 produse per sub-listă. La un inventar mai mare decât limita, lista afișată nu trebuie considerată completă; restrânge configurația sau consultă ERP. Capturi DEMO. Manuale: https://www.docs.nexuserp.ro/articol/detalii/4091 ; https://www.docs.nexuserp.ro/articol/inventarierea-stocurilor-gestionate-pe-loturi-prin-intermediul-nexus-transferuri-online/5388 .",
        "licenseCode": "Cifru-Community-1.0",
        "minimumCifruVersion": "1.1.0",
        "minimumPlan": "pro",
        "packageID": "62A77E74-D271-5752-B20C-63B899095A54",
        "rootButtonCount": 1,
        "summary": "Inventar închis → produse: scriptic / inventariat / diferențe → PV plus/minus și linii cu loturi.",
        "tags": [
            "NexusERP",
            "Pro"
        ],
        "title": "Inventare închise și diferențe — Pro"
    }
}

Tags

Reviews

There are no approved reviews for this version yet.

Write a review

Sign in to review

Similar templates

From the same application, then shared tags, in the same language and country.