Hi all,
We recently started to use Business Central 365. We use the G/L entry ODATA query to feed our reporting tool. To (within this reporting tool) identify intercompany Accounts Receivable and Accounts Payable positions, we look at the Source Type & Source No. of the G/L entries on specific ledgers..
We've run into the following issue. A lot of intercompany positions are in foreign currency. When we "Adjust Exchange Rates", limited to "Adjust Customer, Vendor and Bank Accounts". Only a few G/L entries are made and hundreds of Detailed Customer Ledger Entries.
The issue with the G/L entries is that these lack information, the Source Type & Source No. is blank (see snap attached), because it's an aggregated total of the Detailed Customer Ledger Entries.
Preferable we'd like to see all individual Detailed Customer Ledger Entries as G/L entries. However, we've been told that the above is standard BC365 functionality and can not be adjusted.
Do you have any recommendations on this?
Thanks a lot!
Bart
