Nov 6, 2019 · hello, I'd like to know if you had the chance to connect excel macro to JDE. I'm trying to create Argentina's taxes flat files directly from excel to reduce costs and time. Did you?

Oct 31, 2003 · We are using Excel+simple macros to pull data from OneWorld through MS Querry and ODBC/ODA with no problems. It works fine both Fat Client and through Citrix. We find it a great way to do fast ad-hoc reporting and querys.

Apr 4, 2007 · We use JDEdwards for our General Ledger and was wondering if anyone has linked JDE macros with Excel macros? I would love to be able to use the 2 together by possibly using sendkeys from Excel to do data entry for me?

Apr 8, 2013 · Hi, As part of my job I have to copy and paste machine hours from an Excel document in to JDE. I have written a really helpful Macro to make the process quick however I would like to assign the Macro to a key stroke.

Jan 15, 2010 · use a tool to transform the data from Excel into a .txt file (csv) (I have seen an Excel macro that you can run to transform the data in CSV somewhere at Oracle support (E1: 47: Flat File Creation Procedure (Xe/8.0))

Jul 27, 2023 · 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.

To verify the outcome of each query, you should run each one first using the non-ODA JD Edwards EnterpriseOne data source and then use the ODA data source and compare the results. This section discusses how to use Microsoft Excel to create and run a query.

Oct 16, 2019 · Here is everything you need to create a spreadsheet that can call JDE functionality via orchestration.

Nov 2, 2012 · Hello, I'm hoping someone may be able to point me in the right direction with this; I currently have a column of data in Excel that can range from typically 50-80 cells to upwards of 100s and I need a way to take each value one at a time and move it to a textbox in JDE and hit "Submit" so that it is added to the listbox and repeat this until it ...

I have seen a video using excel sheet to upload data into JDE , i need to know the required tools and how to link an excel with jde