Forum Discussion

dgodley12's avatar
dgodley12
New Member
8 years ago

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 ...
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi dgodley12,

 

Please refer to this blog to provide more detailed information so that I can test for you.

 

Regards,

Yuliana Gu

  • dgodley12's avatar
    dgodley12
    New Member
    8 years ago

    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 IDYearMonthPosting LayerPosting TypePrefix VoucherVoucher DescriptionJournal Batch NumberCreated ByAccounting Date SKCreated Date SKFinancial Product IdFinancial Market IdFinancial Code IdFinancial Type IdFinancial Site IdFinancial Department IdMain Account Id NameAmount ACClosing
    50201710CurrentLedger journal50JV50JV010112 \ Umb. Produktzugang Comfica \50B008254a2017100320170927N/AN/AN/AN/AN/AN/A07100 - Anlagen in Bau1,512.00
    50201710CurrentLedger journal50JV50JV010112 \ Umb. Produktzugang Denios \ 50B008254b2017100320170927N/AN/AN/AN/AN/AN/A07100 - Anlagen in Bau2,024.58
    50201710CurrentLedger journal50JV50JV010131 \ Consignment stock not invoiced \ 50B008278b2017100120171001N/AN/AN/AN/AN/AN/A34620 - GRNI Manual Provisions-202,791.80
    50201710CurrentLedger journal50JV50JV010112 \ Umb. Produktzugang Comfica \ 50B008254b2017100320170927N/AN/AN/AN/AN/AN/A28800 - Schwebende Geldbewegungen-1,512.00
    50201710CurrentLedger journal50JV50JV010127 \ Utilities Accrual Gas 09/2017 \ 50B008274b2017100220170929N/AN/AN/AN/AN/AN/A30900 - Sonstige Rückstellungen4,200.00
    50201710CurrentLedger journal50JV50JV010112 \ Umb. Produktzugang Denios \ 50B008254b2017100320170927N/AN/AN/AN/AN/AN/A28800 - Schwebende Geldbewegungen-2,024.58
    50201710CurrentLedger journal50JV50JV010127 \ Utilities Accrual Electricity 09/2017 \ 50B008274b2017100220170929N/AN/AN/AN/AN/AN/A30900 - Sonstige Rückstellungen73,000.00
    50201710CurrentLedger journal50JV50JV010127 \ Utilities Accrual Gas 09/2017 \ 50B008274d2017100220170929N/AN/AN/AN/AN/A440056100 - Gas-4,200.00
    50201710CurrentLedger journal50JV50JV010127 \ Utilities Accrual Electricity 09/2017 \ 50B008274d2017100220170929N/AN/AN/AN/AN/A440056000 - Strom-73,000.00
    50201710CurrentLedger journal50JV50JV010131 \ Consignment stock not invoiced \ 50B008278d2017100120171001N/AN/AN/AN/AN/AN/A11290 - Supplier Consignment – Manuell Adj202,791.80
    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi dgodley12,

       

      What is your desired output based on above table?

       

      Regards,

      Yuliana Gu

      • dgodley12's avatar
        dgodley12
        New Member
        8 years ago

        my desired output is to be see the true value hitting each account