[deleted]

Thanks for the help Peter, but I am not following your instructions. What is the "connector" in SEI?

How do I get into the workbook to make edits when I'm trying to distribute an SEI worksheet? Or do I need to build the report in the excel add in and go from there?

Hi Pat,

You can add a condition in the job properties under the conditions tab. Your condition would basically be a count of records for yesterday's data and check if it's greater than 0. the condition would go against the process that is being used in the worksheet.

For instance if you are looking at sales invoices and your worksheet/report only includes yesterday's invoices and only invoice type CRM then you can add the following condition. If the count(*) = 0 then it won't run the schedule.


(
select count(*)
from myfolder.SINVOICE
where SIVTYP_0 = 'CRM'
and ACCDAT_0 = DATEADD(dd, DATEDIFF(dd, 0, GETDATE() -1),0)
) > 0

Thanks, can you clarify the myfoler.SINVOICE? Our main operating folder is titled production, but when I input from PRODUCTION.GACCENTRYD (using the GL posting of the invoice type) then I get an invalid SQL error.
@@Yesterday is my global variable for yesterday.
(select count(*)
from PRODUCTION.GACCENTRYD
where GACCENTRYD.TYP_0 = 'CSDIR'
and GACCENTRYD.ACCDAT_0='@@YESTERDAY')
>0

Your SQL looks OK but instead of using the variable @@YESTERDAY try

DATEADD(dd, DATEDIFF(dd, 0, GETDATE() -1),0)

without quotes. I assume that it doesn't translate the global variable first so just try SQL

That worked, I assume I can drop the -1 in the GETDATE formula to test it on today, so I will confirm it works>?

Correct

Thank you so much, this worked!