date

austin

Hi to everybody,
I what to know Sunday . I want to create a sales order . That is on Date 10/06/2007(today is Saturday). But in workdate I entered 11/06/2007(Today is Sunday)
And I posted a sales order.So That is wrong. Again I used credit memo , corrected that invoice. This is one way.
But in another way
But what I want na , If I press F3 To create a sales order or purchase order, cahreceipt journal or………… If the day is Sunday then I need to get message.
And If I change Work date even that has to get message , if it is Sunday.
What is the solution. I am not a super programmer.
Where I have to write code , and what I have to write.
Throw some Valuable suggestions.

Thanks and regards

ufuk

You can write a function to a table like General Ledger Setup.

IF (DATE2DWY(TODAY,1) = 7) OR
   (DATE2DWY(WORKDATE,1) = 7) THEN
  MESSAGE(Text001);

Then call this function in all related table's OnInsert. (If you don't want to insert the record use ERROR instead of MESSAGE.)

jannestig

I am assuiming you merely wish for the system to not allow anyposting on a day that is a sunday?

Have you looked at assigning a base calender against the company or customers etc then having the sunday flagged as a non working day which is standard. Then upon any posting routine it checks against the base calender and if date used is non working then deny post saying day is a non working.