Hello,

Perhaps in EE version ( for letter H or .. ). We are in QAD SE 2012. When you run a program in a batch you create records in bcd_det table. You can modify these records ( by a program each day in another batch ) to change the date. We do that for invoices.

Best regards. 

Hi Xavier,

We're still in the middle ages (v9.1E). That's an interesting approach, just fooling the system. Every day you run an program to change the date in the bcd_det-record.

Thanks for this useful advice!

Greetings,

Edward

Hallo Xavier,

Can you explain in more detail what you did to have the posting Invoice program running in batch with the actual date ?

We have QAD EE2015

Good morning René,

I'm certainly not a programmer, but this is how I solved it finally.

I've created a form to run the program, because I didn't know another way to get this program (that on it's turn modifies the batch detail line) run in a batch. And this is what you want, because when it's in the same batch, but with a higher priority, you arrange that the requeste batch detail line is always with the actual date). The "runok = true." at the end is to set that parameter right to get the line ran again. Hope it helps you.

{mfdtitle.i "ddm a"}

FORM
with frame a SIDE-LABELS width 80.

UPDATE
WITH FRAME a.

/* SELECT BATCH */
{mfselbat.i}

DEFINE VARIABLE sbcd_parm AS CHARACTER FORMAT "x(85)".
sbcd_parm = CHR(34) + "1" + CHR(34) + " " + CHR(34) + "S" + CHR(34) + " " + CHR(34) + CHR(34) + " " + CHR(34) + " " + CHR(34) + " " + CHR(34) + "ja" + CHR(34) + " " + CHR(34) + "ja" + CHR(34) + " " + CHR(34) + STRING(TODAY) + CHR(34) + " " + CHR(34) + STRING(TODAY) + CHR(34) + " " + CHR(34) + STRING(TODAY) + CHR(34).
FOR EACH bcd_det WHERE bcd_batch = "edi3" AND bcd_exec = "rcsois.p 7.9.5" EXCLUSIVE-LOCK.
bcd_parm = sbcd_parm.
bcd_process = TRUE.
END.

runok = true.

Hello,

Your program.

for each bcd_det where (bcd_batch = "permanen" or bcd_batch = "lundi" )  and

    bcd_exec begins "w1sorp10.p" 

    and bcd_domain = global_domain:

        v-place = index(bcd_parm,"/").

        v-date = substring(bcd_parm,v-place - 2, 8).

        v-chaine = replace(bcd_parm,v-date,string(today)).

        bcd_parm = v-chaine.

end.

Best regards.