This topic is about the table Twinfield.Twinfield.GeneralLedgerDetailsV3@tfd.
Based on the Offices table and Twinfield the user has access to 18 companies. Although in the transactions table only 1 company is imported in Power BI. Below is the request of Bridge Online.
What could be the reason why only 1 company is showing up.
Another client has almost same amount of companies but in the settings of the database the following is different:
Could that the reason why the other client is limited to 1 company?
Yes, as visible in the first screenshot there is only 1 partition selected (“1 partities geselecteerd” in the right column).
Selection of companies is done using the use statement as documented in:
