Business Central queries

IdNameAppVersionsObsoleteSource
1Distinct Items SoldBase Application27-28-29
2Customer Interaction Stats.Base Application27-28-29
3Customer Sales per PeriodBase Application27-28-29
4Distinct Items PurchasedBase Application28-29
19VAT Entries Base Amt. SumBase Application17-28-29
21Cust. Ledg. Entry Remain. Amt.Base Application17-28-29
22Cust. Remain. Amt. By Due DateBase Application17-28-29
25Vend. Ledg. Entry Remain. Amt.Base Application17-28-29
33Recon. Cust. Posting Gr. SumBase Application28-29
34Recon. Vend. Posting Gr. SumBase Application28-29
35Customer Debit Credit AmountBase Application28-29
36Vendor Debit Credit AmountBase Application28-29
37RemQtyBaseInvtItemSalesLineBase Application27-28-29
39RemQtyBaseInvtItemPurchaseLineBase Application27-28-29
50Power BI Customer ListBase Application17-28-29
51Power BI Vendor ListBase Application17-28-29
52Power BI Item Purchase ListBase Application17-28-29
53Power BI GL Amount ListBase Application17-28-29
54Power BI Jobs ListBase Application17-28-29
55Power BI Sales ListBase Application17-28-29
56Power BI Purchase ListBase Application17-28-29
57Power BI Item Sales ListBase Application17-28-29
58Power BI GL Budgeted AmountBase Application17-28-29
59Power BI Top Cust. OverviewBase Application17-28-29
60Power BI Sales Hdr. Cust.Base Application17-28-29
61Power BI Cust. Item Ledg. Ent.Base Application17-28-29
62Power BI Cust. Ledger EntriesBase Application17-28-29
63Power BI Vendor Ledger EntriesBase Application17-28-29
64Power BI Purchase Hdr. VendorBase Application17-28-29
65Power BI Vend. Item Ledg. Ent.Base Application17-28-29
100Top Customer OverviewBase Application17-28-29
101Sales DashboardBase Application17-28-29
102Item Sales by CustomerBase Application17-28-29
103Item Sales and ProfitBase Application17-28-29
104Sales Orders by Sales PersonBase Application17-28-29
105Sales OpportunitiesBase Application17-28-29
106Segment LinesBase Application17-28-29
115Sales Shipped Not Invoiced LCYBase Application26-28Pending 28.029
123Fixed Assets AnalysisBase Application25-28-29
124Sales Order AnalysisBase Application27-28-29
130Posted Docs. With No Inc. Doc.Base Application17-28-29
133Inc. Doc. Atts. Ready for OCRBase Application17-28-29
134OCR VendorsBase Application17-28-29
135OCR Vendor Bank AccountsBase Application17-28-29
141EU VAT EntriesBase Application17-28-29
200Purchase Invoices By OrderBase Application23-28-29
201Sales Invoices By OrderBase Application23-28-29
202Service Invoices By OrderBase Application23-28-29
203Item Ledger Entry TypesBase Application26-28-29
204Purch. Cr. Memos By Ret. OrderBase Application23-28-29
205Sales Cr. Memos By Ret. OrderBase Application23-28-29
250G/L Entry DimensionsBase Application17-28-29
251G/L Budget Entry DimensionsBase Application17-28-29
252Analysis View Entry DimensionsBase Application17-28-29
253Analysis View Budg. Entry DimsBase Application17-28-29
256CF Forecast Entry DimensionsBase Application17-28-29
257Dimension SetsBase Application17-28-29
260Dimension Set EntriesBase Application17-28-29
261G/L EntriesBase Application17-28-29
262Cust. Ledger EntriesBase Application17-28-29
263Vendor Ledger EntriesBase Application17-28-29
264Bank Account Ledger EntriesBase Application17-28-29
265Item Ledger EntriesBase Application17-28-29
266Value EntriesBase Application17-28-29
267FA Ledger EntriesBase Application17-28-29
268Job Ledger EntriesBase Application17-28-29
269Res. Ledger EntriesBase Application17-28-29
270G/L Budget EntriesBase Application17-28-29
302Item Application EntriesBase Application27-28-29
303Item Application Entries Inb.Base Application27-28-29
304Item Application Entries Outb.Base Application27-28-29
410Analysis View SourceBase Application17-28-29
472Failed Job Queue EntryBase Application17-28-29
486ProjectsAnalysisBase Application25-28-29
487Project Planning AnalysisBase Application27-28-29
488Purch. Order Perf. AnalysisBase Application27-28-29
520Item By Lot No. Res.Base Application18-28-29
521Item By Lot No. Item Ledg.Base Application18-28-29
522Qty. Reserved From Item LedgerBase Application22-28-29
523Sales Reserv. From Item LedgerBase Application26-28-29
760Trailing Sales Order QryBase Application17-28-29
762Acc. Sched. Line Desc. CountBase Application17-28-29
763Colm. Layt. Colm. Header CountBase Application17-28-29
770Analysis Line Desc. CountBase Application17-28-29
771Analysis Column Header CountBase Application17-28-29
773Users in User GroupsBase Application17-24, gonePending 22.0-
774Users in PlansSystem Application17-28-24-29
775PlanSystem Application17-28-24-29
776DeviceSystem Application18-28-24-29
777Role Center from PlansSystem Application23-28-24-29
901RemQtyBaseInvtItemAssemblyLineBase Application27-28-29
984Get Time Sheet LinesBase Application24-28-29
985Get Time Sheet Archive LinesBase Application24-28-29
986Time Sheet Line Status CountBase Application26-28-29
1003RemQtyBaseInvtItemJobPlannLineBase Application27-28-29
1033GetJobPlanningLinesBase Application26-28-29
1038Job Task by Bill-to CustomerBase Application28-29
1232Data Exch. Field DetailsBase Application17-28-29
1252Bank Rec. Match CandidatesBase Application17-23, gonePending 21.0-
1302Sales Outstd. Amount On VATBase Application17-28-29
1310Cust. Ledg. Entry SalesBase Application17-28-29
1311Top 10 Customer SalesBase Application17-28-29
1312Num CustLedgEntries per CustBase Application17-28-29
1313Purch. Outstd. Amount On VATBase Application17-28-29
1316Value Item Ledger EntriesBase Application21-28-29
1319Sales by Cust. Grp. Chart Mgt.Base Application20-28-29
1501Workflow InstanceBase Application17-28-29
1502Workflow DefinitionBase Application17-28-29
1511User IDs by Notification TypeBase Application17-28-29
2900Item With VariantsBase Application20-28-29
2901Item With LocationsBase Application20-28-29
2902Item With Variants & LocationsBase Application20-28-29
3688BOM Component ItemsBase Application17-28-29
3689Item Production BOMsBase Application17-28-29
3691Production BOM & Line DetailsBase Application17-28-29
5001Locations from items SalesBase Application17-28-29
5002Locations from items PurchBase Application17-28-29
5400Delayed Prod. Orders - by CostBase Application17-28-29
5401Pending Prod. Orders - by CostBase Application17-28-29
5402Top-10 Prod. Orders - by CostBase Application17-28-29
5403My Prod. Orders - By CostBase Application17-28-29
5404My Delayed Prod. OrdersBase Application17-28-29
5407RemQtyBaseInvtItemProdOrdCompBase Application27-28-29
5480Customer Sales EntityBase Application17-28-29
5481Vendor Purchases EntityBase Application17-28-29
5502Tax Groups For Tax AreasBase Application17-28-29
5741RemQtyBaseInvtItemTransferLineBase Application27-28-29
5756Grouped Item Ledger EntriesBase Application24-28-29
5833Item to Value EntriesBase Application28-29
5840Avg. Cost Entry Points Not AdjBase Application26-28-29
5842Residual Amount - ItemsBase Application26-28-29
5896Calculate Actual Material CostBase Application20-28-29
5900Service AnalysisBase Application25-28-29
5902RemQtyBaseInvtItemServiceLineBase Application27-28-29
6502Items With Expiration DateBase Application17-28-29
7150Item Analysis View SourceBase Application17-28-29
7300Lot Numbers by BinBase Application17-28-29
7301Whse. Employees at LocationsBase Application17-28-29
7302Bin Content by Item TrackingBase Application27-28-29
7314CalcRsvQtyOnPicksShipsWithITBase Application20-28-29
7315CalcQtyOnBlockedITOnSNQueryBase Application21-28-29
7316CalcQtyOnBlockedITOnLNQueryBase Application21-28-29
7317CalcQtyOnBlockedITOnPNQueryBase Application21-28-29
7318CalcQtyInWhseEntriesBase Application21-28-29
7319CalcPickableQtyFromWhseEntryBase Application23-28-29
7320CalcQtyInReservEntryBase Application21-28-29
7321Summarized Stock By Item Trkg.Base Application22-28-29
7323CalcOutstandQtyOnWhseActLineBase Application23-28-29
7345Avail Qty. (Base) In QC BinsBase Application17-28-29
7346Whse. Entry Tracking DistinctBase Application28-29
8888Outbox EmailsSystem Application20-28-24-29
8889Sent EmailsSystem Application20-28-24-29
8890Email Related RecordSystem Application20-28-24-29
9059Service Header Doc. Type CountBase Application17-28-29
9060Count Sales OrdersBase Application17-28-29
9063Count Purchase OrdersBase Application17-28-29
9088Top 10 Vendor PurchasesBase Application27-28-29
9089Purchase by Vendor GroupBase Application27-28-29
9150My CustomersBase Application17-28-29
9151My VendorsBase Application17-28-29
9152My ItemsBase Application17-28Pending 27.029
9153Non-Inventory TelemetryBase Application19-28-29
37015Inventory by LocationBase Application26-28-29