Data Directive-- setting a field AFTER a report is generated, not during or before

Epicor ERP 10
1

A user asked me to create a “Printed” checkbox which is automatically set to “true” when the RMA Form report is generated. I created a Data Directive on the SysTask table, which successfully sets a UD boolean field to True. The problem is that the user ALSO wants a “REPRINT” note to show on the report if the Printed value is True. I added a textbox and set its visibility to only show if Printed’s value is True.

The Data Directive is setting the Printed value before it generates the report-- which means the “REPRINT” note shows every single time! How can I delay the field update until after the report is generated? Here is my Data Directive Code (Standard, not In-Transaction) (it’s only an Execute Custom Code box in the directive)

foreach (var ttSysTaskRow in (from ttSysTaskRow in ttSysTask where ttSysTaskRow.TaskDescription == "RMAForm" && ttSysTaskRow.TaskStatus == "COMPLETE" select ttSysTaskRow))
{
Ice.Diagnostics.Log.WriteEntry("Walrus SysTask:" + ttSysTaskRow.SysTaskNum);
foreach (var SysTaskParam_iterator in Db.SysTaskParam.Where(SysTaskParam_Row=> SysTaskParam_Row.SysTaskNum == ttSysTaskRow.SysTaskNum && SysTaskParam_Row.ParamName == "RMANum"))
{
Ice.Diagnostics.Log.WriteEntry("Walrus RMANum:" + SysTaskParam_iterator.ParamInteger);
foreach (var RMA_iterator in Db.RMAHead.Where(RMA_Row=>RMA_Row.RMANum == SysTaskParam_iterator.ParamInteger))
{
RMA_iterator.Printed_c = true;
Ice.Diagnostics.Log.WriteEntry("Walrus Printed:" + RMA_iterator.Printed_c);




}
}
}
2

You could try to use a method directive instead on the StatusMonitor.Update. (post)

You can use the fields to determine what file is being acted upon and what the action is print, etc.

3

I don’t see StatusMonitor as an option in Method Directives. That’s a System Method and not Product, right?
I’m on 10.1.400 if that’s relevant, I don’t know if 10.2 or other versions have different Methods.

4

Oh I’m sorry its called SysMonitor (system)

5

Oops! I was wrong about my problem actually, my Data Directive was working just fine-- my expression in the Visibility box of the report was wrong! I fixed it up now and it’s working as intended.

2 Likes
6

Another possible way to go after this would be to set the date and time in another field if it is blank and to set visibility based on the timestamp being greater than X minutes old.

7

@gpayne that’s an excellent idea as well

8

Rather than a checkbox that means “printed”, use a UD Number field for “Times Printed”, and add 1 to it. Then, in the report, if the field is 1, you know it’s the first time. If it’s more than 1, then it’s a reprint. You also have added information in knowing how many times it’s been reprinted, in case that’s ever helpful.

Kevin Simon
SimsTrak Consulting

2 Likes
9

Hello. I too am needing a “Printed” checkbox like the one you did here. Can you share how you did it? Thanks.