General discussion

Hello, Does anyone have a macro to send automatic mail in IDEA.I am carrying out several daily test extractions, I must send the result by email in Excel, of course after exporting it, but I want to do it automatically, without going into each Excel generated and manually sending it from IDEA.
Do you have something out there that you can enlighten me on?

Greetings to all,
How can I make a script in IDEA to validate the ID or identity card of all the Bank's clients? Any ideas?

Hi All!
 
I'm trying to use @ replace to clean up a big Vendor Liost by replacing some common Company Names with "" (essentially removing the bits I don't want).
 
When I use Add Virtual Charachter and the parameters below, it removes parts of words, as well as whole words. How can I tell IDEA to replace Whole Words Only?
 
@replace(@replace(@replace(@replace(SUP_NAME, "CO", "" ),"AS", "" ),"AGENCY" ,  "" ),"AGENCIES" , "" ) 
 
In this example above "DALLAS COUNTY AUDITOR" becomes "DALL UNTY AUDITOR"

Hi Brian,
is there a limit how many cases a @compif function can handle or is there a a limit for the length of an equation?
Thanks in advance!

Hello everyone.
I recently placed a menu on the ribbon custormerize Ribbon that calls different macros, it happens that everything worked perfectly, but when I installed another laptop, it decides to go back again to recreate my menu, that is, install it again on the ribbon, but now every time I run a menu option, it throws an error: invalid macro name. When I go to the error line within the macro, this line is blank, and so for each menu option, always the same error.
That could be happening?

I test exceptions where i get results on a daily basis. These exceptions vary on various days. For example ivoices that were not taxed
I get these results in IDEA  daily. 
Monday i have a list of 9 invoices
Tuesday  15 invoices
wednesday 70 invoices
 
How would i go about showing this trend analysis based on daily results? Trend also can be based on monthly.

I test the use of cards and get the below results.
Monday

W_CARD_FLAG
NO_OF_RECS
NO_OF_RECS_PERCENT
NETWEIGHT_SUM
NETWEIGHT_SUM_PERCENT
STATUS

0
1051
47.41
9123.800
47.83
NO CARD USED

1
1166
52.59
9953.000
52.17
CARD USED

Tuesday

W_CARD_FLAG
NO_OF_RECS
NO_OF_RECS_PERCENT
NETWEIGHT_SUM
NETWEIGHT_SUM_PERCENT
STATUS

0
3000
30.00
302005.00
30.00
NO CARD USED

Hi Brian
Hope you are doing well
I got an error this morning with the same script that I have been running for a year. I never had this error before!
Would you please help me to solve it? I attached the error window and my python code.
 
Thanks,
 

Hi,
suppose I have an IDEA table where I have a string column. It contains strings and some of them start with a specific character pattern:
 
Column1
Thisisastringentry
anotherone
AB1Cstringcontainsapattern
doesnotcontain
AB1Cthisstringalsocontainspattern
AB1Cagain
 
 
Now I want to filter those entries that contain "AB1C". I would normally use @isini("AB1C",Column2).
 
 

Tengo una columna de que me traen fechas pero esta en formato Juliano JDE un ejemplo seria "118150" y eso significa "30/05/2018" para hacer esa conversión use la página de JDE edwards. Lo que quiero hacer es agregar un campo virtual y que me transforme esa fecha juliana y me de como resultado la fecha normal.