Search results for query: *

Thanks for the info. I did find a way to link them in EEM. In the first query I created, in the columns tab, I added the field that I wanted to link in both queries. I named it something unique like (creditornumberlink). Then on the second query, in the filters tab, I added that same field...

I have 2 queries created...one that has detail payment information for a vendor (invoice, date, amount, etc). The second query only shows the total amount paid to the vendor. I need to include both these queries in an event on the email tab so that the vendor will receive an email that shows...

Thanks to you both for the info.

Does anyone know what tables the AP Check History Report uses? It's a crystal report, but it seems that Exact has created a temp table to house that info, therefore I can't use that table. What I'm trying to do is create a sql statement (to use in Event Manager) to notify vendors (via email)...

Jay, That's exactly what I needed! Thanks so much for sharing the script w/ me. Laura lrousey@dnpribbons.com

Hi. Does anyone know if there is a report in macola that will show only the records that are out of balance between the IMINVLOC table and the IMINVBIN table? Has anyone created a sql script or report that returns these records? I've tried to create a crystal report. I had to create a sub...

Thanks for the info! It was very helpful! Laura

Does anyone know what the termstring function does? I'm finding it in one of my Integrated Crystal Reports (stock status report). I can't find anything on Exact's website nor on the internet in general. Here's the formula that I am seeing: termstring(79720, "product category"). Thanks...

No, we are not using forced demand. We are however entering our OE order number into the reference field in the POP manual entry screen when we create the order.

I need a report that will show when an OE order was entered into the system, when the POP order for the OE order was created, and when the POP production was reported. Does anyone have a report similar to this? Thanks in advanced! Laura Rousey

I'm getting the following error message when trying to test one of my email accounts that I set up in Event Manager: General SMTP Mail Failure, check setup - 6000 Has anyone else run across this error? I can't find any information on macola's website. Any help would be greatly appreciated...

In Crystal versions 8.5 and before, there is a compiled report feature which is not available in Crystal Reports 10. Can someone tell me how to deploy reports to my users so that they can enter parameters and process the report themselves. Any help would be greatly appreciated! Thanks. Laura

I am on Vista OS and using eSynergy. Seems to work ok except when I try to create a new document within eSynergy. The save, draft, preview, etc tabs are not active (grayed out). I can go to another computer that is running XP, log on, and the tabs are active. If anyone else has run into this...

We are looking at moving our eSynergy server to a colo facility. We want to separate our ES data (in our office) from the eSynergy data. We would have to upload the ES data several times a day to the eSynergy server at the colo facility. Does anyone have eSynergy and ES set up like this? Any...

I need to generate a list of roles and what each of those roles can do (rights) that each of my resources has in Macola ES. Does anyone know how to do that? I've looked at the following tables, but I'm not having much luck at making any sense of it: pwrole, pwrprm, and pwfunc. Any help...

Does anyone know what the process idsmai32.exe does? I know that it's part of Event Manager. It's using up a good deal of my processor when it runs. Thanks! L.R.

We are on Macola ES 360 Version 4.0.0.323. Some of our OE customer due dates are showing the same as their invoice date, even if there terms are different (say Net30). It's very sporadic. One customer may have 10 invoices...the due date may be correct on 9 of them, but wrong on 1. It's...

I figured out what I needed to add to the script. I made an Inner Join on the cicmpy table. Thanks again for your help!

The script that you sent does not show which cus_no or cus_name was changed. How can I add that to the script? Thanks!

I do have Event Manager. I plan on using it to notify my users when a customer has been taken off hold. Thanks.