Table 9054 "Finance Cue"
Base Application · Microsoft.Finance.RoleCenters
Across versions
- BC23present
- BC249 fields added
- BC25unchanged
- BC261 fields changed
- BC27unchanged
- BC284 fields changed
- BC2924 fields changed
- BC30unchanged
Neighbourhood 37 connected objects and pages
Base Application · Microsoft.Finance.RoleCenters · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 9030 “Account Manager Activities” (12 Learn pages), Page 1315 “Accountant Portal Finance Cues” (1).
Properties
| Property | Value |
|---|---|
| Caption | Finance Cue |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Primary Key Δ BC26 | Code[10] | — | |
| 2 | Overdue Sales Documents Δ BC29 | Integer | Specifies the number of sales invoices where the customer is late with payment. | FlowField: count(“Cust. Ledger Entry” where(“Document Type” = filter(Invoice | “Credit Memo”), “Due Date” = field(“Overdue Date Filter”), Open = const(true))) |
| 3 | Purchase Documents Due Today Δ BC29 | Integer | Specifies the number of purchase invoices where you are late with payment. | FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice | “Credit Memo”), “Due Date” = field(“Due Date Filter”), Open = const(true))) |
| 4 | POs Pending Approval Δ BC29 | Integer | Specifies the number of purchase orders that are pending approval. | FlowField: count(“Purchase Header” where(“Document Type” = const(Order), Status = filter(“Pending Approval”))) |
| 5 | SOs Pending Approval Δ BC29 | Integer | Specifies the number of sales orders that are pending approval. | FlowField: count(“Sales Header” where(“Document Type” = const(Order), Status = filter(“Pending Approval”))) |
| 6 | Approved Sales Orders Δ BC29 | Integer | Specifies the number of approved sales orders. | FlowField: count(“Sales Header” where(“Document Type” = const(Order), Status = filter(Released | “Pending Prepayment”))) |
| 7 | Approved Purchase Orders Δ BC29 | Integer | Specifies the number of approved purchase orders. | FlowField: count(“Purchase Header” where(“Document Type” = const(Order), Status = filter(Released | “Pending Prepayment”))) |
| 8 | Vendors - Payment on Hold Δ BC29 | Integer | Specifies the number of vendor to whom your payment is on hold. | FlowField: count(Vendor where(Blocked = filter(Payment))) |
| 9 | Purchase Return Orders Δ BC29 | Integer | Specifies the number of purchase return orders that are displayed in the Finance Cue on the Role Center. The documents are filtered by today’s date. | FlowField: count(“Purchase Header” where(“Document Type” = const(“Return Order”))) |
| 10 | Sales Return Orders - All Δ BC29 | Integer | Specifies the number of sales return orders that are displayed in the Finance Cue on the Role Center. The documents are filtered by today’s date. | FlowField: count(“Sales Header” where(“Document Type” = const(“Return Order”))) |
| 11 | Customers - Blocked Δ BC29 | Integer | Specifies the number of customer that are blocked from further sales. | FlowField: count(Customer where(Blocked = filter(<> “ “))) |
| 16 | Overdue Purchase Documents Δ BC29 | Integer | Specifies the number of purchase invoices where your payment is late. | FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice | “Credit Memo”), “Due Date” = field(“Overdue Date Filter”), Open = const(true))) |
| 17 | Purchase Discounts Next Week Δ BC29 | Integer | Specifies the number of purchase discounts that are available next week, for example, because the discount expires after next week. | FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice | “Credit Memo”), “Pmt. Discount Date” = field(“Due Next Week Filter”), Open = const(true))); not editable |
| 18 | Purch. Invoices Due Next Week Δ BC29 | Integer | Specifies the number of payments to vendors that are due next week. | FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice | “Credit Memo”), “Due Date” = field(“Due Next Week Filter”), Open = const(true))); not editable |
| 19 | Due Next Week Filter | Date | — | FlowFilter |
| 20 | Due Date Filter | Date | — | FlowFilter; not editable |
| 21 | Overdue Date Filter | Date | — | FlowFilter |
| 22 | New Incoming Documents Δ BC28 Δ BC29 | Integer | Specifies the number of new incoming documents in the company. The documents are filtered by today’s date. | FlowField: count(“Incoming Document” where(Status = const(New), Processed = const(false))) |
| 23 | Approved Incoming Documents Δ BC29 | Integer | Specifies the number of approved incoming documents in the company. The documents are filtered by today’s date. | FlowField: count(“Incoming Document” where(Status = const(Released))) |
| 24 | OCR Pending | Integer | — | FlowField: count(“Incoming Document” where(“OCR Status” = filter(Ready | Sent | “Awaiting Verification”))) |
| 25 | OCR Completed Δ BC29 | Integer | Specifies that incoming document records that have been created by the OCR service. | FlowField: count(“Incoming Document” where(“OCR Status” = const(Success))) |
| 29 | Non-Applied Payments Δ BC29 | Integer | Specifies a window to reconcile unpaid documents automatically with their related bank transactions by importing a bank statement feed or file. In the payment reconciliation journal, incoming or outgoing payments on your bank are automatically, or semi-automatically, applied to their related open cu… | FlowField: count(“Bank Acc. Reconciliation” where(“Statement Type” = const(“Payment Application”))) |
| 30 | Cash Accounts Balance Δ BC29 | Decimal | Specifies the sum of the accounts that have the cash account category. | |
| 31 | Last Depreciated Posted Date | Date | — | FlowField: max(“FA Ledger Entry”.“FA Posting Date” where(“FA Posting Type” = const(Depreciation))) |
| 33 | Outstanding Vendor Invoices Δ BC29 | Integer | Specifies the number of invoices from your vendors that have not been paid yet. | FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice), “Remaining Amount” = filter(< 0), “Applies-to ID” = filter(‘’))); not editable |
| 34 | Total Overdue (LCY) + BC24 Δ BC28 | Decimal | Specifies the total overdue amount. via Page 1318 “Account Receivables KPIs” | FlowField: sum(“Detailed Cust. Ledg. Entry”.“Amount (LCY)” where( “Initial Entry Due Date” = field(upperlimit(“Overdue Date Filter”)) )) |
| 35 | Total Outstanding (LCY) + BC24 Δ BC28 | Decimal | Specifies the total outstanding amount. via Page 1318 “Account Receivables KPIs” | FlowField: sum(“Detailed Cust. Ledg. Entry”.“Amount (LCY)”) |
| 36 | Non Issued Reminders + BC24 Δ BC29 | Integer | Specifies the number of reminders that have been created but have not been issued yet. | FlowField: count(“Reminder Header” where(“Posting Date” = field(upperlimit(“Date Filter”)))) |
| 37 | Date Filter + BC24 | Date | — | FlowFilter |
| 38 | AR Accounts Balance + BC24 Δ BC28 | Decimal | A/R Accounts Balance caption | |
| 39 | Active Reminders + BC24 Δ BC29 | Integer | Specifies the number of reminders that are issued and still not paid. | FlowField: count(“Issued Reminder Header” where(Canceled = const(false))) |
| 40 | Reminders not Send + BC24 Δ BC29 | Integer | Specifies the number of reminders that have not been sent yet for the current level. | FlowField: count(“Issued Reminder Header” where(“Sent For Current Level” = const(false), Canceled = const(false))) |
| 41 | Active Reminder Automation + BC24 Δ BC29 | Integer | Specifies the number of automations configured for reminders. | FlowField: count(“Reminder Action Group” where(Blocked = const(false))) |
| 42 | Reminder Automation Failures + BC24 Δ BC29 | Integer | Specifies the number of failures that occured for the existing reminder automations. | FlowField: count(“Reminder Automation Error” where(Dismissed = const(false))) |
Keys
- Key1: Primary Key (clustered)
Procedures
1 local procedures, no public ones.
Relations
- Approved Incoming Documents: CalcFormula Table 130 “Incoming Document”
- New Incoming Documents: CalcFormula Table 130 “Incoming Document”
- OCR Completed: CalcFormula Table 130 “Incoming Document”
- OCR Pending: CalcFormula Table 130 “Incoming Document”
- Customers - Blocked: CalcFormula Table 18 “Customer”
- Overdue Sales Documents: CalcFormula Table 21 “Cust. Ledger Entry”
- Vendors - Payment on Hold: CalcFormula Table 23 “Vendor”
- Outstanding Vendor Invoices: CalcFormula Table 25 “Vendor Ledger Entry”
- Overdue Purchase Documents: CalcFormula Table 25 “Vendor Ledger Entry”
- Purch. Invoices Due Next Week: CalcFormula Table 25 “Vendor Ledger Entry”
- Purchase Discounts Next Week: CalcFormula Table 25 “Vendor Ledger Entry”
- Purchase Documents Due Today: CalcFormula Table 25 “Vendor Ledger Entry”
- Non-Applied Payments: CalcFormula Table 273 “Bank Acc. Reconciliation”
- Non Issued Reminders: CalcFormula Table 295 “Reminder Header”
- Active Reminders: CalcFormula Table 297 “Issued Reminder Header”
- Reminders not Send: CalcFormula Table 297 “Issued Reminder Header”
- Approved Sales Orders: CalcFormula Table 36 “Sales Header”
- Sales Return Orders - All: CalcFormula Table 36 “Sales Header”
- SOs Pending Approval: CalcFormula Table 36 “Sales Header”
- Total Outstanding (LCY): CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
- Total Overdue (LCY): CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
- Approved Purchase Orders: CalcFormula Table 38 “Purchase Header”
- POs Pending Approval: CalcFormula Table 38 “Purchase Header”
- Purchase Return Orders: CalcFormula Table 38 “Purchase Header”
- Last Depreciated Posted Date: CalcFormula Table 5601 “FA Ledger Entry”
- Active Reminder Automation: CalcFormula Table 6751 “Reminder Action Group”
- Reminder Automation Failures: CalcFormula Table 6754 “Reminder Automation Error”
Pages and codeunits on this table
- Page 1315 “Accountant Portal Finance Cues” (source table)
- Page 1318 “Account Receivables KPIs” (source table)
- Page 1319 “Reminder Cues” (source table)
- Page 9030 “Account Manager Activities” (source table)
- Page 9032 “Acc. Payables Activities” (source table)
- Page 9034 “Acc. Receivable Activities” (source table)
- Page 9036 “Bookkeeper Activities” (source table)
- Page 9037 “Accountant Activities” (source table)
Extended by
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Finance Cue"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.