Skip to Content
0

SAP B1 Sales order UDF Dates

Oct 10, 2017 at 09:33 AM

39

avatar image

Hi Experts,

In Sales order i have created a UDF fields called DATE.

I need to restrict users not to enter back dates.

In this udf fields users only need to enter today's date alone.

Is it possible in Stored Procedure or Transaction Notification.

Thanks

Vinoth

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Johan Hakkesteegt Oct 11, 2017 at 06:38 AM
0

Hi,

The easiest solution is probably to use a formatted search to automatically fill in today's date, with a simple query: SELECT GETDATE()

That way you do not have to rely on the user to fill in the correct date.

Regards,

Johan

Share
10 |10000 characters needed characters left characters exceeded
Vinoth D R Oct 12, 2017 at 08:55 AM
0

Hi Johan

My requirement is whenever i get the payment from customer i need to update the UDF field date.

So i need to enter current date alone. some of my users are wrongly entering back dates. So i need to block

sample sp:

IF @transaction_type = 'A' AND @object_type = '17'

BEGIN

if exists(SELECT cardcode,U_DateProdctionApp FROM ORDR WHERE ( ( U_DateProdctionApp >= getdate( ) ) ))

begin

SET @error = 10

SET @error_message = 'Please enter todays date'

end

END

above sp is not blocking

Thanks

Vinoth

Share
10 |10000 characters needed characters left characters exceeded