Analysis Columns

Dynamics 365 BC Table ReferencePagesAAnalysis Columns

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/page7114

Page Name: Analysis Columns
Page Number: 7114
Page Type: Worksheet

Source Table Name: Analysis Column
Source Table Number: 7118

Show/hide columns in the Analysis Columns page

Seq.Control IDControl NameField No.Field NameEnabledEditableVisible
0228239834CurrentColumnName Search  truetruetrue
11391326823Column No. Search4Column No. SearchtrueTruetrue
22012346751Column Header Search5Column Header SearchtrueTruetrue
31927436930Item Ledger Entry Type Filter Search15Item Ledger Entry Type Filter SearchtrueTruefalse
4190249959Value Entry Type Filter Search16Value Entry Type Filter SearchtrueTruefalse
52089844501Invoiced Search18Invoiced SearchtrueTruetrue
61255977152Column Type Search6Column Type SearchtrueTruetrue

Available options are:

  • “Formula”
  • “Net Change”
  • “Balance at Date”
  • “Beginning Balance”
  • “Year to Date”
  • “Rest of Fiscal Year”
  • “Entire Fiscal Year”

72061700887Ledger Entry Type Search7Ledger Entry Type SearchtrueTruetrue

Available options are:

  • “Item Entries”
  • “Item Budget Entries”

81034384768Formula Search8Formula SearchtrueTruetrue
91148117429Show Opposite Sign Search10Show Opposite Sign SearchtrueTruetrue
1072143365Comparison Date Formula Search9Comparison Date Formula SearchtrueTruetrue
111941347655Analysis Type Code Search14Analysis Type Code SearchtrueTruetrue
121807067475Value Type Search17Value Type SearchtrueTruetrue

Available options are:

  • ” “
  • “Quantity”
  • “Sales Amount”
  • “Cost Amount”
  • “Non-Invntble Amount”
  • “Unit Price”
  • “Standard Cost”
  • “Indirect Cost”
  • “Unit Cost”

13655864187Show Search11Show SearchtrueTruetrue

Available options are:

  • “Always”
  • “Never”
  • “When Positive”
  • “When Negative”

141301066351Rounding Factor Search12Rounding Factor SearchtrueTruetrue

Available options are:

  • “None”
  • “1”
  • “1000”
  • “1000000”

151041270588Comparison Period Formula Search13Comparison Period Formula SearchtrueTruetrue
Dynamics 365 BC Table ReferencePagesAAnalysis Columns

Leave a Reply

Your email address will not be published. Required fields are marked *