I would like to add a warning message to a Purchase Order if the preferred vendor of the item selected is different from the Business Partner for the Purchase Order.
To my understanding, SP_TN will block the PO from being added. The client wants it to just display a warning message but allow the PO to be added. Is this still possible?
Thank you for the link, but the client doesn't just order the items only from the Preferred Vendor. They can order the goods from other suppliers in cases where the preferred vendor doesn't have enough stock. So they just want a warning to the user that the item is not being ordered from the preferred vendor. But it should still allow the PO to be added.
1. They usually send a PO to the preferred vendor. Then that vendor replies and says this item(s) is not in stock. Then the client raises another PO to a different supplier who isn't the preferred vendor.
2. There is no field indicating the stock of the preferred vendor.
That is exactly what the client wants. They just want a warning/alert that this item(s) is not being ordered from the preferred vendor. Just a simple message/warning but the PO should still be added.
Yes It is Possible By using the Store procedure transaction notification..
Transaction Notification
The SP_TransactionNotification is the only legal way in SAP Business One to receive notification of data-driven events - in order words to do some validation in SAP Business One and prevent the user from doing an action if the validation condition fails. This stored procedure(SP) is created automatically with each database.
SBO_SP_PostTransactionNotice and SBO_SP_TransactionNotification can by edited by the user to add sql code as part of a notification process. The functionalities of both are the same, the only differences being when they are triggered and the ability to use the @error functionality of SBO_SP_TransactionNotification to rollback transactions. SBO_SP_PostTransactionNotice can only be triggered at the end of an action (transaction committed). It is preferable to use SBO_SP_PostTransactionNotice - although as this occurs after the transaction, the @error rollback functionality can not be used.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.