MSDyn365F&SCM: CFO Overview workspace

In this blog post I would like to provide you with some of the calculations that are used for the diagrams in the CFO Overview workspace.

Current ratio = [Current assets] / [Current liabilities]

Current assets = Actual operating for Account category IN {“CASH”,”CASHEQUIV”,”SHORTTERMINVEST”,”AR”,”INV”,”NOTESREC”,”WIP”,”PREPAIDEXP”,”OTHERCA” }

Account categories can be viewed using General ledger -> Chart of accounts -> Accounts -> Main account categories

Current liabilities = Actual operating for Account category IN {“AP”,”NOTESPAY”,”CURRENTMATLTD”,”TAXPAY”,”INTPAY”,”DIVPAY”,”LEASEPAY”,”SINKPAY”,”OTHERCURLIA”,”LONGTERMDEBT” }

Actual operating = Actuals credits positive for [Transaction Type] = “RegularOperating”

Actuals credits positive =

Actuals for [Account typical balance] = “Debit”

 – Actuals for [Account typical balance] = “Credit”

Actuals = SUM(AccountingCurrencyAmount)

AccountingCurrencyAmount is taken from:

1. SubledgerJournalAccountEntryDistribution,
2. SubledgerJournalAccountEntry, if there is no distribution for a SubledgerJournalAccountEntry,
3. GeneralJournalAccountEntry, if there is no SubledgerJournalAccountEntry, that means the GJE is not Source doc.

GeneralJournalAccountEntry can be viewed using General ledger -> Inquiries and reports -> Voucher transactions

SubledgerJournalAccountEntry – use View subledger journal button from the above form

Debt to total assets = [Current liabilities / [Total assets]

Total assets = [Actual operating] for Account category IN {“CASH”, “CASHEQUIV”, “SHORTTERMINVEST”,”AR”,”INV”,”NOTESREC”,”WIP”,”PREPAIDEXP”,”OTHERCA”, “LONGTERMINVEST”,”PPE”,”ACCUDEP”,”INTANASSET”,”OTHERASSET” }

EBIT = [Total revenue] – [Total operating expenses] + [Additional earnings]

Total revenue = [Actual operating] for Account category IN {“SALES”,”OTHERINC”,”SALESRETDIS”}

Total operating expenses = [Actual operating] for Account category IN {“COGS”,”SELLEXP”,”ADMINEXP”,”MANUEXP”,”TANDEEXP”,”PROJEXP”,”SALARYEXP”,”OTHEREMPEXP”,”INTEXP”,”TAXEXP”,”DEPREXP”,”OTHEREXP”,”CHRNOTUSEWORKCAP” }

Additional earnings = [Actual operating] for Account category IN {“REVNOTPRODWORKCAP”, “GAINLOSSASSET”,”AMORTINTAGASSET”}