Business Central queries

267 queries, versions 17 to 29

200 of 267 queries, this page

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