Is it possible to create view programmatically in RTC?

DDKing

Hello,

I have a question about creating a view programmatically. With view I mean like the view of the "Delayed" sales orders in a orderprocessing role. Default when selecting this role you are able to see some default "views" of the sales orders (Shipped Not Invoiced, Ready to Ship,...).

In the "Delayed" view you can see a filter <''..yesterday>, now I want to have another calculation behind this. Is it possible to change this somewhere via the object designer?

Secondly I am not able to recreate a filter like that (<''..yesterday>) for a new view I wish to create. So I wonder how to do this, because "T-1" gives me a completely other day (03/01/12).

Thirdly can you create views programmatically that appear the moment the user (orderprocessor) logs in?

Thank you in advance,

D.

PS: version of NAV is NAV2009 R2 Belgian version.

mohana_cse06

If you are using ORDER PROCESSOR role the

1. yes, you can change it in Page 9060 - SO Processor Activities
In OnOpen Page you will have below code

SETRANGE("Date Filter",0D,WORKDATE - 1);

2. you have to create new field in table 9053 - Sales Cue as delayed.
Make sure it calculates based on WORKDATE

3. Can you be more clear please..

DDKing

Ok Mohana,

thank you very much for your reply. You've solved my questions.

But do you have any idea why 'T-1' when entering this in the rtc client does not give me the day of yesterday?

Thanks in advance,

D.

mohana_cse06

May I know where did you enter?

DDKing

In an advanced filter on "Shipment Date" in the "Sales Orders" list.
The workdate of NAV and of the system is 19/10/2012 and still it gives me 03/01/2012. Is this a bug?

Thanks for your reply,

kind regards,

D.

mohana_cse06

I guess it is considering as 1st tuesday of year..

If you enter T-2, it will show you the second tuesday of year as 10-01-2012.. :-k

DDKing

yes it does... :shock:

Any idea how to do this?

thanks,

mohana_cse06

What exactly is your requirement?

DDKing

I was just wondering what you need to enter to get the date of yesterday if T-1 does not do the trick...

mohana_cse06

May not be perfect answer for your question but program automatically calculates based on workdate (workdate-1)
or you can manually enter the yesterday date (18-10)

DDKing

Ok,

thank you very much for the information!

Kind regards,

D.