Stoc zero cu mișcare — Pro
Perioadă și gestiune → produse → documente, fără identificatori tehnici afișați.
Alegi perioada nativă și, opțional, filtrezi lista de gestiuni; deschizi gestiunea și apeși Produsele gestiunii. Abia atunci se execută raportul pentru acea singură gestiune. Dintr-un produs deschizi documentele lui, în aceeași perioadă. Prima listă este selectorul de gestiuni, nu un raport gol sau o scanare a întregii firme. Cheile tehnice sunt ascunse; nume, coduri, UM, clase și date sunt vizibile în carduri sau Detalii. Arată produsele cu STOC CURENT egal cu zero și cu intrări ori ieșiri reale în perioada selectată. Nu este stocul de la sfârșitul perioadei. Include și produsele cu intrări și ieșiri egale; stocul negativ nu este zero. Funcția nativă raport_rulaje_stoc citește o singură gestiune, fără stoc inițial; sel_stoc_raw verifică separat stocul curent pentru familia G, ca în Stoc pe gestiuni Pro. Nu aproximează zilele prin totaluri lunare și nu rulează o funcție separată pentru fiecare produs din lista principală. Mișcările păstrează tipul, numărul, data documentului, intrările și ieșirile. Cheia liniilor este valabilă pentru citirea curentă, nu un ID permanent Nexus. Manual stoc: https://www.docs.nexuserp.ro/articol/accesare-externa-stocuri/4487 . Citire live fără refresh global; maximum 10.000 de rânduri afișate per nivel. Pentru intervale mari restrânge perioada; totalurile se calculează înaintea limitei de afișare. Necesită Pro, iOS 1.1.0 build 336 / Android 1.1.0 build 284 sau mai nou. Funcțiile și vizualizările standard trebuie să fie accesibile contului read-only. Configurație comunitară neoficială.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Stoc zero cu mișcare — gestiuni
- Details: Produsele gestiunii
- Details: Mișcările produsului
- Sub-button: Produse cu stoc zero
- Sub-button: Mișcările produsului
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(g.pct_lcr,'|',g.id) AS warehouse_key,
g.pct_lcr AS warehouse_pl,g.id AS warehouse_id,g.nume AS warehouse_name,
CAST(:period_from AS date) AS period_date,
CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,
CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to
FROM dbo.gestiuni gstatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQueryWITH movements AS (
SELECT
a.pl_pr, a.id_pr,
MAX(a.nume_gest) AS warehouse_name,
MAX(RTRIM(a.um)) AS unit,
MAX(a.nume_clasa) AS product_class,
MAX(a.nume_subcl) AS product_subclass,
MIN(a.data_doc) AS first_movement_date,
MAX(a.data_doc) AS last_movement_date,
SUM(a.cant_int) AS quantity_in,
SUM(a.cant_ies) AS quantity_out,
COUNT_BIG(*) AS movement_count
FROM dbo.raport_rulaje_stoc(
:period_from, DATEADD(day, -1, CAST(:period_until AS date)),
'G', CAST(:pl_gest AS decimal(38,0)), CAST(:id_gest AS decimal(38,0)), NULL, NULL
) a
WHERE a.data_doc >= :period_from AND a.data_doc < :period_until
AND a.pl_gest = CAST(:pl_gest AS decimal(38,0)) AND a.id_gest = CAST(:id_gest AS decimal(38,0))
AND (a.cant_int <> 0 OR a.cant_ies <> 0)
AND UPPER(LTRIM(RTRIM(ISNULL(a.tip_doc, '')))) <> '.STOC INI.'
GROUP BY a.pl_pr, a.id_pr
), current_stock AS (
SELECT pl_pr, id_pr, SUM(cantitate) AS current_quantity
FROM dbo.sel_stoc_raw(CONVERT(char(6), GETDATE(), 112), CAST(:pl_gest AS decimal(38,0)), CAST(:id_gest AS decimal(38,0)))
WHERE pl_gest = CAST(:pl_gest AS decimal(38,0)) AND id_gest = CAST(:id_gest AS decimal(38,0))
GROUP BY pl_pr, id_pr
)
SELECT CONCAT(CAST(:pl_gest AS decimal(38,0)),'|',CAST(:id_gest AS decimal(38,0))) AS warehouse_key,CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to,
CONCAT(CAST(:pl_gest AS decimal(38,0)), '|', CAST(:id_gest AS decimal(38,0)), '|', m.pl_pr, '|', m.id_pr) AS row_key,
CAST(:pl_gest AS decimal(38,0)) AS warehouse_pl, CAST(:id_gest AS decimal(38,0)) AS warehouse_id,
m.pl_pr AS product_pl, m.id_pr AS product_id,
m.warehouse_name, n.denumire AS product_name,
RTRIM(n.cod_ext) AS product_code,
m.unit, m.product_class, m.product_subclass,
CAST(COALESCE(s.current_quantity, 0) AS decimal(20, 3)) AS current_quantity,
m.quantity_in, m.quantity_out, m.movement_count,
m.first_movement_date, m.last_movement_date,
CONVERT(varchar(10), CAST(:period_from AS date), 23) AS period_from,
CONVERT(varchar(10), CAST(:period_until AS date), 23) AS period_until,
CAST(:period_from AS date) AS period_date,
CAST(GETDATE() AS date) AS stock_read_date
FROM movements m
LEFT JOIN current_stock s ON s.pl_pr = m.pl_pr AND s.id_pr = m.id_pr
LEFT JOIN dbo.nomen3 n ON n.pct_lcr = m.pl_pr AND n.id = m.id_pr
WHERE COALESCE(s.current_quantity, 0) = 0static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT
CONCAT(CAST(:pl_gest AS decimal(38,0)),'|',CAST(:id_gest AS decimal(38,0)),'|',CAST(:pl_pr AS decimal(38,0)),'|',CAST(:id_pr AS decimal(38,0))) AS product_key,
CONCAT(CAST(:pl_gest AS decimal(38,0)),'|',CAST(:id_gest AS decimal(38,0)),'|',CAST(:pl_pr AS decimal(38,0)),'|',CAST(:id_pr AS decimal(38,0)),'|',:period_from,'|',:period_until,'|',
ROW_NUMBER() OVER (ORDER BY a.data_doc,a.tip_doc,a.nr_doc,a.serie_doc,a.linktodoc_nr_doc,a.nr_lot,a.data_in,a.cant_int,a.cant_ies,a.pu,a.denumire)) AS row_key,
CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to,
a.tip_doc, a.nr_doc, a.data_doc,
a.cant_int, a.cant_ies, a.um,
a.denumire AS movement_description, a.nume_gest,
a.nume_clasa, a.nume_subcl
FROM dbo.raport_rulaje_stoc(
:period_from, DATEADD(day, -1, CAST(:period_until AS date)),
'G', CAST(:pl_gest AS decimal(38,0)), CAST(:id_gest AS decimal(38,0)), CAST(:pl_pr AS decimal(38,0)), CAST(:id_pr AS decimal(38,0))
) a
WHERE a.data_doc >= :period_from AND a.data_doc < :period_until
AND a.pl_gest = CAST(:pl_gest AS decimal(38,0)) AND a.id_gest = CAST(:id_gest AS decimal(38,0))
AND (a.cant_int <> 0 OR a.cant_ies <> 0)
AND UPPER(LTRIM(RTRIM(ISNULL(a.tip_doc, '')))) <> '.STOC INI.'static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server",
"id": "D58FAEF3-A6A7-5A5C-9DB8-55E2E824AEA7",
"kind": "sqlServer",
"requiredObjects": [
"dbo.gestiuni",
"dbo.raport_rulaje_stoc",
"dbo.sel_stoc_raw",
"dbo.nomen3"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "B8917D7E-E4B6-5C62-9667-6B050C3FA426",
"key": "warehouse_name",
"type": "text"
}
],
"id": "27CEA772-2E70-5C46-90CE-A07E59CF2AF9",
"mappings": [
{
"commonFieldKey": "",
"key": "warehouse_key",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_pl",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_pl",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_id",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_name",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_name",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "period_from",
"label": "Început intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_from",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "Sfârșit exclusiv intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "Perioada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_from",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_to",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Stoc zero cu mișcare — gestiuni",
"primaryKey": "warehouse_key",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "6BDDAA54-65D2-5444-BCB6-A0E6DD9FC5F6",
"name": "period_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "6C179E87-6FE9-52B5-9AC0-BF93FE1A9F8B",
"name": "period_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"warehouse_name",
"date_from",
"date_to"
],
"sourceID": "D58FAEF3-A6A7-5A5C-9DB8-55E2E824AEA7",
"sqlQuery": "SELECT CONCAT(g.pct_lcr,'|',g.id) AS warehouse_key,\n g.pct_lcr AS warehouse_pl,g.id AS warehouse_id,g.nume AS warehouse_name,\n CAST(:period_from AS date) AS period_date,\n CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,\n CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to\nFROM dbo.gestiuni g",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "DF8EA000-B498-5DAD-A12F-809E2466B8F4",
"key": "product_name",
"type": "text"
},
{
"direction": "ascending",
"id": "7EB9EDD8-6AA7-5E4D-83E5-5268A490EA2D",
"key": "row_key",
"type": "text"
}
],
"id": "DA8685DF-02D4-5BBE-AD82-5853EF5C3158",
"mappings": [
{
"commonFieldKey": "",
"key": "row_key",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_key",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_pl",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_pl",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_id",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_pl",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_pl",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_id",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_name",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_name",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_name",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "product_code",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_code",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "unit",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "unit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "product_class",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_class",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_subclass",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_subclass",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "current_quantity",
"label": "Stoc curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "current_quantity",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "quantity_in",
"label": "Intrări în perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "quantity_in",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "quantity_out",
"label": "Ieșiri în perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "quantity_out",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "movement_count",
"label": "Mișcări",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "movement_count",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "first_movement_date",
"label": "Prima mișcare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "first_movement_date",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "last_movement_date",
"label": "Ultima mișcare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "last_movement_date",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "stock_read_date",
"label": "Data citirii stocului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stock_read_date",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_from",
"label": "Început intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_from",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "Sfârșit exclusiv intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "Perioada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_from",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_to",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Produse cu stoc zero",
"primaryKey": "row_key",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "40E37715-DDEA-557A-A609-2DA114396B60",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "C78BEA46-7E0C-5F0F-8D8B-9581C4152996",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "warehouse_pl",
"id": "8822FE9A-EF76-5BFA-B2D7-E7930734F5B5",
"name": "pl_gest",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "warehouse_id",
"id": "3577055E-8803-5714-B346-EB43630CDA69",
"name": "id_gest",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"warehouse_name",
"product_name",
"product_code",
"unit",
"product_class",
"product_subclass",
"current_quantity",
"quantity_in",
"quantity_out",
"movement_count",
"first_movement_date",
"last_movement_date",
"stock_read_date",
"date_from",
"date_to"
],
"sourceID": "D58FAEF3-A6A7-5A5C-9DB8-55E2E824AEA7",
"sqlQuery": "WITH movements AS (\n SELECT\n a.pl_pr, a.id_pr,\n MAX(a.nume_gest) AS warehouse_name,\n MAX(RTRIM(a.um)) AS unit,\n MAX(a.nume_clasa) AS product_class,\n MAX(a.nume_subcl) AS product_subclass,\n MIN(a.data_doc) AS first_movement_date,\n MAX(a.data_doc) AS last_movement_date,\n SUM(a.cant_int) AS quantity_in,\n SUM(a.cant_ies) AS quantity_out,\n COUNT_BIG(*) AS movement_count\n FROM dbo.raport_rulaje_stoc(\n :period_from, DATEADD(day, -1, CAST(:period_until AS date)),\n 'G', CAST(:pl_gest AS decimal(38,0)), CAST(:id_gest AS decimal(38,0)), NULL, NULL\n ) a\n WHERE a.data_doc >= :period_from AND a.data_doc < :period_until\n AND a.pl_gest = CAST(:pl_gest AS decimal(38,0)) AND a.id_gest = CAST(:id_gest AS decimal(38,0))\n AND (a.cant_int <> 0 OR a.cant_ies <> 0)\n AND UPPER(LTRIM(RTRIM(ISNULL(a.tip_doc, '')))) <> '.STOC INI.'\n GROUP BY a.pl_pr, a.id_pr\n), current_stock AS (\n SELECT pl_pr, id_pr, SUM(cantitate) AS current_quantity\n FROM dbo.sel_stoc_raw(CONVERT(char(6), GETDATE(), 112), CAST(:pl_gest AS decimal(38,0)), CAST(:id_gest AS decimal(38,0)))\n WHERE pl_gest = CAST(:pl_gest AS decimal(38,0)) AND id_gest = CAST(:id_gest AS decimal(38,0))\n GROUP BY pl_pr, id_pr\n)\nSELECT CONCAT(CAST(:pl_gest AS decimal(38,0)),'|',CAST(:id_gest AS decimal(38,0))) AS warehouse_key,CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to,\n CONCAT(CAST(:pl_gest AS decimal(38,0)), '|', CAST(:id_gest AS decimal(38,0)), '|', m.pl_pr, '|', m.id_pr) AS row_key,\n CAST(:pl_gest AS decimal(38,0)) AS warehouse_pl, CAST(:id_gest AS decimal(38,0)) AS warehouse_id,\n m.pl_pr AS product_pl, m.id_pr AS product_id,\n m.warehouse_name, n.denumire AS product_name,\n RTRIM(n.cod_ext) AS product_code,\n m.unit, m.product_class, m.product_subclass,\n CAST(COALESCE(s.current_quantity, 0) AS decimal(20, 3)) AS current_quantity,\n m.quantity_in, m.quantity_out, m.movement_count,\n m.first_movement_date, m.last_movement_date,\n CONVERT(varchar(10), CAST(:period_from AS date), 23) AS period_from,\n CONVERT(varchar(10), CAST(:period_until AS date), 23) AS period_until,\n CAST(:period_from AS date) AS period_date,\n CAST(GETDATE() AS date) AS stock_read_date\nFROM movements m\nLEFT JOIN current_stock s ON s.pl_pr = m.pl_pr AND s.id_pr = m.id_pr\nLEFT JOIN dbo.nomen3 n ON n.pct_lcr = m.pl_pr AND n.id = m.id_pr\nWHERE COALESCE(s.current_quantity, 0) = 0",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
"key": "data_doc",
"type": "date"
},
{
"direction": "ascending",
"id": "7EB9EDD8-6AA7-5E4D-83E5-5268A490EA2D",
"key": "row_key",
"type": "text"
}
],
"id": "DD4CA9DE-3988-556B-B62E-1B67849FF3EB",
"mappings": [
{
"commonFieldKey": "",
"key": "row_key",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_key",
"label": "Context intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_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": "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": "um",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "um",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "movement_description",
"label": "Descrierea mișcării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "movement_description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume_gest",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_gest",
"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": "nume_subcl",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_subcl",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_from",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_to",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Mișcările produsului",
"primaryKey": "row_key",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "854B4153-B23B-52CA-B4DD-90C564B20147",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "49CF73DB-8A67-5289-AF51-81341DAEB803",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "warehouse_pl",
"id": "5ED123B3-E684-544E-96F4-413A83CADF10",
"name": "pl_gest",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "warehouse_id",
"id": "963F148C-784E-5B04-B9D5-0BDFE8E4CD19",
"name": "id_gest",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_pl",
"id": "C3E66A8F-B500-5135-96D1-0245574A6408",
"name": "pl_pr",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_id",
"id": "D1B56280-B4CC-5D09-B330-F90555D89ABA",
"name": "id_pr",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"tip_doc",
"nr_doc",
"data_doc",
"cant_int",
"cant_ies",
"um",
"movement_description",
"nume_gest",
"nume_clasa",
"nume_subcl",
"date_from",
"date_to"
],
"sourceID": "D58FAEF3-A6A7-5A5C-9DB8-55E2E824AEA7",
"sqlQuery": "SELECT\n CONCAT(CAST(:pl_gest AS decimal(38,0)),'|',CAST(:id_gest AS decimal(38,0)),'|',CAST(:pl_pr AS decimal(38,0)),'|',CAST(:id_pr AS decimal(38,0))) AS product_key,\n CONCAT(CAST(:pl_gest AS decimal(38,0)),'|',CAST(:id_gest AS decimal(38,0)),'|',CAST(:pl_pr AS decimal(38,0)),'|',CAST(:id_pr AS decimal(38,0)),'|',:period_from,'|',:period_until,'|',\n ROW_NUMBER() OVER (ORDER BY a.data_doc,a.tip_doc,a.nr_doc,a.serie_doc,a.linktodoc_nr_doc,a.nr_lot,a.data_in,a.cant_int,a.cant_ies,a.pu,a.denumire)) AS row_key,\n CAST(:period_from AS date) AS date_from, DATEADD(day,-1,CAST(:period_until AS date)) AS date_to,\n a.tip_doc, a.nr_doc, a.data_doc,\n a.cant_int, a.cant_ies, a.um,\n a.denumire AS movement_description, a.nume_gest,\n a.nume_clasa, a.nume_subcl\nFROM dbo.raport_rulaje_stoc(\n :period_from, DATEADD(day, -1, CAST(:period_until AS date)),\n 'G', CAST(:pl_gest AS decimal(38,0)), CAST(:id_gest AS decimal(38,0)), CAST(:pl_pr AS decimal(38,0)), CAST(:id_pr AS decimal(38,0))\n) a\nWHERE a.data_doc >= :period_from AND a.data_doc < :period_until\n AND a.pl_gest = CAST(:pl_gest AS decimal(38,0)) AND a.id_gest = CAST(:id_gest AS decimal(38,0))\n AND (a.cant_int <> 0 OR a.cant_ies <> 0)\n AND UPPER(LTRIM(RTRIM(ISNULL(a.tip_doc, '')))) <> '.STOC INI.'",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "7A408249-3FE7-5A09-B046-15209DCE20BD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "DDA0C968-C5C3-5190-A7E8-D90A2D136BD5",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "DA8685DF-02D4-5BBE-AD82-5853EF5C3158",
"title": "Produsele gestiunii",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [],
"datasetID": "27CEA772-2E70-5C46-90CE-A07E59CF2AF9",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "FB685C5F-1485-5CE8-AFE1-5C51B0675E58",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "29D21788-D854-5711-A259-BD3A7286DB06",
"includeAllOption": false,
"key": "period_date",
"title": "Perioadă",
"type": "date"
},
{
"id": "E54AC030-0A7A-579D-B6CB-D4960E165E06",
"includeAllOption": true,
"key": "warehouse_name",
"title": "Gestiune",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "B8917D7E-E4B6-5C62-9667-6B050C3FA426",
"key": "warehouse_name",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "",
"systemImage": "shippingbox",
"title": "Stoc zero cu mișcare — gestiuni",
"titleKey": "warehouse_name"
},
{
"actions": [
{
"id": "71ECBB57-64B7-597C-BA7A-539C460649D9",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "12634CC8-BD0E-5901-8B04-A2173087C326",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "DD4CA9DE-3988-556B-B62E-1B67849FF3EB",
"title": "Mișcările produsului",
"urlKey": ""
}
],
"badgeKey": "current_quantity",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "unit",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "quantity_in",
"label": "Intrări în perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "quantity_out",
"label": "Ieșiri în perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "last_movement_date",
"label": "Ultima mișcare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "DA8685DF-02D4-5BBE-AD82-5853EF5C3158",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "warehouse_name",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "unit",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "product_class",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "product_subclass",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "quantity_in",
"label": "Intrări în perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "quantity_out",
"label": "Ieșiri în perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "movement_count",
"label": "Mișcări",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "first_movement_date",
"label": "Prima mișcare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "last_movement_date",
"label": "Ultima mișcare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stock_read_date",
"label": "Data citirii stocului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "1BD5AAE5-0A95-56CA-B798-F9D5BF3B0C4E",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "DF8EA000-B498-5DAD-A12F-809E2466B8F4",
"key": "product_name",
"type": "text"
},
{
"direction": "ascending",
"id": "7EB9EDD8-6AA7-5E4D-83E5-5268A490EA2D",
"key": "row_key",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "product_code",
"systemImage": "shippingbox",
"title": "Produse cu stoc zero",
"titleKey": "product_name"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"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": "um",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "DD4CA9DE-3988-556B-B62E-1B67849FF3EB",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"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": "um",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "movement_description",
"label": "Descrierea mișcării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_gest",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_clasa",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_subcl",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_from",
"label": "De la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_to",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "36C4CA24-3BB5-5EAD-9A82-FBCE2A59C30B",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
"key": "data_doc",
"type": "date"
},
{
"direction": "ascending",
"id": "7EB9EDD8-6AA7-5E4D-83E5-5268A490EA2D",
"key": "row_key",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "nr_doc",
"systemImage": "shippingbox",
"title": "Mișcările produsului",
"titleKey": "tip_doc"
}
],
"relations": [
{
"childDatasetID": "DA8685DF-02D4-5BBE-AD82-5853EF5C3158",
"childKey": "warehouse_key",
"id": "DDA0C968-C5C3-5190-A7E8-D90A2D136BD5",
"name": "Produsele gestiunii",
"parentDatasetID": "27CEA772-2E70-5C46-90CE-A07E59CF2AF9",
"parentKey": "warehouse_key"
},
{
"childDatasetID": "DD4CA9DE-3988-556B-B62E-1B67849FF3EB",
"childKey": "product_key",
"id": "12634CC8-BD0E-5901-8B04-A2173087C326",
"name": "Mișcările produsului",
"parentDatasetID": "DA8685DF-02D4-5BBE-AD82-5853EF5C3158",
"parentKey": "row_key"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-27T08:13:52Z",
"description": "Alegi perioada nativă și, opțional, filtrezi lista de gestiuni; deschizi gestiunea și apeși Produsele gestiunii. Abia atunci se execută raportul pentru acea singură gestiune. Dintr-un produs deschizi documentele lui, în aceeași perioadă. Prima listă este selectorul de gestiuni, nu un raport gol sau o scanare a întregii firme. Cheile tehnice sunt ascunse; nume, coduri, UM, clase și date sunt vizibile în carduri sau Detalii. Arată produsele cu STOC CURENT egal cu zero și cu intrări ori ieșiri reale în perioada selectată. Nu este stocul de la sfârșitul perioadei. Include și produsele cu intrări și ieșiri egale; stocul negativ nu este zero. Funcția nativă raport_rulaje_stoc citește o singură gestiune, fără stoc inițial; sel_stoc_raw verifică separat stocul curent pentru familia G, ca în Stoc pe gestiuni Pro. Nu aproximează zilele prin totaluri lunare și nu rulează o funcție separată pentru fiecare produs din lista principală. Mișcările păstrează tipul, numărul, data documentului, intrările și ieșirile. Cheia liniilor este valabilă pentru citirea curentă, nu un ID permanent Nexus. Manual stoc: https://www.docs.nexuserp.ro/articol/accesare-externa-stocuri/4487 . Citire live fără refresh global; maximum 10.000 de rânduri afișate per nivel. Pentru intervale mari restrânge perioada; totalurile se calculează înaintea limitei de afișare. Necesită Pro, iOS 1.1.0 build 336 / Android 1.1.0 build 284 sau mai nou. Funcțiile și vizualizările standard trebuie să fie accesibile contului read-only. Configurație comunitară neoficială.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "1ACDBB97-792F-5D6D-82AD-E2CF52DD6B2A",
"rootButtonCount": 1,
"summary": "Perioadă și gestiune → produse → documente, fără identificatori tehnici afișați.",
"tags": [
"NexusERP",
"stoc",
"Pro"
],
"title": "Stoc zero cu mișcare — Pro"
}
}