Transaction Notification required for SAP B1 9.3 for HANA

[former_member576093]

Hello World,

I need a Transaction Notification (Validation) for SAP B1 9.3 for HANA for below mentioned scenario -

On Sales Order document (ORDR), Delivery Date (ORDR,DocDueDate) cannot be added more than payment terms (ORDR, ExtraDays) which is set in BP master for the particular BP and reflecting on Accounts tab of SO.

Thanks much!!

[former_member576093]

Kindly share if available.

[Abdul · Accepted solution]

Please follow the below code, before deployment recheck the fields names

IF (:object_type = '17' and (:transaction_type = 'A' OR :transaction_type = 'U')) THEN (Select COUNT(*) into cnt5 From "ORDR" a inner Join OCTG b on a."GroupNum" = b."GroupNum" Where a."DocEntry" = :list_of_cols_val_tab_del AND a."DueDate" > ADD_DAYS (a."DocDate",b."ExtraDays")); IF :cnt5 > 0 THEN error := 2301; error_message := 'Due date is not according to payment term days ...'; END IF; END IF;

[former_member576093 · Accepted solution]

Thank you Mr. abdul.mannan6