web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

General Ledger Entry Duplicated in Report

(0) ShareShare
ReportReport
Posted on by 5

In Business Central, went into Company One and and created Journal Entry for $900 and gave it document number ZZZ.  Went into Company Two, created a Journal Entry for $888 and document number ZZZ.  I am using Power BI to report on this.  In the Company One General_Ledger_Entries table I see the entry for Document ZZZ as Entry #'s 9 and 10 and for the 888 amount.  In the Company Two General_Ledger_Entries table I see the entry for Document ZZZ for Entry #'s 9 and 10 for the 888 amount.

What is going on?  I expected to see the $900 in the Company One table and the $888 in Company Two table.  Except for the fact that I know that I opened the General_ledge_entries table from each separate company, they look identical.  Basically, my table/report is only showing the Company Two data...regardless of the company table I am looking at...

The question is: how do I get the right numbers (the 900 and 888 version), by Company, as I was expecting?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans