25个公司，9个国家/地区，6种功能货币...报告系统和程序很容易变得复杂且昂贵。但是，我们从用户的角度，特别是根据国际标准（以下称为IFRS）编制合并财务报表和管理报告的专家的角度，从技术角度出发找到了一种简单的解决方案。

很多时候，“金融家”和“技术人员”彼此不了解。结果，出现了不合理的复杂，昂贵和不便的解决方案。在本文中，我们将以公司报告流程为例，解释一些基本的东西，而这些东西的缺乏理解通常会阻止创建有效的解决方案。我们还将介绍在创建报告系统方面的成功经验-我们想要做什么，发生了什么，我们从结果中不满意的地方，我们将对其进行更改。

我们会立即警告您-既不会涉及区块链，也不会涉及大数据，也不会涉及人工智能和其他时尚技术。出于一个简单的原因，我们没有使用任何这些方法-在此任务中我们不需要它们。

您需要什么才能获得“输出”

, . , .

, Google:

INCOME STATEMENT ( ):

Fiscal year is January-December. All values USD Millions.	2018	2017	2016	2015	2014
Sales/Revenue	136,958	111,024	89,733	73,59	65,83
Sales Growth	23.36%	23.73%	21.94%	11.79%	-
Cost of Goods Sold (COGS) incl. D&A	59,549	45,583	35,138	28,164	25,691
COGS excluding D&A	50,514	38,668	28,994	23,101	20,712
Depreciation & Amortization Expense	9,035	6,915	6,144	5,063	4,979
Depreciation	8,164	6,103	5,267	4,132	3,523
Amortization of Intangibles	871	812	877	931	1,456
COGS Growth	30.64%	29.73%	24.76%	9.63%	-
Gross Income	77,409	65,441	54,595	45,426	40,139
Gross Income Growth	18.29%	19.87%	20.18%	13.17%	-

BALANCE SHEET ( ):

Fiscal year is January-December. All values USD Millions.	2018	2017	2016	2015	2014
Cash & Short Term Investments	109,14	101,871	86,333	73,066	64,395
Cash Only	16,701	10,715	12,918	16,549	18,347
Short-Term Investments	92,439	91,156	73,415	56,517	46,048
Cash & Short Term Investments Growth	7.14%	18.00%	18.16%	13.47%	-
Cash & ST Investments / Total Assets	46.88%	51.63%	51.54%	49.55%	49.85%
Total Accounts Receivable	21,193	18,705	14,232	13,909	10,849
Accounts Receivables, Net	20,838	18,336	14,137	11,556	9,383
Accounts Receivables, Gross	21,567	19,01	14,604	11,852	9,608
Bad Debt/Doubtful Accounts	-729	-674	-467	-296	-225
Other Receivables	355	369	95	2,353	1,466
Accounts Receivable Growth	13.30%	31.43%	2.32%	28.21%	-
Accounts Receivable Turnover	6.46	5.94	6.31	5.29	06.07
Inventories	1,107	749	268	491	-
Finished Goods	1,107	-	-	-	-
Other Current Assets	4,236	2,983	4,575	2,648	3,412
Miscellaneous Current Assets	4,236	2,983	4,575	2,648	3,412
Total Current Assets	135,676	124,308	105,408	90,114	78,656

, — / , .

, .

? . , , 100 . , , , . (, , , ) , .

— , , , ..

, . , .

. .

,

() . , , , , . .
— — , , .
, , .
— ( / ).

() : , 100 , — 146 … , . , , ( , , , ), .

, . , , (, ..) — , « » («cooking the books» / «window dressing»).

: , . / — .

, , , .

ERP Microsoft Dynamics NAV ( — NAV), . ERP NAV.

NAV , . .

( ), NAV Excel, Pivot Table. — .

, — Power Pivot, Excel.

, , . .

M — LucaNet Microsoft Analysis Services ( Microsoft SQL Server).

Analysis Services (NAV Microsoft SQL Server), . — LucaNet . , Analysis Services — , ( , LucaNet), .

Analysis Services — Tabular Multidimensional. Multidimensional, .

, OLAP , Excel. Pivot Table, .

, Reporting Services — Microsoft SQL Server.

NAV (W1) .

( , , ..) Master Data Management, .

( ) , ( ).

— (). — , . — , , .. , , .

NAV , , . , .

, — , , . , , .

— — . , .

(, ) , NAV , , , , .

( ).

, « » — GENERAL IFRS.

, , «IFRS».

, , — «IFRS».

, — . «» .

( — ERP , — ) . EUR ( ) — . EUR — — EUR.

« » . , NAV.

«» .

. — EUR. , EUR, EUR.

NAV ( ). , — USD, USD, — EUR, EUR.

NAV . , , , — EUR , .

( ).

( , ..) EUR.

(, ..), , ( , ..) NAV.

NAV ( ) .

NAV , , DWH (Data WareHouse — ). , .

OLAP .

Excel .

Tableau ( ), . Excel .

«» , . — .

, :

. , - .
, — , , . «» — .

, NAV . NAV . , . . ( ).

. ( NAV) . 10 — 15 .

, :

MS NAV

数据库中的MS NAV表

财务会计的关键是G_L条目表。

, : [CRONUS International Ltd_$G_L Entry], «CRONUS International Ltd» — . — . . NAV . «G_L Entry».

[Entry No_] [int] — ,
[G_L Account No_] [nvarchar](20) — — ,
[Posting Date] [datetime] — ,
[Document Type] [int] — (, , ..),
[Document No_] [nvarchar](20) — ,
[Amount] [decimal](38, 20) — ,
[Transaction No_] [int] — , , ( , ),
[Debit Amount] [decimal](38, 20) — ,
[Credit Amount] [decimal](38, 20) — ,
[Additional-Currency Amount] [decimal](38, 20) — ,
[Add_-Currency Debit Amount] [decimal](38, 20) — ,
[Add_-Currency Credit Amount] [decimal](38, 20) — ,
[Dimension Set ID] [int] — .

«G_L Entry» ( NAV, ):

[Amount] = [Debit Amount] — [Credit Amount]
[Amount] , [Transaction No_] [Posting Date], ( « »).
[Transaction No_] [Posting Date] [Entry No_] ( , ).
[Additional-Currency Amount], [Add_-Currency Debit Amount] [Add_-Currency Credit Amount].

«G_L Account». , ( ) . «G_L Entry» [GL Account No]. «G_L Account» :

[No_] [nvarchar](20) — , «G_L Entry» [G_L Account No_],
[Name] [nvarchar](50) — ,
[Exchange Rate Adjustment] [int] — , ,
[Account Subcategory Entry No_] [int] — .

«G_L Account Category» .

[Entry No_] [int] IDENTITY(1,1) — ,
[Parent Entry No_] [int] — ,
[Presentation Order] [nvarchar](100) — () ,
[Indentation] [int] — ,
[Description] [nvarchar](80)- ,
[Account Category] [int] — (Assets, Liabilities, Equity, Income, Cost of Goods Sold, Expense),
[Income_Balance] [int] — , / .

«», «G_L Entry».

«Dimension Set Entry», «» :

[Dimension Set ID] [int] — , «G_L Entry»,
[Dimension Code] [nvarchar](20) — ,
[Dimension Value Code] [nvarchar](20) — .

«Dimension Value», ( ):

[Dimension Code] [nvarchar](20) — ,
[Code] [nvarchar](20) — , «Dimension Set Entry» [Dimension Value Code]
[Name] [nvarchar](50) — .

«Dimension Set Entry» «Dimension Value» — [Dimension Code] [Dimension Value Code] ([Code]).

. «G_L Entry».

— , . , , .

, ?

1 ():

, 136,958, «INCOME STATEMENT» ( ) «2018» «Sales/Revenue». , :

«G_L Account Category» , [Description] «Sales/Revenue».
«G_L Account» , [Account Subcategory Entry No_] [Entry No_] «G_L Account Category», 1.
«G_L Entry» (), [G_L Account No_] [No_] «G_L Account», 2.
3 , [Posting Date] 2018 , [Posting Date] ‘2018.01.01’ [Posting Date] ‘2018.12.31’.
4 [Amount], — .

2 ():

16,701, «BALANCE SHEET» ( ) «2018» «Cash Only», :

«G_L Account Category» , [Description] «Cash Only».
«G_L Account» , [Account Subcategory Entry No_] [Entry No_] «G_L Account Category», 1.
«G_L Entry» (), [G_L Account No_] [No_] «G_L Account», 2.
3 , [Posting Date] 2018 , . [Posting Date] ‘2018.12.31’.
4 [Amount], — .

3 ():

136,958, «INCOME STATEMENT» «2018» «Sales/Revenue», (), :

«G_L Account Category» , [Description] «Sales/Revenue».
«G_L Account» , [Account Subcategory Entry No_] [Entry No_] «G_L Account Category», 1.
«G_L Entry» (), [G_L Account No_] [No_] «G_L Account», 2.
3 , [Posting Date] 2018 , [Posting Date] ‘2018.01.01’ [Posting Date] ‘2018.12.31’.
4 [Dimension Set ID] «Dimension Set Entry», [Dimension Code] ‘COUNTRY’ ( — ). «G_L Entry» ( [Dimension Set ID]) «» — NAV. , «» «G_L Entry» .
5 [Dimension Code] [Dimension Value Code] «Dimension Value» [Name] ( ). «» G_L Entry» ( ) — , ‘NA’ (not allocated / not applicable).
4 «G_L Entry» , 6, [Amount], — ( ‘NA’) .

, . Excel OLAP .

. Excel, .

, — , . , , , , .

, .

, , “” ( ). , , .
() , ( , , , ..).
“” () , .
. — (). Excel .
上载到报告系统时，我们不会汇总数据。每笔财务交易（具有唯一的标识符）在报告系统中作为单独的条目显示。

谢尔盖· 乌斯斯蒂诺夫·
达里亚·法德耶娃（FCCA）

我们如何生成合并财务报表？

您需要什么才能获得“输出”

,

数据库中的MS NAV表

More articles: