Stoc pe gestiuni (Pro)
Stoc deduplicat pe produs+gestiune, plus rulaj Nexus document-cu-document țintit prin parametri siguri.
Stoc pe produs și gestiune, deduplicat și cu clasificare — versiunea Pro.
Ce rezolvă: în Nexus, vederea detaliată de stoc are câte un rând per lot/intrare (fiecare cu prețul lui de achiziție), deci un produs poate apărea de zeci de ori la aceeași gestiune. Aici stocul este ÎNSUMAT (SUM) pe perechea gestiune+produs, deci fiecare produs apare o singură dată, cu ultimul preț de achiziție și cu grupa/clasa/subclasa din nomenclator.
Cardul arată produsul, codul/EAN, stocul, prețul de vânzare și clasa. La deschidere alegi obligatoriu gestiunea. Lista principală folosește cache complet cu limită de 500.000 de rânduri și actualizare automată la 60 de minute; Cifru poate construi cache-ul pe partiții folosind filtrul de gestiune.
Din fiecare produs poți deschide stocul în alte gestiuni și rulajul document-cu-document din ultimele 90 de zile. Rulajul urmează organizarea fișei F din MAXapp: Tip document, Număr document, Data, Intrare, Ieșire și Rămas, în ordine cronologică. Rândurile tehnice .STOC INI. sunt consolidate la soldul inițial net atunci când Nexus le întoarce ca intrări și ieșiri istorice separate. Rulajul folosește funcția read-only dbo.raport_rulaje_stoc_ini numai pentru produsul și gestiunea selectate; parametrii sunt completați sigur de Cifru din rândul părinte și nu se construiește un cache global pentru această funcție.
Pregătire în NexusERP / SQL Server:
1. Utilizator SQL dedicat cu SELECT pe dbo.accesex_stoc_view, dbo.accesex_produse_view și dbo.accesex_stoc_detaliat_view, plus permisiunea necesară pentru citirea funcției dbo.raport_rulaje_stoc_ini.
2. Acces securizat din rețeaua telefonului (preferabil VPN), TLS activ.
Configurare în Cifru:
1. Surse → SQL Server read-only, testează.
2. Importă pachetul, mapează slotul.
3. Necesită Pro (SQL personalizat, validat SELECT-only local).
Citirile pot rămâne lente dacă view-urile Nexus nu sunt indexate pentru coloanele filtrate. Cifru afișează eroarea și permite reîncercarea controlată; nu ascunde un timeout printr-un cache global incomplet.
Pachetul nu conține credențiale și nu execută nicio scriere.
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Stoc pe gestiuni
- Details: Stoc în alte gestiuni
- Details: Rulaj lunar stoc
- Sub-button: Stoc în alte gestiuni
- Sub-button: Rulaj stoc (90 zile)
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT
CONCAT(CONVERT(varchar(20), s._pl_gest), '|', CONVERT(varchar(20), s._id_gest), '|', CONVERT(varchar(20), s._pl_pr), '|', CONVERT(varchar(20), s._id_pr)) AS row_id,
CONCAT(CONVERT(varchar(20), s._pl_gest), '|', CONVERT(varchar(20), s._id_gest), '|', CONVERT(varchar(20), s._pl_pr), '|', CONVERT(varchar(20), s._id_pr)) AS stock_key,
s.id_produs AS product_key,
s._pl_gest,
s._id_gest,
s._pl_pr,
s._id_pr,
s.den_gestiune,
s.den_produs,
s.cod_produs,
s.nume_brand,
CAST(SUM(ISNULL(s.stoc, 0)) AS decimal(20, 3)) AS stoc,
CAST(SUM(ISNULL(s.rezervat, 0)) AS decimal(20, 3)) AS rezervat,
CAST(MAX(s.ultimul_pret_achizitie) AS decimal(20, 2)) AS pret_achizitie,
CAST(MAX(s.pret_vanzare_tva) AS decimal(20, 2)) AS pret_vanzare,
MAX(p.den_grupa) AS grupa,
MAX(p.den_clasa) AS clasa,
MAX(p.den_subclasa) AS subclasa
FROM dbo.accesex_stoc_view s WITH (NOLOCK)
LEFT JOIN dbo.accesex_produse_view p WITH (NOLOCK) ON p.id_intern = s.id_produs
WHERE s.stoc > 0
GROUP BY s.id_produs, s._pl_gest, s._id_gest, s._pl_pr, s._id_pr,
s.den_gestiune, s.den_produs, s.cod_produs, s.nume_brand
HAVING SUM(ISNULL(s.stoc, 0)) > 0static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT
CONCAT(v.den_gestiune, '|', v.cod_produs) AS row_id,
v.den_gestiune,
v.den_produs,
v.cod_produs,
CAST(SUM(ISNULL(v.cantitate, 0)) AS decimal(20, 3)) AS stoc,
CAST(MAX(CAST(ISNULL(v.rezervat, 0) AS int)) AS decimal(20, 3)) AS rezervat,
CAST(MAX(v.pret_vanzare_tva) AS decimal(20, 2)) AS pret_vanzare
FROM dbo.accesex_stoc_detaliat_view v WITH (NOLOCK)
GROUP BY v.den_gestiune, v.den_produs, v.cod_produs
HAVING SUM(ISNULL(v.cantitate, 0)) > 0static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQueryWITH raw_rows AS (
SELECT
ROW_NUMBER() OVER (
ORDER BY a.data_doc, a.nr_doc, a.tip_doc, a.cant_int, a.cant_ies, a.pu, a.denumire
) AS source_order,
CASE WHEN UPPER(LTRIM(RTRIM(ISNULL(a.tip_doc, '')))) = '.STOC INI.' THEN 1 ELSE 0 END AS is_initial,
a.tip_doc,
a.nr_doc,
a.data_doc,
CAST(ISNULL(a.cant_int, 0) AS decimal(20, 3)) AS cant_int,
CAST(ISNULL(a.cant_ies, 0) AS decimal(20, 3)) AS cant_ies,
CAST(ISNULL(a.pu, 0) AS decimal(20, 4)) AS pu,
a.denumire
FROM dbo.raport_rulaje_stoc_ini(
:data_ini, :data_fin, :tip_stoc, :pl_gest, :id_gest, :pl_pr, :id_pr
) a
), ranked_rows AS (
SELECT
r.*,
SUM(CASE WHEN r.is_initial = 1 THEN r.cant_int - r.cant_ies ELSE 0 END) OVER () AS initial_net,
MAX(CASE WHEN r.is_initial = 1 AND (r.cant_ies <> 0 OR r.cant_int < 0) THEN 1 ELSE 0 END) OVER () AS normalize_initial,
ROW_NUMBER() OVER (PARTITION BY r.is_initial ORDER BY r.source_order) AS initial_rank
FROM raw_rows r
), normalized_rows AS (
SELECT
source_order,
tip_doc,
CASE WHEN is_initial = 1 AND normalize_initial = 1 THEN '' ELSE CONVERT(varchar(100), nr_doc) END AS nr_doc,
data_doc,
CAST(CASE WHEN is_initial = 1 AND normalize_initial = 1 THEN initial_net ELSE cant_int END AS decimal(20, 3)) AS cant_int,
CAST(CASE WHEN is_initial = 1 AND normalize_initial = 1 THEN 0 ELSE cant_ies END AS decimal(20, 3)) AS cant_ies,
pu,
denumire
FROM ranked_rows
WHERE is_initial = 0 OR normalize_initial = 0 OR initial_rank = 1
)
SELECT
CONCAT(CONVERT(varchar(20), :pl_gest), '|', CONVERT(varchar(20), :id_gest), '|',
CONVERT(varchar(20), :pl_pr), '|', CONVERT(varchar(20), :id_pr), '|',
CONVERT(varchar(20), n.source_order)) AS row_id,
CONCAT(CONVERT(varchar(20), :pl_gest), '|', CONVERT(varchar(20), :id_gest), '|',
CONVERT(varchar(20), :pl_pr), '|', CONVERT(varchar(20), :id_pr)) AS stock_key,
n.tip_doc,
n.nr_doc,
CONVERT(varchar(10), n.data_doc, 23) AS data_doc,
n.cant_int,
n.cant_ies,
CAST(SUM(n.cant_int - n.cant_ies) OVER (
ORDER BY n.data_doc, n.source_order ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
) AS decimal(20, 3)) AS cant_sold,
n.pu,
n.denumire
FROM normalized_rows nstatic read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server (AccesEx + nomenclator)",
"id": "C97BAA14-1073-58FD-8D63-39C94222AF39",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_stoc_view",
"dbo.accesex_stoc_detaliat_view",
"dbo.accesex_produse_view",
"dbo.raport_rulaje_stoc_ini"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [],
"id": "89050D6A-72CF-51E9-805A-21C8ADBC5896",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "stock_key",
"label": "Cheie stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stock_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_key",
"label": "Cheie produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_key",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "_pl_gest",
"label": "Punct lucru gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "_pl_gest",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "_id_gest",
"label": "ID gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "_id_gest",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "_pl_pr",
"label": "Punct lucru produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "_pl_pr",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "_id_pr",
"label": "ID produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "_id_pr",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "product_name",
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "product_code",
"key": "cod_produs",
"label": "Cod / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nume_brand",
"label": "Brand",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_brand",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "quantity",
"key": "stoc",
"label": "Stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stoc",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "rezervat",
"label": "Rezervat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "rezervat",
"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 cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "grupa",
"label": "Grupă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "grupa",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "clasa",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "clasa",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "subclasa",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "subclasa",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500000,
"name": "Stoc pe gestiuni",
"primaryKey": "row_id",
"queryParameters": [],
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"row_id",
"stock_key",
"product_key",
"_pl_gest",
"_id_gest"
],
"sourceID": "C97BAA14-1073-58FD-8D63-39C94222AF39",
"sqlQuery": "SELECT\n CONCAT(CONVERT(varchar(20), s._pl_gest), '|', CONVERT(varchar(20), s._id_gest), '|', CONVERT(varchar(20), s._pl_pr), '|', CONVERT(varchar(20), s._id_pr)) AS row_id,\n CONCAT(CONVERT(varchar(20), s._pl_gest), '|', CONVERT(varchar(20), s._id_gest), '|', CONVERT(varchar(20), s._pl_pr), '|', CONVERT(varchar(20), s._id_pr)) AS stock_key,\n s.id_produs AS product_key,\n s._pl_gest,\n s._id_gest,\n s._pl_pr,\n s._id_pr,\n s.den_gestiune,\n s.den_produs,\n s.cod_produs,\n s.nume_brand,\n CAST(SUM(ISNULL(s.stoc, 0)) AS decimal(20, 3)) AS stoc,\n CAST(SUM(ISNULL(s.rezervat, 0)) AS decimal(20, 3)) AS rezervat,\n CAST(MAX(s.ultimul_pret_achizitie) AS decimal(20, 2)) AS pret_achizitie,\n CAST(MAX(s.pret_vanzare_tva) AS decimal(20, 2)) AS pret_vanzare,\n MAX(p.den_grupa) AS grupa,\n MAX(p.den_clasa) AS clasa,\n MAX(p.den_subclasa) AS subclasa\nFROM dbo.accesex_stoc_view s WITH (NOLOCK)\nLEFT JOIN dbo.accesex_produse_view p WITH (NOLOCK) ON p.id_intern = s.id_produs\nWHERE s.stoc > 0\nGROUP BY s.id_produs, s._pl_gest, s._id_gest, s._pl_pr, s._id_pr,\n s.den_gestiune, s.den_produs, s.cod_produs, s.nume_brand\nHAVING SUM(ISNULL(s.stoc, 0)) > 0",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [],
"id": "40E31F5C-6056-57A4-BA1D-533DB1D9D02E",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"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": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cod_produs",
"label": "Cod / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "stoc",
"label": "Stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stoc",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "rezervat",
"label": "Rezervat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "rezervat",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pret_vanzare",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Stoc în alte gestiuni",
"primaryKey": "row_id",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 30
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"row_id",
"den_gestiune",
"den_produs",
"cod_produs",
"stoc"
],
"sourceID": "C97BAA14-1073-58FD-8D63-39C94222AF39",
"sqlQuery": "SELECT\n CONCAT(v.den_gestiune, '|', v.cod_produs) AS row_id,\n v.den_gestiune,\n v.den_produs,\n v.cod_produs,\n CAST(SUM(ISNULL(v.cantitate, 0)) AS decimal(20, 3)) AS stoc,\n CAST(MAX(CAST(ISNULL(v.rezervat, 0) AS int)) AS decimal(20, 3)) AS rezervat,\n CAST(MAX(v.pret_vanzare_tva) AS decimal(20, 2)) AS pret_vanzare\nFROM dbo.accesex_stoc_detaliat_view v WITH (NOLOCK)\nGROUP BY v.den_gestiune, v.den_produs, v.cod_produs\nHAVING SUM(ISNULL(v.cantitate, 0)) > 0",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "993FD509-5002-577F-8331-492CA4DFBFD4",
"key": "data_doc",
"type": "date"
}
],
"id": "219F5AF4-10B2-51CC-9574-8FAC2C247C95",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "stock_key",
"label": "Cheie stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stock_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_doc",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_doc",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_doc",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_doc",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_doc",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_doc",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cant_int",
"label": "Intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cant_int",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cant_ies",
"label": "Ieșire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cant_ies",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cant_sold",
"label": "Sold",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cant_sold",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pu",
"label": "Preț unitar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pu",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "denumire",
"label": "Denumire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "denumire",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Rulaj lunar stoc",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": -90,
"fieldKey": "",
"id": "2DC05D68-BC5F-50C0-ABB7-EC95197A6E83",
"name": "data_ini",
"source": "today",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "",
"id": "8F009901-AC07-5C94-809F-3148ED25AD23",
"name": "data_fin",
"source": "today",
"type": "date"
},
{
"constantValue": "G",
"dayOffset": 0,
"fieldKey": "",
"id": "A4F5BA3B-A7CC-5932-B78F-60DF41EFE6C0",
"name": "tip_stoc",
"source": "constant",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "_pl_gest",
"id": "80F60988-F1A6-5069-9E5A-8389B3A552D0",
"name": "pl_gest",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "_id_gest",
"id": "C413BA9E-A881-5E71-A47A-8CBFE1182973",
"name": "id_gest",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "_pl_pr",
"id": "B6FDA4CA-4222-55F3-8135-3072EA929716",
"name": "pl_pr",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "_id_pr",
"id": "1089BEE3-8624-5C7B-BABC-C2552B0E6B32",
"name": "id_pr",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 30
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"row_id",
"stock_key",
"tip_doc",
"nr_doc",
"data_doc"
],
"sourceID": "C97BAA14-1073-58FD-8D63-39C94222AF39",
"sqlQuery": "WITH raw_rows AS (\n SELECT\n ROW_NUMBER() OVER (\n ORDER BY a.data_doc, a.nr_doc, a.tip_doc, a.cant_int, a.cant_ies, a.pu, a.denumire\n ) AS source_order,\n CASE WHEN UPPER(LTRIM(RTRIM(ISNULL(a.tip_doc, '')))) = '.STOC INI.' THEN 1 ELSE 0 END AS is_initial,\n a.tip_doc,\n a.nr_doc,\n a.data_doc,\n CAST(ISNULL(a.cant_int, 0) AS decimal(20, 3)) AS cant_int,\n CAST(ISNULL(a.cant_ies, 0) AS decimal(20, 3)) AS cant_ies,\n CAST(ISNULL(a.pu, 0) AS decimal(20, 4)) AS pu,\n a.denumire\n FROM dbo.raport_rulaje_stoc_ini(\n :data_ini, :data_fin, :tip_stoc, :pl_gest, :id_gest, :pl_pr, :id_pr\n ) a\n), ranked_rows AS (\n SELECT\n r.*,\n SUM(CASE WHEN r.is_initial = 1 THEN r.cant_int - r.cant_ies ELSE 0 END) OVER () AS initial_net,\n MAX(CASE WHEN r.is_initial = 1 AND (r.cant_ies <> 0 OR r.cant_int < 0) THEN 1 ELSE 0 END) OVER () AS normalize_initial,\n ROW_NUMBER() OVER (PARTITION BY r.is_initial ORDER BY r.source_order) AS initial_rank\n FROM raw_rows r\n), normalized_rows AS (\n SELECT\n source_order,\n tip_doc,\n CASE WHEN is_initial = 1 AND normalize_initial = 1 THEN '' ELSE CONVERT(varchar(100), nr_doc) END AS nr_doc,\n data_doc,\n CAST(CASE WHEN is_initial = 1 AND normalize_initial = 1 THEN initial_net ELSE cant_int END AS decimal(20, 3)) AS cant_int,\n CAST(CASE WHEN is_initial = 1 AND normalize_initial = 1 THEN 0 ELSE cant_ies END AS decimal(20, 3)) AS cant_ies,\n pu,\n denumire\n FROM ranked_rows\n WHERE is_initial = 0 OR normalize_initial = 0 OR initial_rank = 1\n)\nSELECT\n CONCAT(CONVERT(varchar(20), :pl_gest), '|', CONVERT(varchar(20), :id_gest), '|',\n CONVERT(varchar(20), :pl_pr), '|', CONVERT(varchar(20), :id_pr), '|',\n CONVERT(varchar(20), n.source_order)) AS row_id,\n CONCAT(CONVERT(varchar(20), :pl_gest), '|', CONVERT(varchar(20), :id_gest), '|',\n CONVERT(varchar(20), :pl_pr), '|', CONVERT(varchar(20), :id_pr)) AS stock_key,\n n.tip_doc,\n n.nr_doc,\n CONVERT(varchar(10), n.data_doc, 23) AS data_doc,\n n.cant_int,\n n.cant_ies,\n CAST(SUM(n.cant_int - n.cant_ies) OVER (\n ORDER BY n.data_doc, n.source_order ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW\n ) AS decimal(20, 3)) AS cant_sold,\n n.pu,\n n.denumire\nFROM normalized_rows n",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "65D1C137-5F67-52E1-B01C-A5DAD3DBFD51",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "D2945E70-5C02-5D5C-A6C8-1F63C5C6997E",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "40E31F5C-6056-57A4-BA1D-533DB1D9D02E",
"title": "Stoc în alte gestiuni",
"urlKey": ""
},
{
"id": "552ACD41-398D-5882-A966-445265FD7BBF",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "F7CC4A1F-3B38-51E8-8624-0D4ABB46C061",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "219F5AF4-10B2-51CC-9574-8FAC2C247C95",
"title": "Rulaj stoc (90 zile)",
"urlKey": ""
}
],
"badgeKey": "stoc",
"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 / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stoc",
"label": "Stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "clasa",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "89050D6A-72CF-51E9-805A-21C8ADBC5896",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Produs",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Produs",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Produs",
"detailRole": "information",
"isVisible": true,
"key": "nume_brand",
"label": "Brand",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stoc",
"detailRole": "highlight",
"isVisible": true,
"key": "stoc",
"label": "Stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stoc",
"detailRole": "information",
"isVisible": true,
"key": "rezervat",
"label": "Rezervat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prețuri",
"detailRole": "information",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prețuri",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Clasificare",
"detailRole": "information",
"isVisible": true,
"key": "grupa",
"label": "Grupă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Clasificare",
"detailRole": "information",
"isVisible": true,
"key": "clasa",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Clasificare",
"detailRole": "information",
"isVisible": true,
"key": "subclasa",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "82E0E7F8-A569-526A-B93A-D1E4CC6BD052",
"openFilters": [
{
"id": "786AECC1-9A82-5E11-BBF0-23AAF46A6818",
"includeAllOption": false,
"key": "den_gestiune",
"title": "Alege gestiunea",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "C0662EC4-4556-524F-9B67-210C0C480C6C",
"key": "den_produs",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "shippingbox",
"title": "Stoc pe gestiuni",
"titleKey": "den_produs"
},
{
"actions": [],
"badgeKey": "stoc",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stoc",
"label": "Stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "rezervat",
"label": "Rezervat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "40E31F5C-6056-57A4-BA1D-533DB1D9D02E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "stoc",
"label": "Stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "rezervat",
"label": "Rezervat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "8B60281C-F158-543D-9A80-AF18C97AC029",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "84F6FE4C-A721-568E-B771-9ACCF0426E89",
"key": "den_gestiune",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "den_produs",
"systemImage": "building.2",
"title": "Stoc în alte gestiuni",
"titleKey": "den_gestiune"
},
{
"actions": [],
"badgeKey": "cant_sold",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_doc",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_doc",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_doc",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cant_int",
"label": "Intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cant_ies",
"label": "Ieșire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cant_sold",
"label": "Sold",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "219F5AF4-10B2-51CC-9574-8FAC2C247C95",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_doc",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_doc",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_doc",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cant_int",
"label": "Intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cant_ies",
"label": "Ieșire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "cant_sold",
"label": "Sold",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pu",
"label": "Preț unitar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "denumire",
"label": "Denumire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "258A12CB-5169-5A6C-8DC6-5593E48953AB",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "993FD509-5002-577F-8331-492CA4DFBFD4",
"key": "data_doc",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "nr_doc",
"systemImage": "chart.bar",
"title": "Rulaj stoc (90 zile)",
"titleKey": "tip_doc"
}
],
"relations": [
{
"childDatasetID": "40E31F5C-6056-57A4-BA1D-533DB1D9D02E",
"childKey": "cod_produs",
"id": "D2945E70-5C02-5D5C-A6C8-1F63C5C6997E",
"name": "Stoc în alte gestiuni",
"parentDatasetID": "89050D6A-72CF-51E9-805A-21C8ADBC5896",
"parentKey": "cod_produs"
},
{
"childDatasetID": "219F5AF4-10B2-51CC-9574-8FAC2C247C95",
"childKey": "stock_key",
"id": "F7CC4A1F-3B38-51E8-8624-0D4ABB46C061",
"name": "Rulaj lunar stoc",
"parentDatasetID": "89050D6A-72CF-51E9-805A-21C8ADBC5896",
"parentKey": "stock_key"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-03T10:46:15Z",
"description": "Stoc pe produs și gestiune, deduplicat și cu clasificare — versiunea Pro.\n\nCe rezolvă: în Nexus, vederea detaliată de stoc are câte un rând per lot/intrare (fiecare cu prețul lui de achiziție), deci un produs poate apărea de zeci de ori la aceeași gestiune. Aici stocul este ÎNSUMAT (SUM) pe perechea gestiune+produs, deci fiecare produs apare o singură dată, cu ultimul preț de achiziție și cu grupa/clasa/subclasa din nomenclator.\n\nCardul arată produsul, codul/EAN, stocul, prețul de vânzare și clasa. La deschidere alegi obligatoriu gestiunea. Lista principală folosește cache complet cu limită de 500.000 de rânduri și actualizare automată la 60 de minute; Cifru poate construi cache-ul pe partiții folosind filtrul de gestiune.\n\nDin fiecare produs poți deschide stocul în alte gestiuni și rulajul document-cu-document din ultimele 90 de zile. Rulajul urmează organizarea fișei F din MAXapp: Tip document, Număr document, Data, Intrare, Ieșire și Rămas, în ordine cronologică. Rândurile tehnice .STOC INI. sunt consolidate la soldul inițial net atunci când Nexus le întoarce ca intrări și ieșiri istorice separate. Rulajul folosește funcția read-only dbo.raport_rulaje_stoc_ini numai pentru produsul și gestiunea selectate; parametrii sunt completați sigur de Cifru din rândul părinte și nu se construiește un cache global pentru această funcție.\n\nPregătire în NexusERP / SQL Server:\n1. Utilizator SQL dedicat cu SELECT pe dbo.accesex_stoc_view, dbo.accesex_produse_view și dbo.accesex_stoc_detaliat_view, plus permisiunea necesară pentru citirea funcției dbo.raport_rulaje_stoc_ini.\n2. Acces securizat din rețeaua telefonului (preferabil VPN), TLS activ.\n\nConfigurare în Cifru:\n1. Surse → SQL Server read-only, testează.\n2. Importă pachetul, mapează slotul.\n3. Necesită Pro (SQL personalizat, validat SELECT-only local).\n\nCitirile pot rămâne lente dacă view-urile Nexus nu sunt indexate pentru coloanele filtrate. Cifru afișează eroarea și permite reîncercarea controlată; nu ascunde un timeout printr-un cache global incomplet.\n\nPachetul nu conține credențiale și nu execută nicio scriere.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0.4",
"minimumPlan": "pro",
"packageID": "817B4011-CB76-53AD-821B-B10CCDDB4CBD",
"rootButtonCount": 1,
"summary": "Stoc deduplicat pe produs+gestiune, plus rulaj Nexus document-cu-document țintit prin parametri siguri.",
"tags": [
"NexusERP",
"stoc",
"gestiuni",
"clasificare",
"SQL read-only"
],
"title": "Stoc pe gestiuni (Pro)"
}
}