I am a novice in the field and currently in the learning phase. I have successfully utilized the studio to generate a basic report encompassing sales order details, customer names, product names, quantities ordered, and quantities delivered. However, I am encountering difficulties in incorporating the "onhand" data, which is stored in a separate warehouse application.

I am seeking guidance on how to establish a connection between the warehouse app and the sales order, similar to the referencing approach in T-SQL. This connection is essential for me to include the "onhand" information in my report, enhancing its comprehensiveness.

Additionally, I am curious about the procedure for adding the created report to the report list. I have constructed the report within the sales analysis model, and I would appreciate assistance on seamlessly integrating it into the report list.

Your expertise and assistance in addressing these challenges would be highly valuable to me. Thank you for your time and support.

if u want to contact me by whatsapp : +201005280559