Spreadsheet: 835015d1688228597-need-help-with-excel-file-and-slicer-calculation-issue-dvg_inventory_tracker_reports
Sheet: Orders_and_Inventory

INVENTORY AND SALES - ORDERS AND INVENTORY |  |  |  |  |  |  |  |  | Products | Report | Terms
 | CURRENT INVENTORY LEVEL |  |  |  | CHOOSE PRODUCT |  | PRODUCTS WHERE CURRENT INVENTORY <= RE-ORDER POINT
 |  |  |  |  | Butterscotch FLV Sauce |  | Product | Current Inventory | Re-order Point | Pending Purchase Quantity
 |  |  |  |  |  |  |  |  |  |  | 5
 | PRODUCTS AVAILABLE | QUANTITY | PRODUCTS TO RE-ORDER | CURRENT INVENTORY
 | ORDER ITEMS THAT CANNOT BE FULFILLED* |  |  | RE-ORDER POINT
 |  |  |  | PENDING PURCHASE QUANTITY
 |  |  |  | PENDING SALES QUANTITY
 | CURRENT | FUTURE
 | *where Sale quantity is higher than Inventory available - highlighted with red border in the table below
ENTER YOUR ORDER DETAILS |  |  |  |  |  |  |  | these  columns are automatically calculated
Order Number | Order Date | Order Type | Expected Date | Partner | Product Name | Quantity | Unit Price | Amount | Product Category | YearMonth | Inventory Availability
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Butterscotch FLV Sauce | 29 | 2617
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Caramel FLV Sauce | 75 | 2605
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Chocolate FLV Sauce | 102 | 3043
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | White Chocolate FLV Sauce | 29 | 2605
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Cheese Cake FLV Sauce | 14 | 2605
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Caramel FLV Syrup | 96 | 1329
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | [NAME] FLV Syrup | 285 | 1327
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Vanilla FLV Syrup | 119 | 1329
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Blue Ocean FLV Syrup | 94 | 1339
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | European Strawberry FLV Syrup | 94 | 1343
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Fragnant Lychee FLV Syrup | 33 | 1337
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Green Apple Campagna FLV Syrup | 94 | 1340
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Lemon FLV Syrup | 33 | 1340
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Majestic Mango FLV Syrup | 36 | 1340
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Menta CUBANO FLV Syrup | 83 | 1331
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Peach Garden FLV Syrup | 36 | 1340
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | ITALIAN Dolce FLV Syrup | 24 | 1321
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Lemonade FLV Syrup | 28 | 1843
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | [NAME] BEV Mix | 28 | 1960
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | White Peach Fruit BEV Mix | 29 | 1960
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Mango Fruit BEV Mix | 45 | 1957
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Passionfruit FRUIT BEV Mix | 30 | 1955
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Strawberry Fruit BEV Mix | 46 | 1957
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | [NAME] BEV Mix | 18 | 1955
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | [NAME] FLV Syrup | 34 | 1392
P1 | 2023-03-27 00:00:00 | Purchase | 2023-06-24 00:00:00 | Kerry | Tropical Passionfruit FLV Syrup | 72 | 1340
S1 | 2023-06-26 00:00:00 | Sale | 2023-06-26 00:00:00 | Crimson Cup | White Chocolate FLV Sauce | 27 | 3200