Tips and Hints
A place for members to place any useful IDEA tips or hints.
Scripting.Dictionary
Forums
I recently saw this used in a script and thought it was pretty interesting. It allows you to use a dictionary in IDEAScript which could be very useful.
- Read more about Scripting.Dictionary
- Log in or register to post comments
How to call a IDEA macro from Excel VBA
Forums
Hi Brian, hi guys,
I am using this website since 2017 and it helped me a lot. Thanks a million! Since I have not found an answer yet I would like to post my question here. I am struggeling calling an IDEA macro from a VBA macro in Excel. I am pretty sure it is not that complicated and I will slap myselfe for not coming up with the solution . Can someone give me the correpsonding code snippet as example?
Many thanks in advance and happy friday everyone!
Dennis
- Read more about How to call a IDEA macro from Excel VBA
- 4 comments
- Log in or register to post comments
Pruebas en Área de HCM SAP
Forums
Buena tarde a todos estoy pensado en realizar prueban en el modulo de HCM y quisiera si alguien me puede dar ideas de algunas pruebas que ya hallan ejecutado en SAP agradeceria algunas ideas para ejecutar la pruebas y muchas gracias por la atencion.
- Read more about Pruebas en Área de HCM SAP
- Log in or register to post comments
How to avoid @isini false positives
Forums
Hi,
I'm using @isini to find the word "bar", however, it is bringing so many false positives (.i.e. "Barbara") that I would like to avoid. I remember having heard some tricks to solve this in one of the webinars, but I don't remember how and did not find my notes. Any suggestion?
- Read more about How to avoid @isini false positives
- 5 comments
- Log in or register to post comments
Merging Columns
Forums
Hello,
I wasn't sure where to look for this task. I have a database and it has 9 columns however, they are repeat column headers with their own sets of data. For example,
Check Num 1 Date 1 Amount 1 Check Num 2 Date 2 Amount 2 Check Num 3 Date 3 Amount 3
- Read more about Merging Columns
- 6 comments
- Log in or register to post comments
How do I break a single statement into multiple lines?
Forums
I'm trying to break down the following equation so it can all be seen in the IDEA scripting window:
Hiding files in IDEA File Explorer
Forums
I stumbled upon a (afaik) undocumented feature. The IDEA file explorer does not display IMD filenames starting with a dollar sign (e.g. $LEDGER.IMD). Nevertheless these files can be opened via IDEAscript.
- Read more about Hiding files in IDEA File Explorer
- 1 comment
- Log in or register to post comments
JDE Time
Forums
Convert JDE 6 digits time field to proper time
- Read more about JDE Time
- 3 comments
- Log in or register to post comments
Range of Dates
Forums
I have access to a table in our accounting software package and I'm trying to download transaction from 10/1/2019 to the current date. If I Import the table I get everything all the way back to 2006. Is there a way once I've imported it to strip out extra dates and only get what I need before exporting to excel? I'm in version 11.1.
- Read more about Range of Dates
- 1 comment
- Log in or register to post comments
NewRecords n times
Forums
How can you expand (duplicate, replicate, multiply) n times (tuples) each record on your database?
Example: From current situation to output required.
Current situation
db.original (matrix [3x5])
id_field
field1
field2
field3
multiplier_field
R39244
String1
- Read more about NewRecords n times
- 7 comments
- Log in or register to post comments