1468 lines
53 KiB
Plaintext
1468 lines
53 KiB
Plaintext
{
|
|
"version": "18.5.10",
|
|
"sheets": [
|
|
{
|
|
"id": "sheet1",
|
|
"name": "Dashboard",
|
|
"colNumber": 8,
|
|
"rowNumber": 85,
|
|
"rows": {
|
|
"6": { "size": 38 },
|
|
"23": { "size": 40 },
|
|
"24": { "size": 21 },
|
|
"25": { "size": 21 },
|
|
"26": { "size": 21 },
|
|
"27": { "size": 21 },
|
|
"28": { "size": 21 },
|
|
"29": { "size": 21 },
|
|
"30": { "size": 21 },
|
|
"31": { "size": 21 },
|
|
"32": { "size": 21 },
|
|
"33": { "size": 21 },
|
|
"34": { "size": 21 },
|
|
"35": { "size": 21 },
|
|
"36": { "size": 21 },
|
|
"37": { "size": 21 },
|
|
"38": { "size": 21 },
|
|
"39": { "size": 21 },
|
|
"40": { "size": 21 },
|
|
"41": { "size": 21 },
|
|
"42": { "size": 41 },
|
|
"43": { "size": 21 },
|
|
"44": { "size": 21 },
|
|
"45": { "size": 21 },
|
|
"46": { "size": 21 },
|
|
"47": { "size": 21 },
|
|
"48": { "size": 21 },
|
|
"49": { "size": 21 },
|
|
"50": { "size": 21 },
|
|
"51": { "size": 21 },
|
|
"52": { "size": 21 },
|
|
"53": { "size": 21 },
|
|
"54": { "size": 21 },
|
|
"55": { "size": 21 },
|
|
"56": { "size": 21 },
|
|
"57": { "size": 21 },
|
|
"58": { "size": 21 },
|
|
"59": { "size": 21 },
|
|
"60": { "size": 36 },
|
|
"61": { "size": 38 },
|
|
"62": { "size": 27 },
|
|
"63": { "size": 27 },
|
|
"64": { "size": 27 },
|
|
"65": { "size": 27 },
|
|
"66": { "size": 27 },
|
|
"67": { "size": 27 },
|
|
"68": { "size": 27 },
|
|
"69": { "size": 27 },
|
|
"70": { "size": 27 },
|
|
"71": { "size": 27 },
|
|
"72": { "size": 21 },
|
|
"73": { "size": 21 },
|
|
"74": { "size": 21 },
|
|
"75": { "size": 21 },
|
|
"76": { "size": 21 },
|
|
"77": { "size": 21 },
|
|
"78": { "size": 21 },
|
|
"79": { "size": 21 },
|
|
"80": { "size": 21 },
|
|
"81": { "size": 21 },
|
|
"82": { "size": 21 },
|
|
"83": { "size": 21 },
|
|
"84": { "size": 21 }
|
|
},
|
|
"cols": {
|
|
"0": { "size": 332 },
|
|
"1": { "size": 100 },
|
|
"2": { "size": 69 },
|
|
"3": { "size": 40 },
|
|
"4": { "size": 50 },
|
|
"5": { "size": 275 },
|
|
"6": { "size": 100 },
|
|
"7": { "size": 72 }
|
|
},
|
|
"merges": [],
|
|
"cells": {
|
|
"A43": "=_t(\"Ageing stock qty by product and creation date\")",
|
|
"E43": "=_t(\"Ageing stock value by product and creation date\")",
|
|
"A62": "=PIVOT(22, 10, FALSE, FALSE)"
|
|
},
|
|
"styles": {
|
|
"A6": 1,
|
|
"A7": 2,
|
|
"A24": 2,
|
|
"A43": 2,
|
|
"A61": 2,
|
|
"D7:E7": 2,
|
|
"E24": 2,
|
|
"E43": 2,
|
|
"A62": 3,
|
|
"A63:B72": 4,
|
|
"B7:C7": 5,
|
|
"B24:D24": 5,
|
|
"B43:D43": 5,
|
|
"F7:H7": 5,
|
|
"F24:H24": 5,
|
|
"F43:H43": 5,
|
|
"B61:H61": 5,
|
|
"B62": 6,
|
|
"C63:H72": 7
|
|
},
|
|
"formats": {},
|
|
"borders": { "A43:C43": 1, "E43:H43": 1, "A44:C44": 2, "E44:H44": 2 },
|
|
"conditionalFormats": [],
|
|
"dataValidationRules": [],
|
|
"figures": [
|
|
{
|
|
"id": "833374d1-d09f-4a4e-bb09-2831ceee5465",
|
|
"width": 237,
|
|
"height": 108,
|
|
"tag": "chart",
|
|
"data": {
|
|
"baselineColorDown": "#E06666",
|
|
"baselineColorUp": "#6AA84F",
|
|
"baselineMode": "text",
|
|
"title": {
|
|
"text": "Share reserved stock Value",
|
|
"align": "left",
|
|
"bold": true,
|
|
"color": "#434343"
|
|
},
|
|
"type": "scorecard",
|
|
"background": "#ECFDF5",
|
|
"baseline": "Data!E4",
|
|
"keyValue": "Data!B4",
|
|
"humanize": false,
|
|
"chartId": "833374d1-d09f-4a4e-bb09-2831ceee5465"
|
|
},
|
|
"offset": { "x": 246, "y": 9 },
|
|
"col": 0,
|
|
"row": 0
|
|
},
|
|
{
|
|
"id": "de7010e1-2cdc-4e19-a1de-1c7fd4795bf4",
|
|
"width": 237,
|
|
"height": 108,
|
|
"tag": "chart",
|
|
"data": {
|
|
"baselineColorDown": "#E06666",
|
|
"baselineColorUp": "#6AA84F",
|
|
"baselineMode": "text",
|
|
"title": {
|
|
"text": "Share reserved stock Qty",
|
|
"align": "left",
|
|
"bold": true,
|
|
"color": "#434343"
|
|
},
|
|
"type": "scorecard",
|
|
"background": "#ECFDF5",
|
|
"baseline": "Data!E3",
|
|
"keyValue": "Data!B3",
|
|
"humanize": false,
|
|
"chartId": "de7010e1-2cdc-4e19-a1de-1c7fd4795bf4"
|
|
},
|
|
"offset": { "x": 0, "y": 9 },
|
|
"col": 0,
|
|
"row": 0
|
|
},
|
|
{
|
|
"id": "fad86b76-037f-4b7f-8afc-bc028c2536de",
|
|
"width": 500,
|
|
"height": 335,
|
|
"tag": "chart",
|
|
"data": {
|
|
"title": { "text": "" },
|
|
"background": "#FFFFFF",
|
|
"legendPosition": "none",
|
|
"metaData": {
|
|
"groupBy": ["create_date:quarter", "product_id"],
|
|
"measure": "quantity",
|
|
"order": null,
|
|
"resModel": "stock.quant",
|
|
"mode": "bar"
|
|
},
|
|
"searchParams": {
|
|
"comparison": null,
|
|
"context": {
|
|
"mail_notify_force_send": false,
|
|
"always_show_loc": 1,
|
|
"inventory_mode": true,
|
|
"inventory_report_mode": true
|
|
},
|
|
"domain": [
|
|
["location_id.usage", "=", "internal"]
|
|
],
|
|
"groupBy": ["create_date:quarter", "product_id"],
|
|
"orderBy": []
|
|
},
|
|
"type": "odoo_bar",
|
|
"dataSets": [
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{}
|
|
],
|
|
"verticalAxisPosition": "left",
|
|
"stacked": true,
|
|
"axesDesign": {
|
|
"x": {
|
|
"title": { "text": "Creation Date" }
|
|
},
|
|
"y": {
|
|
"title": { "text": "Stock Quantity" }
|
|
}
|
|
},
|
|
"chartId": "fad86b76-037f-4b7f-8afc-bc028c2536de",
|
|
"fieldMatching": {
|
|
"feeb0d08-4596-4e7c-b478-a3c659189cdd": { "chain": "warehouse_id", "type": "many2one" },
|
|
"62f6d1bd-9c76-48d7-b95a-3f5d6cb505df": { "chain": "location_id", "type": "many2one" },
|
|
"7ff87378-db1d-4725-bf25-6eee704b15a5": { "chain": "product_categ_id", "type": "many2one" },
|
|
"8dea5478-ff09-41fc-ada0-cf23c66e4f8b": { "chain": "product_id", "type": "many2one" },
|
|
"0725cf6d-c980-46a1-bd7b-bd75e34348e7": { "chain": "lot_id", "type": "many2one" }
|
|
}
|
|
},
|
|
"offset": { "x": 0, "y": 0 },
|
|
"col": 0,
|
|
"row": 43
|
|
},
|
|
{
|
|
"id": "73f61914-d895-4484-b3ba-585107daeb44",
|
|
"width": 498,
|
|
"height": 335,
|
|
"tag": "chart",
|
|
"data": {
|
|
"title": { "text": "" },
|
|
"background": "#FFFFFF",
|
|
"legendPosition": "none",
|
|
"metaData": {
|
|
"groupBy": ["create_date:quarter", "product_id"],
|
|
"measure": "value",
|
|
"order": null,
|
|
"resModel": "stock.quant",
|
|
"mode": "bar"
|
|
},
|
|
"searchParams": {
|
|
"comparison": null,
|
|
"context": {
|
|
"mail_notify_force_send": false,
|
|
"always_show_loc": 1,
|
|
"inventory_mode": true,
|
|
"inventory_report_mode": true
|
|
},
|
|
"domain": [
|
|
["location_id.usage", "=", "internal"]
|
|
],
|
|
"groupBy": ["create_date:quarter", "product_id"],
|
|
"orderBy": []
|
|
},
|
|
"type": "odoo_bar",
|
|
"dataSets": [
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{},
|
|
{}
|
|
],
|
|
"verticalAxisPosition": "left",
|
|
"stacked": true,
|
|
"axesDesign": {
|
|
"x": {
|
|
"title": { "text": "Creation Date" }
|
|
},
|
|
"y": {
|
|
"title": { "text": "Stock Value" }
|
|
}
|
|
},
|
|
"chartId": "73f61914-d895-4484-b3ba-585107daeb44",
|
|
"fieldMatching": {
|
|
"feeb0d08-4596-4e7c-b478-a3c659189cdd": { "chain": "warehouse_id", "type": "many2one" },
|
|
"62f6d1bd-9c76-48d7-b95a-3f5d6cb505df": { "chain": "location_id", "type": "many2one" },
|
|
"7ff87378-db1d-4725-bf25-6eee704b15a5": { "chain": "product_categ_id", "type": "many2one" },
|
|
"8dea5478-ff09-41fc-ada0-cf23c66e4f8b": { "chain": "product_id", "type": "many2one" },
|
|
"0725cf6d-c980-46a1-bd7b-bd75e34348e7": { "chain": "lot_id", "type": "many2one" }
|
|
}
|
|
},
|
|
"offset": { "x": 36, "y": 0 },
|
|
"col": 3,
|
|
"row": 43
|
|
},
|
|
{
|
|
"id": "639d221d-d74d-4762-984e-9debac4f5a82",
|
|
"width": 237,
|
|
"height": 108,
|
|
"tag": "chart",
|
|
"data": {
|
|
"baselineColorDown": "#E06666",
|
|
"baselineColorUp": "#6AA84F",
|
|
"baselineMode": "difference",
|
|
"title": {
|
|
"text": "Lines with negative stock",
|
|
"bold": true,
|
|
"align": "left",
|
|
"color": "#434343"
|
|
},
|
|
"type": "scorecard",
|
|
"background": "#EFF6FF",
|
|
"keyValue": "Data!B5",
|
|
"humanize": true,
|
|
"chartId": "639d221d-d74d-4762-984e-9debac4f5a82"
|
|
},
|
|
"offset": { "x": 492, "y": 9 },
|
|
"col": 0,
|
|
"row": 0
|
|
},
|
|
{
|
|
"id": "b2df71e9-7cf7",
|
|
"col": 0,
|
|
"row": 61,
|
|
"offset": { "x": 0, "y": 0 },
|
|
"width": 500,
|
|
"height": 314,
|
|
"tag": "carousel",
|
|
"data": {
|
|
"chartDefinitions": {
|
|
"07303ff1-4288": {
|
|
"type": "sunburst",
|
|
"dataSetsHaveTitle": false,
|
|
"dataSets": [
|
|
{ "dataRange": "A63:A72" }
|
|
],
|
|
"legendPosition": "none",
|
|
"labelRange": "B63:B72",
|
|
"title": {},
|
|
"humanize": true
|
|
}
|
|
},
|
|
"items": [
|
|
{ "type": "chart", "chartId": "07303ff1-4288", "title": "Chart" },
|
|
{ "type": "carouselDataView", "title": "Top 10" }
|
|
],
|
|
"fieldMatching": {},
|
|
"title": {
|
|
"text": "Top 10 products with negative stock",
|
|
"bold": true,
|
|
"fontSize": 21,
|
|
"color": "#01666B"
|
|
}
|
|
}
|
|
},
|
|
{
|
|
"id": "01127dd6-be32",
|
|
"col": 0,
|
|
"row": 6,
|
|
"offset": { "x": 0, "y": 11 },
|
|
"width": 1035,
|
|
"height": 372,
|
|
"tag": "carousel",
|
|
"data": {
|
|
"chartDefinitions": {
|
|
"0d527983-ee0f-44cb-af82-f637574a4e1e": {
|
|
"type": "bar",
|
|
"dataSetsHaveTitle": true,
|
|
"dataSets": [
|
|
{ "dataRange": "'Stock location Qty'!B1:B11" },
|
|
{ "dataRange": "'Stock location Qty'!C1:C11" }
|
|
],
|
|
"legendPosition": "top",
|
|
"labelRange": "'Stock location Qty'!A1:A11",
|
|
"title": {},
|
|
"stacked": true,
|
|
"aggregated": false,
|
|
"axesDesign": {
|
|
"x": {
|
|
"title": { "text": "Top Locations" }
|
|
},
|
|
"y": {
|
|
"title": { "text": "Stock Quantity" }
|
|
}
|
|
},
|
|
"humanize": true
|
|
},
|
|
"e7f90aaf-95ec-4f1d-9b0c-ec7e4465d772": {
|
|
"type": "bar",
|
|
"dataSetsHaveTitle": true,
|
|
"dataSets": [
|
|
{ "dataRange": "'Stock location Qty'!F1:F11" },
|
|
{ "dataRange": "'Stock location Qty'!G1:G11" }
|
|
],
|
|
"legendPosition": "top",
|
|
"labelRange": "'Stock location Qty'!E1:E11",
|
|
"title": {},
|
|
"stacked": true,
|
|
"aggregated": false,
|
|
"axesDesign": {
|
|
"x": {
|
|
"title": { "text": "Top Products" }
|
|
},
|
|
"y": {
|
|
"title": { "text": "Stock Quantity" }
|
|
}
|
|
},
|
|
"humanize": true
|
|
}
|
|
},
|
|
"items": [
|
|
{
|
|
"type": "chart",
|
|
"chartId": "0d527983-ee0f-44cb-af82-f637574a4e1e",
|
|
"title": "Top Locations"
|
|
},
|
|
{
|
|
"type": "chart",
|
|
"chartId": "e7f90aaf-95ec-4f1d-9b0c-ec7e4465d772",
|
|
"title": "Top Products"
|
|
}
|
|
],
|
|
"fieldMatching": {},
|
|
"title": {
|
|
"text": "Available & Reserved Stock Quantity",
|
|
"bold": true,
|
|
"fontSize": 21,
|
|
"color": "#01666B"
|
|
}
|
|
}
|
|
},
|
|
{
|
|
"id": "c8d9f32a-11d4",
|
|
"col": 0,
|
|
"row": 23,
|
|
"offset": { "x": 0, "y": 10 },
|
|
"width": 1035,
|
|
"height": 388,
|
|
"tag": "carousel",
|
|
"data": {
|
|
"chartDefinitions": {
|
|
"8324b219-c649-4392-9fee-a3e7f396d70c": {
|
|
"type": "bar",
|
|
"dataSetsHaveTitle": true,
|
|
"dataSets": [
|
|
{ "dataRange": "'Stock location Value'!B1:B12" },
|
|
{ "dataRange": "'Stock location Value'!C1:C12" }
|
|
],
|
|
"legendPosition": "top",
|
|
"labelRange": "'Stock location Value'!A1:A12",
|
|
"title": {},
|
|
"stacked": true,
|
|
"aggregated": false,
|
|
"axesDesign": {
|
|
"x": {
|
|
"title": { "text": "Top Locations" }
|
|
},
|
|
"y": {
|
|
"title": { "text": "Stock Value" }
|
|
}
|
|
},
|
|
"humanize": true
|
|
},
|
|
"ebde3556-983a-475a-95f0-4edb2515b3bb": {
|
|
"type": "bar",
|
|
"dataSetsHaveTitle": true,
|
|
"dataSets": [
|
|
{ "dataRange": "'Stock location Value'!I1:I11" },
|
|
{ "dataRange": "'Stock location Value'!J1:J11" }
|
|
],
|
|
"legendPosition": "top",
|
|
"labelRange": "'Stock location Value'!H1:H11",
|
|
"title": {},
|
|
"stacked": true,
|
|
"aggregated": false,
|
|
"axesDesign": {
|
|
"x": {
|
|
"title": { "text": "Top Products" }
|
|
},
|
|
"y": {
|
|
"title": { "text": "Stock Value" }
|
|
}
|
|
},
|
|
"humanize": true
|
|
}
|
|
},
|
|
"items": [
|
|
{
|
|
"type": "chart",
|
|
"chartId": "8324b219-c649-4392-9fee-a3e7f396d70c",
|
|
"title": "Top Locations"
|
|
},
|
|
{
|
|
"type": "chart",
|
|
"chartId": "ebde3556-983a-475a-95f0-4edb2515b3bb",
|
|
"title": "Top Products"
|
|
}
|
|
],
|
|
"fieldMatching": {},
|
|
"title": {
|
|
"text": "Available & Reserved Stock Value",
|
|
"bold": true,
|
|
"fontSize": 21,
|
|
"color": "#01666B"
|
|
}
|
|
}
|
|
}
|
|
],
|
|
"tables": [
|
|
{
|
|
"range": "A61:B72",
|
|
"type": "static",
|
|
"config": {
|
|
"hasFilters": false,
|
|
"totalRow": false,
|
|
"firstColumn": false,
|
|
"lastColumn": false,
|
|
"numberOfHeaders": 1,
|
|
"bandedRows": true,
|
|
"bandedColumns": false,
|
|
"automaticAutofill": true,
|
|
"styleId": "None"
|
|
}
|
|
},
|
|
{
|
|
"range": "A61:C72",
|
|
"type": "static",
|
|
"config": {
|
|
"hasFilters": false,
|
|
"totalRow": false,
|
|
"firstColumn": false,
|
|
"lastColumn": false,
|
|
"numberOfHeaders": 1,
|
|
"bandedRows": true,
|
|
"bandedColumns": false,
|
|
"automaticAutofill": true,
|
|
"styleId": "None"
|
|
}
|
|
}
|
|
],
|
|
"areGridLinesVisible": true,
|
|
"isVisible": true,
|
|
"headerGroups": {
|
|
"ROW": [],
|
|
"COL": []
|
|
},
|
|
"comments": {}
|
|
},
|
|
{
|
|
"id": "fb6d5d91-04cf-4c22-953a-a00c4e8f19e4",
|
|
"name": "Data",
|
|
"colNumber": 22,
|
|
"rowNumber": 82,
|
|
"rows": {},
|
|
"cols": {
|
|
"0": { "size": 227 },
|
|
"1": { "size": 136 },
|
|
"2": { "size": 111 },
|
|
"3": { "size": 113 },
|
|
"4": { "size": 205 },
|
|
"6": { "size": 107 }
|
|
},
|
|
"merges": [],
|
|
"cells": {
|
|
"A1": "=_t(\"KPI\")",
|
|
"A2": "=_t(\"Total inventory value\")",
|
|
"A3": "Share of reserved stock qty",
|
|
"A4": "Share of reserved stock Value",
|
|
"A5": "Count of products with negative stock",
|
|
"B2": "=FORMAT.LARGE.NUMBER(PIVOT.VALUE(20,\"value\"))",
|
|
"B3": "=iferror(PIVOT.VALUE(20,\"reserved_quantity\")/PIVOT.VALUE(20,\"quantity\"),\"No data\")",
|
|
"B4": "=IFERROR(C4/D4,\"No data\")",
|
|
"B5": "=PIVOT.VALUE(22,\"__count\")",
|
|
"C1": "Reserved",
|
|
"C3": "=PIVOT.VALUE(20,\"reserved_quantity\")",
|
|
"C4": "=IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(18,\"value\")/PIVOT.VALUE(18,\"quantity\"))*PIVOT.VALUE(18,\"reserved_quantity\")),\"No data\")",
|
|
"D1": "Total",
|
|
"D3": "=PIVOT.VALUE(20,\"quantity\")",
|
|
"D4": "=FORMAT.LARGE.NUMBER(PIVOT.VALUE(20,\"value\"))",
|
|
"E3": "=TEXT(C3,\"#,##0\")&\" out of \" &TEXT(D3,\"#,##0\")",
|
|
"E4": "=Iferror(TEXT(C4,\"#,##0\")&\" out of \" &TEXT(D4,\"#,##0\"),\"No data\")"
|
|
},
|
|
"styles": { "A1:D1": 8, "A2:A5": 9 },
|
|
"formats": { "B3:B4": 1, "B5:C5": 2 },
|
|
"borders": {},
|
|
"conditionalFormats": [],
|
|
"dataValidationRules": [],
|
|
"figures": [],
|
|
"tables": [],
|
|
"areGridLinesVisible": true,
|
|
"isVisible": true,
|
|
"headerGroups": {
|
|
"ROW": [],
|
|
"COL": []
|
|
},
|
|
"comments": {}
|
|
},
|
|
{
|
|
"id": "ff7cd299-81f4-49db-a27a-66bf36420f0d",
|
|
"name": "Stock location Qty",
|
|
"colNumber": 12,
|
|
"rowNumber": 99,
|
|
"rows": {},
|
|
"cols": {
|
|
"0": { "size": 134 },
|
|
"1": { "size": 112 },
|
|
"2": { "size": 115 },
|
|
"3": { "size": 55 },
|
|
"4": { "size": 316 },
|
|
"5": { "size": 112 },
|
|
"6": { "size": 115 }
|
|
},
|
|
"merges": [],
|
|
"cells": {
|
|
"A1": "Location",
|
|
"A2": "=PIVOT.HEADER(8,\"#location_id\",1)",
|
|
"A3": "=PIVOT.HEADER(8,\"#location_id\",2)",
|
|
"A4": "=PIVOT.HEADER(8,\"#location_id\",3)",
|
|
"A5": "=PIVOT.HEADER(8,\"#location_id\",4)",
|
|
"A6": "=PIVOT.HEADER(8,\"#location_id\",5)",
|
|
"A7": "=PIVOT.HEADER(8,\"#location_id\",6)",
|
|
"A8": "=PIVOT.HEADER(8,\"#location_id\",7)",
|
|
"A9": "=PIVOT.HEADER(8,\"#location_id\",8)",
|
|
"A10": "=PIVOT.HEADER(8,\"#location_id\",9)",
|
|
"A11": "=PIVOT.HEADER(8,\"#location_id\",10)",
|
|
"B1": "=PIVOT.HEADER(9,\"measure\",\"available_quantity\")",
|
|
"B2": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",1)",
|
|
"B3": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",2)",
|
|
"B4": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",3)",
|
|
"B5": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",4)",
|
|
"B6": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",5)",
|
|
"B7": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",6)",
|
|
"B8": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",7)",
|
|
"B9": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",8)",
|
|
"B10": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",9)",
|
|
"B11": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",10)",
|
|
"C1": "=PIVOT.HEADER(9,\"measure\",\"reserved_quantity\")",
|
|
"C2": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",1)",
|
|
"C3": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",2)",
|
|
"C4": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",3)",
|
|
"C5": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",4)",
|
|
"C6": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",5)",
|
|
"C7": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",6)",
|
|
"C8": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",7)",
|
|
"C9": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",8)",
|
|
"C10": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",9)",
|
|
"C11": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",10)",
|
|
"E2": "=PIVOT.HEADER(9,\"#product_id\",1)",
|
|
"E3": "=PIVOT.HEADER(9,\"#product_id\",2)",
|
|
"E4": "=PIVOT.HEADER(9,\"#product_id\",3)",
|
|
"E5": "=PIVOT.HEADER(9,\"#product_id\",4)",
|
|
"E6": "=PIVOT.HEADER(9,\"#product_id\",5)",
|
|
"E7": "=PIVOT.HEADER(9,\"#product_id\",6)",
|
|
"E8": "=PIVOT.HEADER(9,\"#product_id\",7)",
|
|
"E9": "=PIVOT.HEADER(9,\"#product_id\",8)",
|
|
"E10": "=PIVOT.HEADER(9,\"#product_id\",9)",
|
|
"E11": "=PIVOT.HEADER(9,\"#product_id\",10)",
|
|
"F1": "=PIVOT.HEADER(9,\"measure\",\"available_quantity\")",
|
|
"F2": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",1)",
|
|
"F3": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",2)",
|
|
"F4": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",3)",
|
|
"F5": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",4)",
|
|
"F6": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",5)",
|
|
"F7": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",6)",
|
|
"F8": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",7)",
|
|
"F9": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",8)",
|
|
"F10": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",9)",
|
|
"F11": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",10)",
|
|
"G1": "=PIVOT.HEADER(9,\"measure\",\"reserved_quantity\")",
|
|
"G2": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",1)",
|
|
"G3": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",2)",
|
|
"G4": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",3)",
|
|
"G5": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",4)",
|
|
"G6": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",5)",
|
|
"G7": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",6)",
|
|
"G8": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",7)",
|
|
"G9": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",8)",
|
|
"G10": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",9)",
|
|
"G11": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",10)"
|
|
},
|
|
"styles": {},
|
|
"formats": { "F2:G12": 2 },
|
|
"borders": {},
|
|
"conditionalFormats": [],
|
|
"dataValidationRules": [],
|
|
"figures": [],
|
|
"tables": [
|
|
{
|
|
"range": "A1:C11",
|
|
"type": "static",
|
|
"config": {
|
|
"hasFilters": false,
|
|
"totalRow": false,
|
|
"firstColumn": true,
|
|
"lastColumn": false,
|
|
"numberOfHeaders": 1,
|
|
"bandedRows": true,
|
|
"bandedColumns": false,
|
|
"styleId": "TableStyleMedium5"
|
|
}
|
|
},
|
|
{
|
|
"range": "E1:G11",
|
|
"type": "static",
|
|
"config": {
|
|
"hasFilters": false,
|
|
"totalRow": false,
|
|
"firstColumn": true,
|
|
"lastColumn": false,
|
|
"numberOfHeaders": 1,
|
|
"bandedRows": true,
|
|
"bandedColumns": false,
|
|
"styleId": "TableStyleMedium5"
|
|
}
|
|
}
|
|
],
|
|
"areGridLinesVisible": true,
|
|
"isVisible": true,
|
|
"headerGroups": {
|
|
"ROW": [],
|
|
"COL": []
|
|
},
|
|
"comments": {}
|
|
},
|
|
{
|
|
"id": "b87c927f-558d-4244-b0e0-76f0cc2e3467",
|
|
"name": "Stock location Value",
|
|
"colNumber": 28,
|
|
"rowNumber": 99,
|
|
"rows": {},
|
|
"cols": {
|
|
"0": { "size": 113 },
|
|
"1": { "size": 98 },
|
|
"2": { "size": 97 },
|
|
"3": { "size": 72 },
|
|
"4": { "size": 72 },
|
|
"5": { "size": 115 },
|
|
"6": { "size": 92 },
|
|
"7": { "size": 207 },
|
|
"8": { "size": 139 },
|
|
"9": { "size": 139 },
|
|
"10": { "size": 139 },
|
|
"11": { "size": 139 },
|
|
"12": { "size": 139 },
|
|
"13": { "size": 139 },
|
|
"14": { "size": 139 },
|
|
"15": { "size": 139 },
|
|
"16": { "size": 139 },
|
|
"17": { "size": 139 },
|
|
"18": { "size": 139 },
|
|
"19": { "size": 139 },
|
|
"20": { "size": 139 },
|
|
"21": { "size": 139 },
|
|
"22": { "size": 139 },
|
|
"23": { "size": 139 },
|
|
"24": { "size": 139 },
|
|
"25": { "size": 139 },
|
|
"26": { "size": 139 },
|
|
"27": { "size": 139 }
|
|
},
|
|
"merges": [],
|
|
"cells": {
|
|
"A2": "=PIVOT.HEADER(21,\"#location_id\",row()-1)",
|
|
"A3": "=PIVOT.HEADER(21,\"#location_id\",row()-1)",
|
|
"A4": "=PIVOT.HEADER(21,\"#location_id\",row()-1)",
|
|
"A5": "=PIVOT.HEADER(21,\"#location_id\",row()-1)",
|
|
"A6": "=PIVOT.HEADER(21,\"#location_id\",row()-1)",
|
|
"A7": "=PIVOT.HEADER(21,\"#location_id\",row()-1)",
|
|
"A8": "=PIVOT.HEADER(21,\"#location_id\",row()-1)",
|
|
"A9": "=PIVOT.HEADER(21,\"#location_id\",row()-1)",
|
|
"A10": "=PIVOT.HEADER(21,\"#location_id\",row()-1)",
|
|
"A11": "=PIVOT.HEADER(21,\"#location_id\",row()-1)",
|
|
"A12": "=PIVOT.HEADER(21,\"#location_id\",row()-1)",
|
|
"B1": "Available Value",
|
|
"B2": "=if(D2<>\"\",D2-C2,\"\")",
|
|
"B3": "=if(D3<>\"\",D3-C3,\"\")",
|
|
"B4": "=if(D4<>\"\",D4-C4,\"\")",
|
|
"B5": "=if(D5<>\"\",D5-C5,\"\")",
|
|
"B6": "=if(D6<>\"\",D6-C6,\"\")",
|
|
"B7": "=if(D7<>\"\",D7-C7,\"\")",
|
|
"B8": "=if(D8<>\"\",D8-C8,\"\")",
|
|
"B9": "=if(D9<>\"\",D9-C9,\"\")",
|
|
"B10": "=if(D10<>\"\",D10-C10,\"\")",
|
|
"B11": "=if(D11<>\"\",D11-C11,\"\")",
|
|
"B12": "=if(D12<>\"\",D12-C12,\"\")",
|
|
"C1": "Reserved value",
|
|
"C2": "=if( AND(F2>0,A2<>\"\"), IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(23,\"value\",\"#location_id\",row()-1)/PIVOT.VALUE(23,\"quantity\",\"#location_id\",row()-1))*PIVOT.VALUE(23,\"reserved_quantity\",\"#location_id\",row()-1)),\"No data\"),\"\")",
|
|
"C3": "=if( AND(F3>0,A3<>\"\"), IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(23,\"value\",\"#location_id\",row()-1)/PIVOT.VALUE(23,\"quantity\",\"#location_id\",row()-1))*PIVOT.VALUE(23,\"reserved_quantity\",\"#location_id\",row()-1)),\"No data\"),\"\")",
|
|
"C4": "=if( AND(F4>0,A4<>\"\"), IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(23,\"value\",\"#location_id\",row()-1)/PIVOT.VALUE(23,\"quantity\",\"#location_id\",row()-1))*PIVOT.VALUE(23,\"reserved_quantity\",\"#location_id\",row()-1)),\"No data\"),\"\")",
|
|
"C5": "=if( AND(F5>0,A5<>\"\"), IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(23,\"value\",\"#location_id\",row()-1)/PIVOT.VALUE(23,\"quantity\",\"#location_id\",row()-1))*PIVOT.VALUE(23,\"reserved_quantity\",\"#location_id\",row()-1)),\"No data\"),\"\")",
|
|
"C6": "=if( AND(F6>0,A6<>\"\"), IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(23,\"value\",\"#location_id\",row()-1)/PIVOT.VALUE(23,\"quantity\",\"#location_id\",row()-1))*PIVOT.VALUE(23,\"reserved_quantity\",\"#location_id\",row()-1)),\"No data\"),\"\")",
|
|
"C7": "=if( AND(F7>0,A7<>\"\"), IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(23,\"value\",\"#location_id\",row()-1)/PIVOT.VALUE(23,\"quantity\",\"#location_id\",row()-1))*PIVOT.VALUE(23,\"reserved_quantity\",\"#location_id\",row()-1)),\"No data\"),\"\")",
|
|
"C8": "=if( AND(F8>0,A8<>\"\"), IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(23,\"value\",\"#location_id\",row()-1)/PIVOT.VALUE(23,\"quantity\",\"#location_id\",row()-1))*PIVOT.VALUE(23,\"reserved_quantity\",\"#location_id\",row()-1)),\"No data\"),\"\")",
|
|
"C9": "=if( AND(F9>0,A9<>\"\"), IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(23,\"value\",\"#location_id\",row()-1)/PIVOT.VALUE(23,\"quantity\",\"#location_id\",row()-1))*PIVOT.VALUE(23,\"reserved_quantity\",\"#location_id\",row()-1)),\"No data\"),\"\")",
|
|
"C10": "=if( AND(F10>0,A10<>\"\"), IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(23,\"value\",\"#location_id\",row()-1)/PIVOT.VALUE(23,\"quantity\",\"#location_id\",row()-1))*PIVOT.VALUE(23,\"reserved_quantity\",\"#location_id\",row()-1)),\"No data\"),\"\")",
|
|
"C11": "=if( AND(F11>0,A11<>\"\"), IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(23,\"value\",\"#location_id\",row()-1)/PIVOT.VALUE(23,\"quantity\",\"#location_id\",row()-1))*PIVOT.VALUE(23,\"reserved_quantity\",\"#location_id\",row()-1)),\"No data\"),\"\")",
|
|
"C12": "=if( AND(F12>0,A12<>\"\"), IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(23,\"value\",\"#location_id\",row()-1)/PIVOT.VALUE(23,\"quantity\",\"#location_id\",row()-1))*PIVOT.VALUE(23,\"reserved_quantity\",\"#location_id\",row()-1)),\"No data\"),\"\")",
|
|
"D1": "=PIVOT.HEADER(21,\"measure\",\"value\")",
|
|
"D2": "=PIVOT.VALUE(21,\"value\",\"#location_id\",1)",
|
|
"D3": "=PIVOT.VALUE(21,\"value\",\"#location_id\",2)",
|
|
"D4": "=PIVOT.VALUE(21,\"value\",\"#location_id\",3)",
|
|
"D5": "=PIVOT.VALUE(21,\"value\",\"#location_id\",4)",
|
|
"D6": "=PIVOT.VALUE(21,\"value\",\"#location_id\",5)",
|
|
"D7": "=PIVOT.VALUE(21,\"value\",\"#location_id\",6)",
|
|
"D8": "=PIVOT.VALUE(21,\"value\",\"#location_id\",7)",
|
|
"D9": "=PIVOT.VALUE(21,\"value\",\"#location_id\",8)",
|
|
"D10": "=PIVOT.VALUE(21,\"value\",\"#location_id\",9)",
|
|
"D11": "=PIVOT.VALUE(21,\"value\",\"#location_id\",10)",
|
|
"D12": "=PIVOT.VALUE(21,\"value\",\"#location_id\",11)",
|
|
"E1": "=PIVOT.HEADER(21,\"measure\",\"quantity\")",
|
|
"E2": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",1)",
|
|
"E3": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",2)",
|
|
"E4": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",3)",
|
|
"E5": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",4)",
|
|
"E6": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",5)",
|
|
"E7": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",6)",
|
|
"E8": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",7)",
|
|
"E9": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",8)",
|
|
"E10": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",9)",
|
|
"E11": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",10)",
|
|
"E12": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",11)",
|
|
"F1": "=PIVOT.HEADER(21,\"measure\",\"reserved_quantity\")",
|
|
"F2": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",1)",
|
|
"F3": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",2)",
|
|
"F4": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",3)",
|
|
"F5": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",4)",
|
|
"F6": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",5)",
|
|
"F7": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",6)",
|
|
"F8": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",7)",
|
|
"F9": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",8)",
|
|
"F10": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",9)",
|
|
"F11": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",10)",
|
|
"F12": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",11)",
|
|
"H2": "=PIVOT.HEADER(20,\"#product_id\",1)",
|
|
"H3": "=PIVOT.HEADER(20,\"#product_id\",2)",
|
|
"H4": "=PIVOT.HEADER(20,\"#product_id\",3)",
|
|
"H5": "=PIVOT.HEADER(20,\"#product_id\",4)",
|
|
"H6": "=PIVOT.HEADER(20,\"#product_id\",5)",
|
|
"H7": "=PIVOT.HEADER(20,\"#product_id\",6)",
|
|
"H8": "=PIVOT.HEADER(20,\"#product_id\",7)",
|
|
"H9": "=PIVOT.HEADER(20,\"#product_id\",8)",
|
|
"H10": "=PIVOT.HEADER(20,\"#product_id\",9)",
|
|
"H11": "=PIVOT.HEADER(20,\"#product_id\",10)",
|
|
"I1": "Available Value",
|
|
"I2": "=if(K2<>\"\",K2-J2,\"\")",
|
|
"I3": "=if(K3<>\"\",K3-J3,\"\")",
|
|
"I4": "=if(K4<>\"\",K4-J4,\"\")",
|
|
"I5": "=if(K5<>\"\",K5-J5,\"\")",
|
|
"I6": "=if(K6<>\"\",K6-J6,\"\")",
|
|
"I7": "=if(K7<>\"\",K7-J7,\"\")",
|
|
"I8": "=if(K8<>\"\",K8-J8,\"\")",
|
|
"I9": "=if(K9<>\"\",K9-J9,\"\")",
|
|
"I10": "=if(K10<>\"\",K10-J10,\"\")",
|
|
"I11": "=if(K11<>\"\",K11-J11,\"\")",
|
|
"J1": "Reserved value",
|
|
"J2": "=(M2/L2)*K2",
|
|
"J3": "=(M3/L3)*K3",
|
|
"J4": "=(M4/L4)*K4",
|
|
"J5": "=(M5/L5)*K5",
|
|
"J6": "=(M6/L6)*K6",
|
|
"J7": "=(M7/L7)*K7",
|
|
"J8": "=(M8/L8)*K8",
|
|
"J9": "=(M9/L9)*K9",
|
|
"J10": "=(M10/L10)*K10",
|
|
"J11": "=(M11/L11)*K11",
|
|
"K1": "=PIVOT.HEADER(20,\"measure\",\"value\")",
|
|
"K2": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)",
|
|
"K3": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)",
|
|
"K4": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)",
|
|
"K5": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)",
|
|
"K6": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)",
|
|
"K7": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)",
|
|
"K8": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)",
|
|
"K9": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)",
|
|
"K10": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)",
|
|
"K11": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)",
|
|
"L1": "=PIVOT.HEADER(20,\"measure\",\"quantity\")",
|
|
"L2": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",1)",
|
|
"L3": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",2)",
|
|
"L4": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",3)",
|
|
"L5": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",4)",
|
|
"L6": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",5)",
|
|
"L7": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",6)",
|
|
"L8": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",7)",
|
|
"L9": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",8)",
|
|
"L10": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",9)",
|
|
"L11": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",10)",
|
|
"M1": "=PIVOT.HEADER(20,\"measure\",\"reserved_quantity\")",
|
|
"M2": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",1)",
|
|
"M3": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",2)",
|
|
"M4": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",3)",
|
|
"M5": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",4)",
|
|
"M6": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",5)",
|
|
"M7": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",6)",
|
|
"M8": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",7)",
|
|
"M9": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",8)",
|
|
"M10": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",9)",
|
|
"M11": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",10)"
|
|
},
|
|
"styles": {},
|
|
"formats": { "D4:E11": 2, "B2:B3": 3, "C2:C12": 3, "D2:F3": 3, "J2:J11": 3 },
|
|
"borders": {},
|
|
"conditionalFormats": [],
|
|
"dataValidationRules": [],
|
|
"figures": [],
|
|
"tables": [
|
|
{
|
|
"range": "H1:M11",
|
|
"type": "static",
|
|
"config": {
|
|
"hasFilters": false,
|
|
"totalRow": false,
|
|
"firstColumn": true,
|
|
"lastColumn": false,
|
|
"numberOfHeaders": 1,
|
|
"bandedRows": true,
|
|
"bandedColumns": false,
|
|
"styleId": "TableStyleMedium5"
|
|
}
|
|
},
|
|
{
|
|
"range": "A1:F12",
|
|
"type": "static",
|
|
"config": {
|
|
"hasFilters": false,
|
|
"totalRow": false,
|
|
"firstColumn": true,
|
|
"lastColumn": false,
|
|
"numberOfHeaders": 1,
|
|
"bandedRows": true,
|
|
"bandedColumns": false,
|
|
"styleId": "TableStyleMedium5"
|
|
}
|
|
}
|
|
],
|
|
"areGridLinesVisible": true,
|
|
"isVisible": true,
|
|
"headerGroups": {
|
|
"ROW": [],
|
|
"COL": []
|
|
},
|
|
"comments": {}
|
|
}
|
|
],
|
|
"styles": {
|
|
"1": { "fontSize": 14, "textColor": "#01666B", "bold": true },
|
|
"2": { "fontSize": 16, "textColor": "#01666B", "bold": true },
|
|
"3": { "textColor": "#434343", "bold": true, "fontSize": 11 },
|
|
"4": { "verticalAlign": "middle", "textColor": "#434343" },
|
|
"5": { "fontSize": 16 },
|
|
"6": {
|
|
"textColor": "#434343",
|
|
"bold": true,
|
|
"fontSize": 11,
|
|
"align": "center"
|
|
},
|
|
"7": { "verticalAlign": "middle" },
|
|
"8": { "bold": true, "fillColor": "#E6F2F3" },
|
|
"9": { "fillColor": "#E6F2F3" }
|
|
},
|
|
"formats": { "1": "0.00%", "2": "#,##0.00", "3": "#,##0" },
|
|
"borders": {
|
|
"1": {
|
|
"bottom": { "style": "thin", "color": "#CCCCCC" }
|
|
},
|
|
"2": {
|
|
"top": { "style": "thin", "color": "#CCCCCC" }
|
|
}
|
|
},
|
|
"revisionId": "START_REVISION",
|
|
"uniqueFigureIds": true,
|
|
"settings": {
|
|
"locale": {
|
|
"name": "English (US)",
|
|
"code": "en_US",
|
|
"thousandsSeparator": ",",
|
|
"decimalSeparator": ".",
|
|
"dateFormat": "mm/dd/yyyy",
|
|
"timeFormat": "hh:mm:ss",
|
|
"formulaArgSeparator": ",",
|
|
"weekStart": 7
|
|
}
|
|
},
|
|
"pivots": {
|
|
"c14d538a-a794-4ea2-ab95-70089c764c85": {
|
|
"type": "ODOO",
|
|
"domain": [
|
|
["location_id.usage", "=", "internal"]
|
|
],
|
|
"context": {
|
|
"mail_notify_force_send": false,
|
|
"always_show_loc": 1,
|
|
"inventory_mode": true,
|
|
"inventory_report_mode": true
|
|
},
|
|
"sortedColumn": {
|
|
"measure": "quantity",
|
|
"order": "desc",
|
|
"domain": []
|
|
},
|
|
"measures": [
|
|
{ "id": "quantity", "fieldName": "quantity", "aggregator": "sum" },
|
|
{
|
|
"id": "reserved_quantity",
|
|
"fieldName": "reserved_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "available_quantity",
|
|
"fieldName": "available_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "inventory_quantity",
|
|
"fieldName": "inventory_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "inventory_diff_quantity",
|
|
"fieldName": "inventory_diff_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "cyclic_inventory_frequency",
|
|
"fieldName": "cyclic_inventory_frequency",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "inventory_quantity_auto_apply",
|
|
"fieldName": "inventory_quantity_auto_apply",
|
|
"aggregator": "sum"
|
|
},
|
|
{ "id": "value", "fieldName": "value", "aggregator": "sum" },
|
|
{ "id": "__count", "fieldName": "__count" }
|
|
],
|
|
"model": "stock.quant",
|
|
"columns": [],
|
|
"rows": [
|
|
{ "fieldName": "location_id" }
|
|
],
|
|
"name": "Inventory - locations",
|
|
"actionXmlId": "stock.dashboard_open_quants",
|
|
"formulaId": "8",
|
|
"fieldMatching": {
|
|
"62f6d1bd-9c76-48d7-b95a-3f5d6cb505df": { "chain": "location_id", "type": "many2one" },
|
|
"8dea5478-ff09-41fc-ada0-cf23c66e4f8b": { "chain": "product_id", "type": "many2one" },
|
|
"0725cf6d-c980-46a1-bd7b-bd75e34348e7": { "chain": "lot_id", "type": "many2one" },
|
|
"7ff87378-db1d-4725-bf25-6eee704b15a5": { "chain": "product_categ_id", "type": "many2one" },
|
|
"feeb0d08-4596-4e7c-b478-a3c659189cdd": { "chain": "warehouse_id", "type": "many2one" }
|
|
}
|
|
},
|
|
"4f0d7a37-943e-4289-ac4b-3cf1b56ca17a": {
|
|
"type": "ODOO",
|
|
"domain": [
|
|
["location_id.usage", "=", "internal"]
|
|
],
|
|
"context": {
|
|
"mail_notify_force_send": false,
|
|
"always_show_loc": 1,
|
|
"inventory_mode": true,
|
|
"inventory_report_mode": true
|
|
},
|
|
"sortedColumn": {
|
|
"measure": "quantity",
|
|
"order": "desc",
|
|
"domain": []
|
|
},
|
|
"measures": [
|
|
{ "id": "quantity", "fieldName": "quantity", "aggregator": "sum" },
|
|
{
|
|
"id": "reserved_quantity",
|
|
"fieldName": "reserved_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "available_quantity",
|
|
"fieldName": "available_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "inventory_quantity",
|
|
"fieldName": "inventory_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "inventory_diff_quantity",
|
|
"fieldName": "inventory_diff_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "cyclic_inventory_frequency",
|
|
"fieldName": "cyclic_inventory_frequency",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "inventory_quantity_auto_apply",
|
|
"fieldName": "inventory_quantity_auto_apply",
|
|
"aggregator": "sum"
|
|
},
|
|
{ "id": "value", "fieldName": "value", "aggregator": "sum" },
|
|
{ "id": "__count", "fieldName": "__count" }
|
|
],
|
|
"model": "stock.quant",
|
|
"columns": [],
|
|
"rows": [
|
|
{ "fieldName": "product_id" }
|
|
],
|
|
"name": "Inventory - products sort by Qty",
|
|
"actionXmlId": "stock.dashboard_open_quants",
|
|
"formulaId": "9",
|
|
"fieldMatching": {
|
|
"62f6d1bd-9c76-48d7-b95a-3f5d6cb505df": { "chain": "location_id", "type": "many2one" },
|
|
"8dea5478-ff09-41fc-ada0-cf23c66e4f8b": { "chain": "product_id", "type": "many2one" },
|
|
"0725cf6d-c980-46a1-bd7b-bd75e34348e7": { "chain": "lot_id", "type": "many2one" },
|
|
"7ff87378-db1d-4725-bf25-6eee704b15a5": { "chain": "product_categ_id", "type": "many2one" },
|
|
"feeb0d08-4596-4e7c-b478-a3c659189cdd": { "chain": "warehouse_id", "type": "many2one" }
|
|
}
|
|
},
|
|
"22f3a887-f193-4be2-a4af-e991b7ccc65e": {
|
|
"type": "ODOO",
|
|
"domain": [
|
|
"&",
|
|
["location_id.usage", "=", "internal"],
|
|
["reserved_quantity", ">", 0]
|
|
],
|
|
"context": {
|
|
"mail_notify_force_send": false,
|
|
"always_show_loc": 1,
|
|
"inventory_mode": true,
|
|
"inventory_report_mode": true
|
|
},
|
|
"sortedColumn": {
|
|
"measure": "quantity",
|
|
"order": "desc",
|
|
"domain": []
|
|
},
|
|
"measures": [
|
|
{ "id": "quantity", "fieldName": "quantity", "aggregator": "sum" },
|
|
{
|
|
"id": "reserved_quantity",
|
|
"fieldName": "reserved_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "available_quantity",
|
|
"fieldName": "available_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "inventory_quantity",
|
|
"fieldName": "inventory_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "inventory_diff_quantity",
|
|
"fieldName": "inventory_diff_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "cyclic_inventory_frequency",
|
|
"fieldName": "cyclic_inventory_frequency",
|
|
"aggregator": "sum"
|
|
},
|
|
{
|
|
"id": "inventory_quantity_auto_apply",
|
|
"fieldName": "inventory_quantity_auto_apply",
|
|
"aggregator": "sum"
|
|
},
|
|
{ "id": "value", "fieldName": "value", "aggregator": "sum" },
|
|
{ "id": "__count", "fieldName": "__count" }
|
|
],
|
|
"model": "stock.quant",
|
|
"columns": [],
|
|
"rows": [
|
|
{ "fieldName": "location_id" }
|
|
],
|
|
"name": "Inventory - locations (reserved stock)",
|
|
"actionXmlId": "stock.dashboard_open_quants",
|
|
"formulaId": "18",
|
|
"fieldMatching": {
|
|
"62f6d1bd-9c76-48d7-b95a-3f5d6cb505df": { "chain": "location_id", "type": "many2one" },
|
|
"8dea5478-ff09-41fc-ada0-cf23c66e4f8b": { "chain": "product_id", "type": "many2one" },
|
|
"0725cf6d-c980-46a1-bd7b-bd75e34348e7": { "chain": "lot_id", "type": "many2one" },
|
|
"7ff87378-db1d-4725-bf25-6eee704b15a5": { "chain": "product_categ_id", "type": "many2one" },
|
|
"feeb0d08-4596-4e7c-b478-a3c659189cdd": { "chain": "warehouse_id", "type": "many2one" }
|
|
}
|
|
},
|
|
"858023a6-cd63-47d6-9bce-759b488c2b75": {
|
|
"type": "ODOO",
|
|
"domain": [
|
|
["location_id.usage", "=", "internal"]
|
|
],
|
|
"context": {
|
|
"mail_notify_force_send": false,
|
|
"always_show_loc": 1,
|
|
"inventory_mode": true,
|
|
"inventory_report_mode": true
|
|
},
|
|
"sortedColumn": {
|
|
"measure": "value",
|
|
"order": "desc",
|
|
"domain": []
|
|
},
|
|
"measures": [
|
|
{ "id": "value", "fieldName": "value", "aggregator": "sum" },
|
|
{ "id": "quantity", "fieldName": "quantity", "aggregator": "sum" },
|
|
{
|
|
"id": "reserved_quantity",
|
|
"fieldName": "reserved_quantity",
|
|
"aggregator": "sum"
|
|
}
|
|
],
|
|
"model": "stock.quant",
|
|
"columns": [],
|
|
"rows": [
|
|
{ "fieldName": "product_id" }
|
|
],
|
|
"name": "Inventory by Product sort by value",
|
|
"actionXmlId": "stock.dashboard_open_quants",
|
|
"formulaId": "20",
|
|
"fieldMatching": {
|
|
"62f6d1bd-9c76-48d7-b95a-3f5d6cb505df": { "chain": "location_id", "type": "many2one" },
|
|
"8dea5478-ff09-41fc-ada0-cf23c66e4f8b": { "chain": "product_id", "type": "many2one" },
|
|
"0725cf6d-c980-46a1-bd7b-bd75e34348e7": { "chain": "lot_id", "type": "many2one" },
|
|
"7ff87378-db1d-4725-bf25-6eee704b15a5": { "chain": "product_categ_id", "type": "many2one" },
|
|
"feeb0d08-4596-4e7c-b478-a3c659189cdd": { "chain": "warehouse_id", "type": "many2one" }
|
|
}
|
|
},
|
|
"37e97fb2-1885-4dbd-9632-ec5c54a776f4": {
|
|
"type": "ODOO",
|
|
"domain": [
|
|
["location_id.usage", "=", "internal"]
|
|
],
|
|
"context": {
|
|
"mail_notify_force_send": false,
|
|
"always_show_loc": 1,
|
|
"inventory_mode": true,
|
|
"inventory_report_mode": true
|
|
},
|
|
"sortedColumn": {
|
|
"measure": "value",
|
|
"order": "desc",
|
|
"domain": []
|
|
},
|
|
"measures": [
|
|
{
|
|
"id": "reserved_quantity",
|
|
"fieldName": "reserved_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{ "id": "quantity", "fieldName": "quantity", "aggregator": "sum" },
|
|
{ "id": "value", "fieldName": "value", "aggregator": "sum" }
|
|
],
|
|
"model": "stock.quant",
|
|
"columns": [],
|
|
"rows": [
|
|
{ "fieldName": "location_id" }
|
|
],
|
|
"name": "Inventory by Location sort by value",
|
|
"actionXmlId": "stock.dashboard_open_quants",
|
|
"formulaId": "21",
|
|
"fieldMatching": {
|
|
"62f6d1bd-9c76-48d7-b95a-3f5d6cb505df": { "chain": "location_id", "type": "many2one" },
|
|
"8dea5478-ff09-41fc-ada0-cf23c66e4f8b": { "chain": "product_id", "type": "many2one" },
|
|
"0725cf6d-c980-46a1-bd7b-bd75e34348e7": { "chain": "lot_id", "type": "many2one" },
|
|
"7ff87378-db1d-4725-bf25-6eee704b15a5": { "chain": "product_categ_id", "type": "many2one" },
|
|
"feeb0d08-4596-4e7c-b478-a3c659189cdd": { "chain": "warehouse_id", "type": "many2one" }
|
|
}
|
|
},
|
|
"8f099f8d-362a-41e5-b676-75ab717cfc1e": {
|
|
"type": "ODOO",
|
|
"domain": [
|
|
"&",
|
|
["location_id.usage", "=", "internal"],
|
|
["quantity", "<", 0]
|
|
],
|
|
"context": {
|
|
"mail_notify_force_send": false,
|
|
"always_show_loc": 1,
|
|
"inventory_mode": true,
|
|
"inventory_report_mode": true
|
|
},
|
|
"measures": [
|
|
{ "id": "quantity", "fieldName": "quantity", "aggregator": "sum" },
|
|
{ "id": "__count", "fieldName": "__count" }
|
|
],
|
|
"model": "stock.quant",
|
|
"columns": [],
|
|
"rows": [
|
|
{ "fieldName": "product_id" }
|
|
],
|
|
"name": "Products",
|
|
"actionXmlId": "stock.dashboard_open_quants",
|
|
"formulaId": "22",
|
|
"fieldMatching": {
|
|
"feeb0d08-4596-4e7c-b478-a3c659189cdd": { "chain": "warehouse_id", "type": "many2one" },
|
|
"62f6d1bd-9c76-48d7-b95a-3f5d6cb505df": { "chain": "location_id", "type": "many2one" },
|
|
"7ff87378-db1d-4725-bf25-6eee704b15a5": { "chain": "product_categ_id", "type": "many2one" },
|
|
"8dea5478-ff09-41fc-ada0-cf23c66e4f8b": { "chain": "product_id", "type": "many2one" },
|
|
"0725cf6d-c980-46a1-bd7b-bd75e34348e7": { "chain": "lot_id", "type": "many2one" }
|
|
}
|
|
},
|
|
"0885aadb-2384-4300-a531-893035a13173": {
|
|
"type": "ODOO",
|
|
"domain": [
|
|
"&",
|
|
["location_id.usage", "=", "internal"],
|
|
["reserved_quantity", ">", 0]
|
|
],
|
|
"context": {
|
|
"mail_notify_force_send": false,
|
|
"always_show_loc": 1,
|
|
"inventory_mode": true,
|
|
"inventory_report_mode": true
|
|
},
|
|
"sortedColumn": {
|
|
"measure": "value",
|
|
"order": "desc",
|
|
"domain": []
|
|
},
|
|
"measures": [
|
|
{
|
|
"id": "reserved_quantity",
|
|
"fieldName": "reserved_quantity",
|
|
"aggregator": "sum"
|
|
},
|
|
{ "id": "quantity", "fieldName": "quantity", "aggregator": "sum" },
|
|
{ "id": "value", "fieldName": "value", "aggregator": "sum" }
|
|
],
|
|
"model": "stock.quant",
|
|
"columns": [],
|
|
"rows": [
|
|
{ "fieldName": "location_id" }
|
|
],
|
|
"name": "Inventory by Location sort by value (reserved stock)",
|
|
"actionXmlId": "stock.dashboard_open_quants",
|
|
"formulaId": "23",
|
|
"fieldMatching": {
|
|
"62f6d1bd-9c76-48d7-b95a-3f5d6cb505df": { "chain": "location_id", "type": "many2one" },
|
|
"8dea5478-ff09-41fc-ada0-cf23c66e4f8b": { "chain": "product_id", "type": "many2one" },
|
|
"0725cf6d-c980-46a1-bd7b-bd75e34348e7": { "chain": "lot_id", "type": "many2one" },
|
|
"7ff87378-db1d-4725-bf25-6eee704b15a5": { "chain": "product_categ_id", "type": "many2one" },
|
|
"feeb0d08-4596-4e7c-b478-a3c659189cdd": { "chain": "warehouse_id", "type": "many2one" }
|
|
}
|
|
}
|
|
},
|
|
"pivotNextId": 25,
|
|
"customTableStyles": {},
|
|
"globalFilters": [
|
|
{
|
|
"id": "feeb0d08-4596-4e7c-b478-a3c659189cdd",
|
|
"type": "relation",
|
|
"label": "Warehouse",
|
|
"defaultValueDisplayNames": [],
|
|
"modelName": "stock.warehouse",
|
|
"includeChildren": false
|
|
},
|
|
{
|
|
"id": "62f6d1bd-9c76-48d7-b95a-3f5d6cb505df",
|
|
"type": "relation",
|
|
"label": "Location",
|
|
"defaultValueDisplayNames": [],
|
|
"modelName": "stock.location"
|
|
},
|
|
{
|
|
"id": "7ff87378-db1d-4725-bf25-6eee704b15a5",
|
|
"type": "relation",
|
|
"label": "Product Category",
|
|
"defaultValueDisplayNames": [],
|
|
"modelName": "product.category",
|
|
"includeChildren": true
|
|
},
|
|
{
|
|
"id": "8dea5478-ff09-41fc-ada0-cf23c66e4f8b",
|
|
"type": "relation",
|
|
"label": "Product",
|
|
"defaultValueDisplayNames": [],
|
|
"modelName": "product.product"
|
|
},
|
|
{
|
|
"id": "0725cf6d-c980-46a1-bd7b-bd75e34348e7",
|
|
"type": "relation",
|
|
"label": "Lot/Serial",
|
|
"modelName": "stock.lot",
|
|
"defaultValueDisplayNames": []
|
|
}
|
|
],
|
|
"lists": {},
|
|
"listNextId": 3,
|
|
"chartOdooMenusReferences": {
|
|
"fad86b76-037f-4b7f-8afc-bc028c2536de": "stock.menu_valuation",
|
|
"73f61914-d895-4484-b3ba-585107daeb44": "stock.menu_valuation",
|
|
"de7010e1-2cdc-4e19-a1de-1c7fd4795bf4": "stock.menu_valuation",
|
|
"833374d1-d09f-4a4e-bb09-2831ceee5465": "stock.menu_valuation",
|
|
"8324b219-c649-4392-9fee-a3e7f396d70c": "stock.menu_valuation",
|
|
"0d527983-ee0f-44cb-af82-f637574a4e1e": "stock.menu_valuation",
|
|
"ebde3556-983a-475a-95f0-4edb2515b3bb": "stock.menu_valuation",
|
|
"e7f90aaf-95ec-4f1d-9b0c-ec7e4465d772": "stock.menu_valuation",
|
|
"639d221d-d74d-4762-984e-9debac4f5a82": "stock.menu_valuation"
|
|
}
|
|
}
|