Skip to Content

Preventing Duplicate Descriptions

Hello:

Is there any way to avoid duplicates typed within such master data fields as business partner description or Item description, in SAP Business One 9.3?

John

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Jan 18 at 06:46 AM

    Hello,

    There is no standard functionality for the same.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 18 at 07:47 AM

    Hi

    you can use the TN store procedure to solve this issue. I think is the mos effective solution in this case.

    Kind regards

    Agustín

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23 at 07:01 PM

    Only one solution that is use use stored procedure in transaction notification

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23 at 10:17 PM

    Thank you, for the good responses!

    Would someone please show an example of a transaction notification stored procedure?

    John

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 24 at 02:43 PM

    Hello,

    For Item Master Data please check following TN.

    IF(@transaction_type in (N'A',N'U'))
    BEGIN
    IF EXISTS
    (
    SELECT T0.ItemCode
    FROM OITM T0
    WHERE
    ( SELECT Count(T99.ItemCode )
    FROM OITM T99
    WHERE T99.ItemCode <> T0.ItemCode AND
    REPLACE(T99.ItemName ,' ','') = REPLACE(T0.ItemName,' ','')
    ) >0 AND
    T0.ItemCode = @list_of_cols_val_tab_del
    )
    BEGIN
    SET @OutPut=1
    SET @error_no=3001
    SET @error_text='Item Description is already Exist for another Item '
    END

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 28 at 03:46 PM

    Hi Shrikant:

    How can this syntax be modified for HANA?

    John

    Add comment
    10|10000 characters needed characters exceeded