Skip to Content

SAP B1 Sales order UDF Dates

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 11, 2017 at 06:38 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 12, 2017 at 08:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded