Forum Discussion
journal entries
Hi! I am trying to analyze Jounral Entries in Microsoft BI. Some of the Journal Entries have multiple lines, and the balances will net to 0 (since they are JEs). I set up an IF statement to ensure I only saw the postive half of the entry thus showing me the true value. However, when I do this it only shows it hitting one of the accounts. Does anyone have a good way to anaylze jounral entries on BI?
5 Replies
v-yulgu-msftMicrosoft Employee
Hi Yuliana,
An example would be this below:
The identifying item is the "Journal Batch". I would like to sort it by "Main Account" so I am able to give a true value to what hit what account. If you have any other tips for anaylzying JEs I would love to learn. Thanks!
Data Area ID Year Month Posting Layer Posting Type Prefix Voucher Voucher Description Journal Batch Number Created By Accounting Date SK Created Date SK Financial Product Id Financial Market Id Financial Code Id Financial Type Id Financial Site Id Financial Department Id Main Account Id Name Amount ACClosing 50 2017 10 Current Ledger journal 50JV 50JV010112 \ Umb. Produktzugang Comfica \ 50B008254 a 20171003 20170927 N/A N/A N/A N/A N/A N/A 07100 - Anlagen in Bau 1,512.00 50 2017 10 Current Ledger journal 50JV 50JV010112 \ Umb. Produktzugang Denios \ 50B008254 b 20171003 20170927 N/A N/A N/A N/A N/A N/A 07100 - Anlagen in Bau 2,024.58 50 2017 10 Current Ledger journal 50JV 50JV010131 \ Consignment stock not invoiced \ 50B008278 b 20171001 20171001 N/A N/A N/A N/A N/A N/A 34620 - GRNI Manual Provisions -202,791.80 50 2017 10 Current Ledger journal 50JV 50JV010112 \ Umb. Produktzugang Comfica \ 50B008254 b 20171003 20170927 N/A N/A N/A N/A N/A N/A 28800 - Schwebende Geldbewegungen -1,512.00 50 2017 10 Current Ledger journal 50JV 50JV010127 \ Utilities Accrual Gas 09/2017 \ 50B008274 b 20171002 20170929 N/A N/A N/A N/A N/A N/A 30900 - Sonstige Rückstellungen 4,200.00 50 2017 10 Current Ledger journal 50JV 50JV010112 \ Umb. Produktzugang Denios \ 50B008254 b 20171003 20170927 N/A N/A N/A N/A N/A N/A 28800 - Schwebende Geldbewegungen -2,024.58 50 2017 10 Current Ledger journal 50JV 50JV010127 \ Utilities Accrual Electricity 09/2017 \ 50B008274 b 20171002 20170929 N/A N/A N/A N/A N/A N/A 30900 - Sonstige Rückstellungen 73,000.00 50 2017 10 Current Ledger journal 50JV 50JV010127 \ Utilities Accrual Gas 09/2017 \ 50B008274 d 20171002 20170929 N/A N/A N/A N/A N/A 4400 56100 - Gas -4,200.00 50 2017 10 Current Ledger journal 50JV 50JV010127 \ Utilities Accrual Electricity 09/2017 \ 50B008274 d 20171002 20170929 N/A N/A N/A N/A N/A 4400 56000 - Strom -73,000.00 50 2017 10 Current Ledger journal 50JV 50JV010131 \ Consignment stock not invoiced \ 50B008278 d 20171001 20171001 N/A N/A N/A N/A N/A N/A 11290 - Supplier Consignment – Manuell Adj 202,791.80 - v-yulgu-msft
