JustNil
Member
Hello, Everyone.
I hope this message finds you well. I am new to this community and eager to expand my knowledge in automation. Currently, I am working with a JDE 8.12 system, and I have a specific report (R5703B802) that I would like to automate using a VBA macro tool in Microsoft Excel.
I have already requested an Oracle account in our database and once approved, I will be able to establish a connection using SQL Developer application. However, I am unsure about the specific forms/controls I need to set up in my tool to run this report, as it requires filling up parameters on three subsequent screens.
I am reaching out to seek guidance and insights from experienced members on how I can achieve this automation effectively. Any help or advice on navigating the JDE screens, invoking the report's Business Function, and extracting the data would be highly appreciated.
Thank you so much in advance for your valuable input, and I look forward to being an active member of this community.
I hope this message finds you well. I am new to this community and eager to expand my knowledge in automation. Currently, I am working with a JDE 8.12 system, and I have a specific report (R5703B802) that I would like to automate using a VBA macro tool in Microsoft Excel.
I have already requested an Oracle account in our database and once approved, I will be able to establish a connection using SQL Developer application. However, I am unsure about the specific forms/controls I need to set up in my tool to run this report, as it requires filling up parameters on three subsequent screens.
I am reaching out to seek guidance and insights from experienced members on how I can achieve this automation effectively. Any help or advice on navigating the JDE screens, invoking the report's Business Function, and extracting the data would be highly appreciated.
Thank you so much in advance for your valuable input, and I look forward to being an active member of this community.