Finance

Bus matrix

Account
Account
Account Name
Account No
Income Balance
Business Posting Group
Business Posting Group Code
Business Posting Group Description
Company
Company
Currency
Currency Code LCY
Selected Currency
Customer
Credit Limit Type
Customer
Customer Country
Customer Number
Customer Territory
Payment Terms
Customer Ledger
Customer Ledger Description
Customer Ledger DocumentNo
Customer Ledger DocumentType
Customer Ledger EntryNo
Detailed Customer Ledger Cust Ledger EntryNo
Detailed Customer Ledger Document No
Detailed Customer Ledger Document Type
Detailed Customer LedgerEntry No
Customer/Vendor Ledger
Aging Bucket
Cust Vend Document Type
Finance Reporting
Finance Statement Hierarchy
Finance Statement Line Name
Finance Statement Name
General Ledger
Closing Entries
General Ledger Budget
Budget Name
GL Transaction Details
GL Trans Description
GL Trans Document No
GL Trans Document Type
GL Trans Entry No
NAV Dimensions
Agentur Code
Agentur Name
Periods\Due Date
Due Date
Due Date YMD
Due Day Of Month
Due Month
Due Period
Due Quarter
Periods\Posting
Posting Date
Posting Day Of Month
Posting Month
Posting Period
Posting Quarter
Posting YMD
Posting Groups
Business Posting Group
Product Posting Group
Product Posting Group
Product Posting Group Code
Product Posting Group Description
Source
Source Code
Source Description
Vendor
Vendor
Vendor Country
Vendor Name
Vendor Number
Vendor Territory
Vendor Ledger
Vendor Ledger Description
Vendor Ledger Document No
Vendor Ledger Document Type
Vendor Ledger Entry No
Vendor Ledger EntryNo
Customer Ledger
Customer Balance x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Closed Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Closed Entry Count x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Credit Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Current Balance Due x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Current Balance Overdue x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Debit Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Overdue Entry Count x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Sales x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Total Number of Open Days x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Total Number of Overdue Days x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
General Ledger
GL Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL Amount RS x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL Credit Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL Debit Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL End Balance x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL Start Balance x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
General Ledger Budget
GL Budget Amount x x x x x x x x x x x x x x x x x x
GL Budget Amount LCY x x x x x x x x x x x x x x x x x x
GL Budget Amount RS x x x x x x x x x x x x x x x x x x
GL Budget Index x x x x x x x x x x x x x x x x x
GL Budget Index RS x x x x x x x x x x x x x x x x x
GL Budget Variance x x x x x x x x x x x x x x x x x
GL Budget Variance RS x x x x x x x x x x x x x x x x x
Vendor Ledger
Vendor Balance x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Closed Entry Count x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Credit Amount LCY x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Debit Amount LCY x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Overdue Entry Count x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Total Number of Open Days x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Total Number of Overdue Days x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x

Dimensions

    Account: The Number and Name of the General Ledger Account ((BC.G_L Account.No_) and (BC.G_L Account.Name))
    Account Name: The Name of the General Ledger Account (BC.G_L Account.Name)
    Account No: The Number of the General Ledger Account (BC.G_L Account.No_)
    Income Balance: Income Statement or Balance Sheet
    Business Posting Group: (BC.Gen_ Business Posting Group.Description)
    Business Posting Group Code: The Code for the Busines Posting Group (BC.Gen_ Business Posting Group.Code)
    Business Posting Group Description: The Description for the Busines Posting Group (BC.Gen_ Business Posting Group.Description)
    Company: Name of the Company [wdCompany.CompanyName]
    Currency Code LCY: Code for the Local Company Currency [wdCompany.CurrencyCodeLCY]
    Customer: The Number and Name of the Customer (BC.Customer.No_) (BC.Customer.Name)
    Credit Limit Type: Whether the Customer is With or Without Credit Limit ('With Credit Limit' or 'Without Credit Limit' - based on BC.Customer.Credit Limit (LCY))
    Customer Country: Hierarchy of the Customers Country (BC.Country_Region.Name) and the Customers Number and Name
    Customer Number: The Customer Number (BC.Customer.No_)
    Customer Territory: Hierarchy of the Customers Territory (BC.Territory.Name) and Customers Number and Name
    Payment Terms: Description of the Payment Terms (BC.Payment Terms.Description)
    Customer Ledger Description: (BC.Cust_ Ledger Entry.Description)
    Customer Ledger DocumentNo: (BC.Cust_ Ledger Entry.Document No_)
    Customer Ledger DocumentType: (BC.Cust_ Ledger Entry.Document Type)
    Customer Ledger EntryNo: (BC.Cust_ Ledger Entry.Entry No_)
    Aging Bucket: 'Not Due / On Time', '1-30 Days', '31-60 Days', '61-90 Days', 'Over 90 Days'
    Finance Statement Hierarchy: Hierarchy of Report Line Name and Account
    Closing Entries: 'Exclude Closing Entries' or 'Closing Entries only'
    Budget Name: (BC.G_L Budget Name.Name)
    Due Date: Date of Format YYYY-MM-DD
    Due Date YMD: Hierarchy of Year, Month and Date
    Due Day Of Month: The Day Number
    Due Month: Month Name
    Due Period: Hierarchy of Year, Quarter, Month, Date
    Due Quarter: The Quarter
    Posting Date: Date of Format YYYY-MM-DD
    Posting Day Of Month: The Day Number
    Posting Month: Month Name
    Posting Period: Hierarchy of Year, Quarter, Month, Date
    Posting Quarter: The Quarter
    Posting YMD: Hierarchy of Year, Month and Date
    Product Posting Group: (BC.Gen_ Product Posting Group.Description)
    Product Posting Group Code: (BC.Gen_ Product Posting Group.Code)
    Product Posting Group Description: (BC.Gen_ Product Posting Group.Description)
    Source Code: (BC.Source Code.Code)
    Source Description: (BC.Source Code.Description)
    Vendor: The Number and Name of a Vendor (BC.Vendor.No_) and (BC.Vendor.Name)
    Vendor Country: Hierarchy of the Vendor Country (BC.Country_Region.Name) and Vendor
    Vendor Name: Name of the Vendor (BC.Vendor.Name)
    Vendor Number: Number of the Vendor (BC.Vendor.No_)
    Vendor Territory: Hierarchy of the Vendor Territory (BC.Territory.Name) and the Vendor

Measures

Customer Balance
Aggregate function sum
Description ---
Format standard
Customer Ledger Amount
Aggregate function sum
Description The Ledger Amount in Local Company Currency for Customer (BC.Detailed Cust_ Ledg_ Entry.Amount (LCY))
Format standard
Customer Ledger Closed Amount
Aggregate function sum
Description The Ledger Closed Amount in Local Company Currency for Customer (BC.Detailed Cust_ Ledg_ Entry.Amount (LCY)) or 0
Format standard
Customer Ledger Closed Entry Count
Aggregate function sum
Description Count of Ledger Closed Entries for Customer
Format standard
Customer Ledger Credit Amount
Aggregate function sum
Description The Ledger Credit Amount in Local Company Currency for Customer (BC.Detailed Cust_ Ledg_ Entry.Credit Amount (LCY))
Format standard
Customer Ledger Current Balance Due
Aggregate function sum
Description ---
Format standard
Customer Ledger Current Balance Overdue
Aggregate function sum
Description ---
Format standard
Customer Ledger Debit Amount
Aggregate function sum
Description The Ledger Debit Amount in Local Company Currency for Customer (BC.Detailed Cust_ Ledg_ Entry.Debit Amount (LCY))
Format standard
Customer Ledger Overdue Entry Count
Aggregate function sum
Description The Ledger Count of Overdue Entries for Customer (BC.Cust_ Ledger Entry.Closed at Date) > (BC.Cust_ Ledger Entry.Due Date)
Format standard
Customer Ledger Sales
Aggregate function sum
Description The Ledger Sales in Local Company Currency for Customer (BC.Cust_ Ledger Entry.Sales (LCY))
Format standard
Customer Ledger Total Number of Open Days
Aggregate function sum
Description The Number of Days between the Posting Date and Closed at Date for Customer Ledger ((BC.Detailed Cust_ Ledg_ Entry.Posting Date) and (BC.Cust_ Ledger Entry.Closed at Date))
Format standard
Customer Ledger Total Number of Overdue Days
Aggregate function sum
Description The Number of Days between Due Date and Closed at Date for Customer Ledger (BC.Cust_ Ledger Entry.Due Date) and (BC.Cust_ Ledger Entry.Closed at Date))
Format standard
GL Amount
Aggregate function sum
Description The Amount for General Ledger Entry (BC.G_L Entry.Amount)
Format standard
GL Amount RS
Aggregate function sum
Description The GL Amount with the reverse sign given in the finance report setup
Format standard
GL Credit Amount
Aggregate function sum
Description The Credit Amount for General Ledger Entry (BC.G_L Entry.Credit Amount)
Format standard
GL Debit Amount
Aggregate function sum
Description The Debit Amount for General Ledger Entry (BC.G_L Entry.Debit Amount)
Format standard
GL End Balance
Aggregate function sum
Description The End (Ultimo) Balance Amount for General Ledger Entries based on Posting Date. All Ledger entries are summarized from first entry to selected posting period. Any GL dimensions can be used. (BC.G_L Entry.Amount)
Format standard
GL Start Balance
Aggregate function sum
Description The Start (Primo) Balance Amount for General Ledger Entries based on Posting Date. All Ledger entries are summarized from first entry to selected posting period. Any GL dimensions can be used. (BC.G_L Entry.Amount)
Format standard
GL Budget Amount
Aggregate function sum
Description The Budget Amount for General Ledger Budget (BC.G_L Budget Entry.Amount)
Format standard
GL Budget Amount LCY
Aggregate function sum
Description ---
Format standard
GL Budget Amount RS
Aggregate function sum
Description The GL Budget Amount with the reverse sign given in the finance report setup
Format standard
GL Budget Index - Calculation
Aggregate function
Description The index based on actual GL Amount divided by GL Budget (GL Amount / GL Budget Amount)
Format
GL Budget Index RS - Calculation
Aggregate function
Description The index based on actual GL Amount RS divided by GL Budget RS (GL Amount RS / GL Budget Amount RS)
Format
GL Budget Variance - Calculation
Aggregate function
Description The budget variance based on actual GL Amount and GL Budget Amount (GL Amount - GL Budget Amount)
Format
GL Budget Variance RS - Calculation
Aggregate function
Description The budget variance based on actual GL Amount RS and GL Budget Amount RS (GL Amount RS - GL Budget Amount RS)
Format
Vendor Balance
Aggregate function sum
Description ---
Format standard
Vendor Ledger Amount
Aggregate function sum
Description The Ledger Amount in Local Company Currency for Vendor (BC.Detailed Vendor Ledg_ Entry.Amount (LCY))
Format standard
Vendor Ledger Closed Entry Count
Aggregate function sum
Description The Count of Closed Entries for Vendor Ledger
Format standard
Vendor Ledger Credit Amount LCY
Aggregate function sum
Description The Ledger Credit Amount in Local Company Currency for Vendor (BC.Detailed Vendor Ledg_ Entry.Credit Amount (LCY))
Format standard
Vendor Ledger Debit Amount LCY
Aggregate function sum
Description The Ledegr Debit Amount in Local Company Currency for Vendor (BC.Detailed Vendor Ledg_ Entry.Debit Amount (LCY))
Format standard
Vendor Ledger Overdue Entry Count
Aggregate function sum
Description The Count of Overdue Entries for Vendor (BC.Vendor Ledger Entry.Closed at Date) > (BC.Vendor Ledger Entry.Due Date)
Format standard
Vendor Ledger Total Number of Open Days
Aggregate function sum
Description The Number of Days between Posting Date and Closed at Date for Vendor ((BC.Detailed Vendor Ledg_ Entry.Posting Date) and (BC.Vendor Ledger Entry.Closed at Date))
Format standard
Vendor Ledger Total Number of Overdue Days
Aggregate function sum
Description The Number of Days between Due Date and Closed at Date for Vendor ((BC.Vendor Ledger Entry.Due Date) and (BC.Vendor Ledger Entry.Closed at Date))
Format standard