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?

Report
All responses (
Answers (