{ "version": 21, "sheets": [ { "id": "sheet1", "name": "Dashboard", "colNumber": 8, "rowNumber": 82, "rows": { "6": { "size": 38 }, "22": { "size": 40 }, "23": { "size": 21 }, "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": 41 }, "41": { "size": 21 }, "42": { "size": 21 }, "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": 36 }, "58": { "size": 38 }, "59": { "size": 27 }, "60": { "size": 27 }, "61": { "size": 27 }, "62": { "size": 27 }, "63": { "size": 27 }, "64": { "size": 27 }, "65": { "size": 27 }, "66": { "size": 27 }, "67": { "size": 27 }, "68": { "size": 27 }, "69": { "size": 21 }, "70": { "size": 21 }, "71": { "size": 21 }, "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 } }, "cols": { "0": { "size": 332 }, "1": { "size": 100 }, "2": { "size": 69 }, "3": { "size": 40 }, "4": { "size": 50 }, "5": { "size": 275 }, "6": { "size": 100 }, "7": { "size": 55 } }, "merges": [], "cells": { "A7": { "content": "Available and reserved stock qty (top locations)" }, "A23": { "content": "Available and reserved stock qty (top products)" }, "A41": { "content": "Ageing stock qty by category and creation date" }, "A58": { "content": "=_t(\"Top 10 products with negative stock\")" }, "A59": { "content": "Products" }, "A60": { "content": "=PIVOT.HEADER(22,\"#product_id\",1)" }, "A61": { "content": "=PIVOT.HEADER(22,\"#product_id\",2)" }, "A62": { "content": "=PIVOT.HEADER(22,\"#product_id\",3)" }, "A63": { "content": "=PIVOT.HEADER(22,\"#product_id\",4)" }, "A64": { "content": "=PIVOT.HEADER(22,\"#product_id\",5)" }, "A65": { "content": "=PIVOT.HEADER(22,\"#product_id\",6)" }, "A66": { "content": "=PIVOT.HEADER(22,\"#product_id\",7)" }, "A67": { "content": "=PIVOT.HEADER(22,\"#product_id\",8)" }, "A68": { "content": "=PIVOT.HEADER(22,\"#product_id\",9)" }, "A69": { "content": "=PIVOT.HEADER(22,\"#product_id\",10)" }, "B59": { "content": "=PIVOT.HEADER(22,\"measure\",\"quantity\")" }, "B60": { "content": "=PIVOT.VALUE(22,\"quantity\",\"#product_id\",1)" }, "B61": { "content": "=PIVOT.VALUE(22,\"quantity\",\"#product_id\",2)" }, "B62": { "content": "=PIVOT.VALUE(22,\"quantity\",\"#product_id\",3)" }, "B63": { "content": "=PIVOT.VALUE(22,\"quantity\",\"#product_id\",4)" }, "B64": { "content": "=PIVOT.VALUE(22,\"quantity\",\"#product_id\",5)" }, "B65": { "content": "=PIVOT.VALUE(22,\"quantity\",\"#product_id\",6)" }, "B66": { "content": "=PIVOT.VALUE(22,\"quantity\",\"#product_id\",7)" }, "B67": { "content": "=PIVOT.VALUE(22,\"quantity\",\"#product_id\",8)" }, "B68": { "content": "=PIVOT.VALUE(22,\"quantity\",\"#product_id\",9)" }, "B69": { "content": "=PIVOT.VALUE(22,\"quantity\",\"#product_id\",10)" }, "E7": { "content": "Available and reserved stock value (top locations)" }, "E23": { "content": "Available and reserved stock value (top products)" }, "E41": { "content": "Ageing stock value by product and creation date" } }, "styles": { "A6": 1, "A7": 2, "A23": 2, "A41": 2, "A58": 2, "D7:E7": 2, "E23": 2, "E41": 2, "A59": 3, "A60:B69": 4, "B7:C7": 5, "B23:D23": 5, "B41:D41": 5, "F7:H7": 5, "F23:H23": 5, "F41:H41": 5, "B58:H58": 5, "B59": 6, "C60:H69": 7 }, "formats": {}, "borders": { "A7:C7": 1, "A23:C23": 1, "A41:C41": 1, "A58:C58": 1, "E7:H7": 1, "E23:H23": 1, "E41:H41": 1, "A8:C8": 2, "A24:C24": 2, "A42:C42": 2, "A59:C59": 2, "E8:H8": 2, "E24:H24": 2, "E42:H42": 2 }, "conditionalFormats": [], "figures": [ { "id": "833374d1-d09f-4a4e-bb09-2831ceee5465", "x": 246, "y": 9, "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 } }, { "id": "de7010e1-2cdc-4e19-a1de-1c7fd4795bf4", "x": 0, "y": 9, "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 } }, { "id": "0d527983-ee0f-44cb-af82-f637574a4e1e", "x": 0, "y": 176, "width": 499, "height": 344, "tag": "chart", "data": { "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": { "text": "" }, "stacked": true, "aggregated": false } }, { "id": "e7f90aaf-95ec-4f1d-9b0c-ec7e4465d772", "x": 0, "y": 561, "width": 501, "height": 355, "tag": "chart", "data": { "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": { "text": "" }, "stacked": true, "aggregated": false } }, { "id": "8324b219-c649-4392-9fee-a3e7f396d70c", "x": 540, "y": 176, "width": 483, "height": 344, "tag": "chart", "data": { "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": { "text": "" }, "stacked": true, "aggregated": false } }, { "id": "ebde3556-983a-475a-95f0-4edb2515b3bb", "x": 540, "y": 561, "width": 482, "height": 358, "tag": "chart", "data": { "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": { "text": "" }, "stacked": true, "aggregated": false } }, { "id": "fad86b76-037f-4b7f-8afc-bc028c2536de", "x": 0, "y": 959, "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", "verticalAxisPosition": "left", "stacked": true, "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" } } } }, { "id": "73f61914-d895-4484-b3ba-585107daeb44", "x": 541, "y": 959, "width": 480, "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", "verticalAxisPosition": "left", "stacked": true, "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" } } } }, { "id": "639d221d-d74d-4762-984e-9debac4f5a82", "x": 492, "y": 9, "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 } } ], "tables": [], "areGridLinesVisible": true, "isVisible": true, "headerGroups": { "ROW": [], "COL": [] }, "dataValidationRules": [], "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": { "content": "=_t(\"KPI\")" }, "A2": { "content": "=_t(\"Total inventory value\")" }, "A3": { "content": "Share of reserved stock qty" }, "A4": { "content": "Share of reserved stock Value" }, "A5": { "content": "Count of products with negative stock" }, "B2": { "content": "=FORMAT.LARGE.NUMBER(PIVOT.VALUE(20,\"value\"))" }, "B3": { "content": "=iferror(PIVOT.VALUE(20,\"reserved_quantity\")/PIVOT.VALUE(20,\"quantity\"),\"No data\")" }, "B4": { "content": "=IFERROR(C4/D4,\"No data\")" }, "B5": { "content": "=PIVOT.VALUE(22,\"__count\")" }, "C1": { "content": "Reserved" }, "C3": { "content": "=PIVOT.VALUE(20,\"reserved_quantity\")" }, "C4": { "content": "=IFERROR(FORMAT.LARGE.NUMBER(round(PIVOT.VALUE(18,\"value\")/PIVOT.VALUE(18,\"quantity\"))*PIVOT.VALUE(18,\"reserved_quantity\")),\"No data\")" }, "D1": { "content": "Total" }, "D3": { "content": "=PIVOT.VALUE(20,\"quantity\")" }, "D4": { "content": "=FORMAT.LARGE.NUMBER(PIVOT.VALUE(20,\"value\"))" }, "E3": { "content": "=TEXT(C3,\"#,##0\")&\" out of \" &TEXT(D3,\"#,##0\")" }, "E4": { "content": "=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": [], "figures": [], "tables": [], "areGridLinesVisible": true, "isVisible": true, "headerGroups": { "ROW": [], "COL": [] }, "dataValidationRules": [], "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": { "content": "Location" }, "A2": { "content": "=PIVOT.HEADER(8,\"#location_id\",1)" }, "A3": { "content": "=PIVOT.HEADER(8,\"#location_id\",2)" }, "A4": { "content": "=PIVOT.HEADER(8,\"#location_id\",3)" }, "A5": { "content": "=PIVOT.HEADER(8,\"#location_id\",4)" }, "A6": { "content": "=PIVOT.HEADER(8,\"#location_id\",5)" }, "A7": { "content": "=PIVOT.HEADER(8,\"#location_id\",6)" }, "A8": { "content": "=PIVOT.HEADER(8,\"#location_id\",7)" }, "A9": { "content": "=PIVOT.HEADER(8,\"#location_id\",8)" }, "A10": { "content": "=PIVOT.HEADER(8,\"#location_id\",9)" }, "A11": { "content": "=PIVOT.HEADER(8,\"#location_id\",10)" }, "B1": { "content": "=PIVOT.HEADER(9,\"measure\",\"available_quantity\")" }, "B2": { "content": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",1)" }, "B3": { "content": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",2)" }, "B4": { "content": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",3)" }, "B5": { "content": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",4)" }, "B6": { "content": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",5)" }, "B7": { "content": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",6)" }, "B8": { "content": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",7)" }, "B9": { "content": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",8)" }, "B10": { "content": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",9)" }, "B11": { "content": "=PIVOT.VALUE(8,\"available_quantity\",\"#location_id\",10)" }, "C1": { "content": "=PIVOT.HEADER(9,\"measure\",\"reserved_quantity\")" }, "C2": { "content": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",1)" }, "C3": { "content": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",2)" }, "C4": { "content": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",3)" }, "C5": { "content": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",4)" }, "C6": { "content": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",5)" }, "C7": { "content": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",6)" }, "C8": { "content": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",7)" }, "C9": { "content": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",8)" }, "C10": { "content": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",9)" }, "C11": { "content": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",10)" }, "E2": { "content": "=PIVOT.HEADER(9,\"#product_id\",1)" }, "E3": { "content": "=PIVOT.HEADER(9,\"#product_id\",2)" }, "E4": { "content": "=PIVOT.HEADER(9,\"#product_id\",3)" }, "E5": { "content": "=PIVOT.HEADER(9,\"#product_id\",4)" }, "E6": { "content": "=PIVOT.HEADER(9,\"#product_id\",5)" }, "E7": { "content": "=PIVOT.HEADER(9,\"#product_id\",6)" }, "E8": { "content": "=PIVOT.HEADER(9,\"#product_id\",7)" }, "E9": { "content": "=PIVOT.HEADER(9,\"#product_id\",8)" }, "E10": { "content": "=PIVOT.HEADER(9,\"#product_id\",9)" }, "E11": { "content": "=PIVOT.HEADER(9,\"#product_id\",10)" }, "F1": { "content": "=PIVOT.HEADER(9,\"measure\",\"available_quantity\")" }, "F2": { "content": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",1)" }, "F3": { "content": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",2)" }, "F4": { "content": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",3)" }, "F5": { "content": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",4)" }, "F6": { "content": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",5)" }, "F7": { "content": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",6)" }, "F8": { "content": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",7)" }, "F9": { "content": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",8)" }, "F10": { "content": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",9)" }, "F11": { "content": "=PIVOT.VALUE(9,\"quantity\",\"#product_id\",10)" }, "G1": { "content": "=PIVOT.HEADER(9,\"measure\",\"reserved_quantity\")" }, "G2": { "content": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",1)" }, "G3": { "content": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",2)" }, "G4": { "content": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",3)" }, "G5": { "content": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",4)" }, "G6": { "content": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",5)" }, "G7": { "content": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",6)" }, "G8": { "content": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",7)" }, "G9": { "content": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",8)" }, "G10": { "content": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",9)" }, "G11": { "content": "=PIVOT.VALUE(9,\"reserved_quantity\",\"#product_id\",10)" } }, "styles": {}, "formats": { "F2:G12": 2 }, "borders": {}, "conditionalFormats": [], "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": [] }, "dataValidationRules": [], "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": { "content": "=PIVOT.HEADER(21,\"#location_id\",row()-1)" }, "A3": { "content": "=PIVOT.HEADER(21,\"#location_id\",row()-1)" }, "A4": { "content": "=PIVOT.HEADER(21,\"#location_id\",row()-1)" }, "A5": { "content": "=PIVOT.HEADER(21,\"#location_id\",row()-1)" }, "A6": { "content": "=PIVOT.HEADER(21,\"#location_id\",row()-1)" }, "A7": { "content": "=PIVOT.HEADER(21,\"#location_id\",row()-1)" }, "A8": { "content": "=PIVOT.HEADER(21,\"#location_id\",row()-1)" }, "A9": { "content": "=PIVOT.HEADER(21,\"#location_id\",row()-1)" }, "A10": { "content": "=PIVOT.HEADER(21,\"#location_id\",row()-1)" }, "A11": { "content": "=PIVOT.HEADER(21,\"#location_id\",row()-1)" }, "A12": { "content": "=PIVOT.HEADER(21,\"#location_id\",row()-1)" }, "B1": { "content": "Available Value" }, "B2": { "content": "=if(D2<>\"\",D2-C2,\"\")" }, "B3": { "content": "=if(D3<>\"\",D3-C3,\"\")" }, "B4": { "content": "=if(D4<>\"\",D4-C4,\"\")" }, "B5": { "content": "=if(D5<>\"\",D5-C5,\"\")" }, "B6": { "content": "=if(D6<>\"\",D6-C6,\"\")" }, "B7": { "content": "=if(D7<>\"\",D7-C7,\"\")" }, "B8": { "content": "=if(D8<>\"\",D8-C8,\"\")" }, "B9": { "content": "=if(D9<>\"\",D9-C9,\"\")" }, "B10": { "content": "=if(D10<>\"\",D10-C10,\"\")" }, "B11": { "content": "=if(D11<>\"\",D11-C11,\"\")" }, "B12": { "content": "=if(D12<>\"\",D12-C12,\"\")" }, "C1": { "content": "Reserved value" }, "C2": { "content": "=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": { "content": "=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": { "content": "=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": { "content": "=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": { "content": "=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": { "content": "=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": { "content": "=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": { "content": "=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": { "content": "=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": { "content": "=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": { "content": "=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": { "content": "=PIVOT.HEADER(21,\"measure\",\"value\")" }, "D2": { "content": "=PIVOT.VALUE(21,\"value\",\"#location_id\",1)" }, "D3": { "content": "=PIVOT.VALUE(21,\"value\",\"#location_id\",2)" }, "D4": { "content": "=PIVOT.VALUE(21,\"value\",\"#location_id\",3)" }, "D5": { "content": "=PIVOT.VALUE(21,\"value\",\"#location_id\",4)" }, "D6": { "content": "=PIVOT.VALUE(21,\"value\",\"#location_id\",5)" }, "D7": { "content": "=PIVOT.VALUE(21,\"value\",\"#location_id\",6)" }, "D8": { "content": "=PIVOT.VALUE(21,\"value\",\"#location_id\",7)" }, "D9": { "content": "=PIVOT.VALUE(21,\"value\",\"#location_id\",8)" }, "D10": { "content": "=PIVOT.VALUE(21,\"value\",\"#location_id\",9)" }, "D11": { "content": "=PIVOT.VALUE(21,\"value\",\"#location_id\",10)" }, "D12": { "content": "=PIVOT.VALUE(21,\"value\",\"#location_id\",11)" }, "E1": { "content": "=PIVOT.HEADER(21,\"measure\",\"quantity\")" }, "E2": { "content": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",1)" }, "E3": { "content": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",2)" }, "E4": { "content": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",3)" }, "E5": { "content": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",4)" }, "E6": { "content": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",5)" }, "E7": { "content": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",6)" }, "E8": { "content": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",7)" }, "E9": { "content": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",8)" }, "E10": { "content": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",9)" }, "E11": { "content": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",10)" }, "E12": { "content": "=PIVOT.VALUE(21,\"quantity\",\"#location_id\",11)" }, "F1": { "content": "=PIVOT.HEADER(21,\"measure\",\"reserved_quantity\")" }, "F2": { "content": "=PIVOT.VALUE(8,\"reserved_quantity\",\"#location_id\",1)" }, "F3": { "content": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",2)" }, "F4": { "content": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",3)" }, "F5": { "content": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",4)" }, "F6": { "content": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",5)" }, "F7": { "content": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",6)" }, "F8": { "content": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",7)" }, "F9": { "content": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",8)" }, "F10": { "content": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",9)" }, "F11": { "content": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",10)" }, "F12": { "content": "=PIVOT.VALUE(21,\"reserved_quantity\",\"#location_id\",11)" }, "H2": { "content": "=PIVOT.HEADER(20,\"#product_id\",1)" }, "H3": { "content": "=PIVOT.HEADER(20,\"#product_id\",2)" }, "H4": { "content": "=PIVOT.HEADER(20,\"#product_id\",3)" }, "H5": { "content": "=PIVOT.HEADER(20,\"#product_id\",4)" }, "H6": { "content": "=PIVOT.HEADER(20,\"#product_id\",5)" }, "H7": { "content": "=PIVOT.HEADER(20,\"#product_id\",6)" }, "H8": { "content": "=PIVOT.HEADER(20,\"#product_id\",7)" }, "H9": { "content": "=PIVOT.HEADER(20,\"#product_id\",8)" }, "H10": { "content": "=PIVOT.HEADER(20,\"#product_id\",9)" }, "H11": { "content": "=PIVOT.HEADER(20,\"#product_id\",10)" }, "I1": { "content": "Available Value" }, "I2": { "content": "=if(K2<>\"\",K2-J2,\"\")" }, "I3": { "content": "=if(K3<>\"\",K3-J3,\"\")" }, "I4": { "content": "=if(K4<>\"\",K4-J4,\"\")" }, "I5": { "content": "=if(K5<>\"\",K5-J5,\"\")" }, "I6": { "content": "=if(K6<>\"\",K6-J6,\"\")" }, "I7": { "content": "=if(K7<>\"\",K7-J7,\"\")" }, "I8": { "content": "=if(K8<>\"\",K8-J8,\"\")" }, "I9": { "content": "=if(K9<>\"\",K9-J9,\"\")" }, "I10": { "content": "=if(K10<>\"\",K10-J10,\"\")" }, "I11": { "content": "=if(K11<>\"\",K11-J11,\"\")" }, "J1": { "content": "Reserved value" }, "J2": { "content": "=(M2/L2)*K2" }, "J3": { "content": "=(M3/L3)*K3" }, "J4": { "content": "=(M4/L4)*K4" }, "J5": { "content": "=(M5/L5)*K5" }, "J6": { "content": "=(M6/L6)*K6" }, "J7": { "content": "=(M7/L7)*K7" }, "J8": { "content": "=(M8/L8)*K8" }, "J9": { "content": "=(M9/L9)*K9" }, "J10": { "content": "=(M10/L10)*K10" }, "J11": { "content": "=(M11/L11)*K11" }, "K1": { "content": "=PIVOT.HEADER(20,\"measure\",\"value\")" }, "K2": { "content": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)" }, "K3": { "content": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)" }, "K4": { "content": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)" }, "K5": { "content": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)" }, "K6": { "content": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)" }, "K7": { "content": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)" }, "K8": { "content": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)" }, "K9": { "content": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)" }, "K10": { "content": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)" }, "K11": { "content": "=PIVOT.VALUE(20,\"value\",\"#product_id\",row()-1)" }, "L1": { "content": "=PIVOT.HEADER(20,\"measure\",\"quantity\")" }, "L2": { "content": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",1)" }, "L3": { "content": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",2)" }, "L4": { "content": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",3)" }, "L5": { "content": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",4)" }, "L6": { "content": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",5)" }, "L7": { "content": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",6)" }, "L8": { "content": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",7)" }, "L9": { "content": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",8)" }, "L10": { "content": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",9)" }, "L11": { "content": "=PIVOT.VALUE(20,\"quantity\",\"#product_id\",10)" }, "M1": { "content": "=PIVOT.HEADER(20,\"measure\",\"reserved_quantity\")" }, "M2": { "content": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",1)" }, "M3": { "content": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",2)" }, "M4": { "content": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",3)" }, "M5": { "content": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",4)" }, "M6": { "content": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",5)" }, "M7": { "content": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",6)" }, "M8": { "content": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",7)" }, "M9": { "content": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",8)" }, "M10": { "content": "=PIVOT.VALUE(20,\"reserved_quantity\",\"#product_id\",9)" }, "M11": { "content": "=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": [], "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": [] }, "dataValidationRules": [], "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": "ac18891f-8749-4112-b6bf-1c5d232845a1", "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": { "groupId": [[], []], "measure": "quantity", "order": "desc", "originIndexes": [0] }, "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": { "groupId": [[], []], "measure": "quantity", "order": "desc", "originIndexes": [0] }, "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": { "groupId": [[], []], "measure": "quantity", "order": "desc", "originIndexes": [0] }, "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": { "groupId": [[], []], "measure": "value", "order": "desc", "originIndexes": [0] }, "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": { "groupId": [[], []], "measure": "value", "order": "desc", "originIndexes": [0] }, "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 }, "sortedColumn": { "groupId": [[], [8]], "measure": "quantity", "order": "asc", "originIndexes": [0] }, "measures": [ { "id": "quantity", "fieldName": "quantity", "aggregator": "sum" }, { "id": "__count", "fieldName": "__count" } ], "model": "stock.quant", "columns": [], "rows": [{ "fieldName": "product_id" }], "name": "Inventory by Location", "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": { "groupId": [[], []], "measure": "value", "order": "desc", "originIndexes": [0] }, "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": {}, "odooVersion": 12, "globalFilters": [ { "id": "feeb0d08-4596-4e7c-b478-a3c659189cdd", "type": "relation", "label": "Warehouse", "defaultValue": [], "defaultValueDisplayNames": [], "modelName": "stock.warehouse", "includeChildren": false }, { "id": "62f6d1bd-9c76-48d7-b95a-3f5d6cb505df", "type": "relation", "label": "Location", "defaultValue": [], "defaultValueDisplayNames": [], "modelName": "stock.location" }, { "id": "7ff87378-db1d-4725-bf25-6eee704b15a5", "type": "relation", "label": "Product Category", "defaultValue": [], "defaultValueDisplayNames": [], "modelName": "product.category", "includeChildren": true }, { "id": "8dea5478-ff09-41fc-ada0-cf23c66e4f8b", "type": "relation", "label": "Product", "defaultValue": [], "defaultValueDisplayNames": [], "modelName": "product.product" }, { "id": "0725cf6d-c980-46a1-bd7b-bd75e34348e7", "type": "relation", "label": "Lot/Serial", "modelName": "stock.lot", "defaultValue": [], "defaultValueDisplayNames": [], "rangeType": "year" } ], "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" } }