Business Central queries
200 of 267 queries, this page
| query 1 "Distinct Items Sold" | Base Application | new in 27 |
| query 2 "Customer Interaction Stats." | Base Application | new in 27 |
| query 3 "Customer Sales per Period" | Base Application | new in 27 |
| query 4 "Distinct Items Purchased" | Base Application | new in 28 |
| query 19 "VAT Entries Base Amt. Sum" | Base Application | 17-29 |
| query 21 "Cust. Ledg. Entry Remain. Amt." | Base Application | 17-29 |
| query 22 "Cust. Remain. Amt. By Due Date" | Base Application | 17-29 |
| query 25 "Vend. Ledg. Entry Remain. Amt." | Base Application | 17-29 |
| query 33 "Recon. Cust. Posting Gr. Sum" | Base Application | new in 28 |
| query 34 "Recon. Vend. Posting Gr. Sum" | Base Application | new in 28 |
| query 35 "Customer Debit Credit Amount" | Base Application | new in 28 |
| query 36 "Vendor Debit Credit Amount" | Base Application | new in 28 |
| query 37 Rem | Base Application | new in 27 |
| query 39 Rem | Base Application | new in 27 |
| query 50 "Power BI Customer List" | Base Application | 17-29 |
| query 51 "Power BI Vendor List" | Base Application | 17-29 |
| query 52 "Power BI Item Purchase List" | Base Application | 17-29 |
| query 53 "Power BI GL Amount List" | Base Application | 17-29 |
| query 54 "Power BI Jobs List" | Base Application | 17-29 |
| query 55 "Power BI Sales List" | Base Application | 17-29 |
| query 56 "Power BI Purchase List" | Base Application | 17-29 |
| query 57 "Power BI Item Sales List" | Base Application | 17-29 |
| query 58 "Power BI GL Budgeted Amount" | Base Application | 17-29 |
| query 59 "Power BI Top Cust. Overview" | Base Application | 17-29 |
| query 60 "Power BI Sales Hdr. Cust." | Base Application | 17-29 |
| query 61 "Power BI Cust. Item Ledg. Ent." | Base Application | 17-29 |
| query 62 "Power BI Cust. Ledger Entries" | Base Application | 17-29 |
| query 63 "Power BI Vendor Ledger Entries" | Base Application | 17-29 |
| query 64 "Power BI Purchase Hdr. Vendor" | Base Application | 17-29 |
| query 65 "Power BI Vend. Item Ledg. Ent." | Base Application | 17-29 |
| query 100 "Top Customer Overview" | Base Application | 17-29 |
| query 101 "Sales Dashboard" | Base Application | 17-29 |
| query 102 "Item Sales by Customer" | Base Application | 17-29 |
| query 103 "Item Sales and Profit" | Base Application | 17-29 |
| query 104 "Sales Orders by Sales Person" | Base Application | 17-29 |
| query 105 "Sales Opportunities" | Base Application | 17-29 |
| query 106 "Segment Lines" | Base Application | 17-29 |
| query 115 "Sales Shipped Not Invoiced LCY" | Base Application | new in 26 |
| Pending, tag 28.0 | ||
| query 123 "Fixed Assets Analysis" | Base Application | new in 25 |
| query 124 "Sales Order Analysis" | Base Application | new in 27 |
| query 130 "Posted Docs. With No Inc. Doc." | Base Application | 17-29 |
| query 133 "Inc. Doc. Atts. Ready for OCR" | Base Application | 17-29 |
| query 134 "OCR Vendors" | Base Application | 17-29 |
| query 135 "OCR Vendor Bank Accounts" | Base Application | 17-29 |
| query 141 "EU VAT Entries" | Base Application | 17-29 |
| query 200 "Purchase Invoices By Order" | Base Application | new in 23 |
| query 201 "Sales Invoices By Order" | Base Application | new in 23 |
| query 202 "Service Invoices By Order" | Base Application | new in 23 |
| query 203 "Item Ledger Entry Types" | Base Application | new in 26 |
| query 204 "Purch. Cr. Memos By Ret. Order" | Base Application | new in 23 |
| query 205 "Sales Cr. Memos By Ret. Order" | Base Application | new in 23 |
| query 250 "G/L Entry Dimensions" | Base Application | 17-29 |
| query 251 "G/L Budget Entry Dimensions" | Base Application | 17-29 |
| query 252 "Analysis View Entry Dimensions" | Base Application | 17-29 |
| query 253 "Analysis View Budg. Entry Dims" | Base Application | 17-29 |
| query 256 "CF Forecast Entry Dimensions" | Base Application | 17-29 |
| query 257 "Dimension Sets" | Base Application | 17-29 |
| query 260 "Dimension Set Entries" | Base Application | 17-29 |
| query 261 "G/L Entries" | Base Application | 17-29 |
| query 262 "Cust. Ledger Entries" | Base Application | 17-29 |
| query 263 "Vendor Ledger Entries" | Base Application | 17-29 |
| query 264 "Bank Account Ledger Entries" | Base Application | 17-29 |
| query 265 "Item Ledger Entries" | Base Application | 17-29 |
| query 266 "Value Entries" | Base Application | 17-29 |
| query 267 "FA Ledger Entries" | Base Application | 17-29 |
| query 268 "Job Ledger Entries" | Base Application | 17-29 |
| query 269 "Res. Ledger Entries" | Base Application | 17-29 |
| query 270 "G/L Budget Entries" | Base Application | 17-29 |
| query 302 "Item Application Entries" | Base Application | new in 27 |
| query 303 "Item Application Entries Inb." | Base Application | new in 27 |
| query 304 "Item Application Entries Outb." | Base Application | new in 27 |
| query 410 "Analysis View Source" | Base Application | 17-29 |
| query 472 "Failed Job Queue Entry" | Base Application | 17-29 |
| query 486 Projects | Base Application | new in 25 |
| query 487 "Project Planning Analysis" | Base Application | new in 27 |
| query 488 "Purch. Order Perf. Analysis" | Base Application | new in 27 |
| query 520 "Item By Lot No. Res." | Base Application | new in 18 |
| query 521 "Item By Lot No. Item Ledg." | Base Application | new in 18 |
| query 522 "Qty. Reserved From Item Ledger" | Base Application | new in 22 |
| query 523 "Sales Reserv. From Item Ledger" | Base Application | new in 26 |
| query 760 "Trailing Sales Order Qry" | Base Application | 17-29 |
| query 762 "Acc. Sched. Line Desc. Count" | Base Application | 17-29 |
| query 763 "Colm. Layt. Colm. Header Count" | Base Application | 17-29 |
| query 770 "Analysis Line Desc. Count" | Base Application | 17-29 |
| query 771 "Analysis Column Header Count" | Base Application | 17-29 |
| query 773 "Users in User Groups" | Base Application | gone after 24 |
| Pending, tag 22.0 | ||
| query 774 "Users in Plans" | System Application | 17-29 |
| query 775 Plan | System Application | 17-29 |
| query 776 Device | System Application | new in 18 |
| query 777 "Role Center from Plans" | System Application | new in 23 |
| query 901 Rem | Base Application | new in 27 |
| query 984 "Get Time Sheet Lines" | Base Application | new in 24 |
| query 985 "Get Time Sheet Archive Lines" | Base Application | new in 24 |
| query 986 "Time Sheet Line Status Count" | Base Application | new in 26 |
| query 1003 Rem | Base Application | new in 27 |
| query 1033 Get | Base Application | new in 26 |
| query 1038 "Job Task by Bill-to Customer" | Base Application | new in 28 |
| query 1232 "Data Exch. Field Details" | Base Application | 17-29 |
| query 1252 "Bank Rec. Match Candidates" | Base Application | gone after 23 |
| Pending, tag 21.0 | ||
| query 1302 "Sales Outstd. Amount On VAT" | Base Application | 17-29 |
| query 1310 "Cust. Ledg. Entry Sales" | Base Application | 17-29 |
| query 1311 "Top 10 Customer Sales" | Base Application | 17-29 |
| query 1312 "Num Cust | Base Application | 17-29 |
| query 1313 "Purch. Outstd. Amount On VAT" | Base Application | 17-29 |
| query 1316 "Value Item Ledger Entries" | Base Application | new in 21 |
| query 1319 "Sales by Cust. Grp. Chart Mgt." | Base Application | new in 20 |
| query 1501 "Workflow Instance" | Base Application | 17-29 |
| query 1502 "Workflow Definition" | Base Application | 17-29 |
| query 1511 "User IDs by Notification Type" | Base Application | 17-29 |
| query 2900 "Item With Variants" | Base Application | new in 20 |
| query 2901 "Item With Locations" | Base Application | new in 20 |
| query 2902 "Item With Variants & Locations" | Base Application | new in 20 |
| query 3303 "PA Posted Purch. Inv. Users" | Payables Agent | new in 28 |
| query 3688 "BOM Component Items" | Base Application | 17-29 |
| query 3689 "Item Production BOMs" | Base Application | 17-29 |
| query 3691 "Production BOM & Line Details" | Base Application | 17-29 |
| query 5001 "Locations from items Sales" | Base Application | 17-29 |
| query 5002 "Locations from items Purch" | Base Application | 17-29 |
| query 5400 "Delayed Prod. Orders - by Cost" | Base Application | 17-29 |
| query 5401 "Pending Prod. Orders - by Cost" | Base Application | 17-29 |
| query 5402 "Top-10 Prod. Orders - by Cost" | Base Application | 17-29 |
| query 5403 "My Prod. Orders - By Cost" | Base Application | 17-29 |
| query 5404 "My Delayed Prod. Orders" | Base Application | 17-29 |
| query 5407 Rem | Base Application | new in 27 |
| query 5480 "Customer Sales Entity" | Base Application | 17-29 |
| query 5481 "Vendor Purchases Entity" | Base Application | 17-29 |
| query 5502 "Tax Groups For Tax Areas" | Base Application | 17-29 |
| query 5741 Rem | Base Application | new in 27 |
| query 5756 "Grouped Item Ledger Entries" | Base Application | new in 24 |
| query 5833 "Item to Value Entries" | Base Application | new in 28 |
| query 5840 "Avg. Cost Entry Points Not Adj" | Base Application | new in 26 |
| query 5842 "Residual Amount - Items" | Base Application | new in 26 |
| query 5896 "Calculate Actual Material Cost" | Base Application | new in 20 |
| query 5900 "Service Analysis" | Base Application | new in 25 |
| query 5902 Rem | Base Application | new in 27 |
| query 6100 "E-Doc. Line by Receipt" | E-Document Core | new in 27 |
| query 6210 "Country Region - PBI API" | Sustainability | new in 27 |
| query 6211 "Emission Fees - PBI API" | Sustainability | new in 27 |
| query 6212 "Employee Absence - PBI API" | Sustainability | new in 27 |
| query 6213 "Employee | Sustainability | new in 27 |
| query 6214 "Employee Quali - PBI API" | Sustainability | new in 27 |
| query 6215 "Employees - PBI API" | Sustainability | new in 27 |
| query 6216 "Resp Centre - PBI API" | Sustainability | new in 27 |
| query 6217 "Sus | Sustainability | new in 27 |
| query 6218 "Sust Account Cat - PBI API" | Sustainability | new in 27 |
| query 6219 "Sust Accounts - PBI API" | Sustainability | new in 27 |
| query 6220 "Sustainability Goals - PBI API" | Sustainability | new in 27 |
| query 6221 "Sust Ledger Entries - PBI API" | Sustainability | new in 27 |
| query 6502 "Items With Expiration Date" | Base Application | 17-29 |
| query 7150 "Item Analysis View Source" | Base Application | 17-29 |
| query 7300 "Lot Numbers by Bin" | Base Application | 17-29 |
| query 7301 "Whse. Employees at Locations" | Base Application | 17-29 |
| query 7302 "Bin Content by Item Tracking" | Base Application | new in 27 |
| query 7314 Calc | Base Application | new in 20 |
| query 7315 Calc | Base Application | new in 21 |
| query 7316 Calc | Base Application | new in 21 |
| query 7317 Calc | Base Application | new in 21 |
| query 7318 Calc | Base Application | new in 21 |
| query 7319 Calc | Base Application | new in 23 |
| query 7320 Calc | Base Application | new in 21 |
| query 7321 "Summarized Stock By Item Trkg." | Base Application | new in 22 |
| query 7323 Calc | Base Application | new in 23 |
| query 7345 "Avail Qty. (Base) In QC Bins" | Base Application | 17-29 |
| query 7346 "Whse. Entry Tracking Distinct" | Base Application | new in 28 |
| query 8000 "Overdue Customer Serv. Comm." | Subscription Billing | new in 26 |
| Pending, tag 26.0 | ||
| query 8001 "Overdue Vendor Serv. Comm." | Subscription Billing | new in 26 |
| Pending, tag 26.0 | ||
| query 8888 "Outbox Emails" | System Application | new in 20 |
| query 8889 "Sent Emails" | System Application | new in 20 |
| query 8890 "Email Related Record" | System Application | new in 20 |
| query 9059 "Service Header Doc. Type Count" | Base Application | 17-29 |
| query 9060 "Count Sales Orders" | Base Application | 17-29 |
| query 9063 "Count Purchase Orders" | Base Application | 17-29 |
| query 9088 "Top 10 Vendor Purchases" | Base Application | new in 27 |
| query 9089 "Purchase by Vendor Group" | Base Application | new in 27 |
| query 9150 "My Customers" | Base Application | 17-29 |
| query 9151 "My Vendors" | Base Application | 17-29 |
| query 9152 "My Items" | Base Application | 17-29 |
| Pending, tag 27.0 | ||
| query 9153 "Non-Inventory Telemetry" | Base Application | new in 19 |
| query 20401 "Qlty. Inspection Values" | Quality Management | new in 28 |
| query 20402 "Qlty. Item Ledger By Location" | Quality Management | new in 28 |
| query 30100 "Shpfy Shipment Location" | Shopify Connector | 20 to 27 |
| query 36950 "Power | PowerBI Reports | 25 to 26 |
| query 36951 "Power | PowerBI Reports | 25 to 26 |
| query 36952 Dimensions | PowerBI Reports | 25 to 26 |
| query 36953 "Items - PBI API" | PowerBI Reports | 25 to 26 |
| query 36954 "Account Categories" | PowerBI Reports | 25 to 26 |
| query 36955 "G\L Entries - Balance Sheet" | PowerBI Reports | 25 to 26 |
| query 36956 "G/L Entries - Closing" | PowerBI Reports | 25 to 26 |
| Pending, tag 26.0 | ||
| query 36957 "Customer Ledger Entries" | PowerBI Reports | 25 to 26 |
| query 36958 "G/L Account Categories" | PowerBI Reports | 25 to 26 |
| query 36959 "G/L Accounts" | PowerBI Reports | 25 to 26 |
| query 36960 "G/L Budget Entries - PBI API" | PowerBI Reports | 25 to 26 |
| query 36961 "G/L Budgets" | PowerBI Reports | 25 to 26 |
| query 36962 "G/L Entries - Income Statement" | PowerBI Reports | 25 to 26 |
| Pending, tag 26.0 | ||
| query 36963 "Vendor Ledg. Entries - PBI API" | PowerBI Reports | 25 to 26 |
| query 36964 "Assembly Headers - Order" | PowerBI Reports | 25 to 26 |
| query 36965 "Assembly Lines - Item" | PowerBI Reports | 25 to 26 |
| query 36966 Bins | PowerBI Reports | 25 to 26 |
| query 36967 "Value Entries - Item" | PowerBI Reports | 25 to 26 |
| query 36968 "Item Ledger Entries - PBI API" | PowerBI Reports | 25 to 26 |