Billing Due List Date

[aidan_mulcahy]

Hi,

I only want the Billing Due List to run for documents with a 'Billing Doc Created On' date <= today's date. I can type the entry in manually and it works perfectly, but is it possible to have a variant for the Billing Due List which will always place the current date into the 'Billing Doc Created On' To-Date? This variant would then be used in the scheduled job.

Thanks,

Aidan.

[Former Member]

Hi Aidan

I think that if you hit the 'Save' button to create a selection variant, you should be able to use a Selection Variable to fill the date.

If you choose type 'D - Dynamic date calculation' then the first entry is 'Current date'.

You shouldn't need to create a TVARV variable.

Cheers

Dom

[aidan_mulcahy]

Tiest/Dom,

thanks for the replies. I did both of your suggestions. I started with the outer program shell and thought that there must be an easier way than this and that's when I discovered the Dynamic Date Calculation. Works perfectly now.

Thanks again,

Aidan.

[Former Member]

Aidan, using a transaction variant it is not possible to reference today's date. What you could do instead is to create a little shell around the Billing Due List program that populates the Created On date with the system date and accordingly performs a call transaction. Tiest.