Announcements
No record found.
Hello. I need to create a report using vscode where I retrieve information from the Item table to calculate the quantity and pending sales order from Sales Line, but I also need to calculate the 'Net Change' of all Customers within the same report. As seen below.
My idea is to present the data in two separate tables using the Report Builder, but I'm not sure how to use two unrelated DataItems (Item, Customer) in code.
Any advice?
Is this Dynamics 365 for Finance and Operations or Business Central Related query?
Irrespective of the System Nothing stops you to use data sources, which there are no direct relations. (assuming its SSRS ) So you can represent those as subreports inside your main report.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 608
André Arnaud de Cal... 591 Super User 2026 Season 1
CP04-islander 430
