on 12-13-2007 9:49 AM
My client is a pharma company and due to regulatory reasons, they have to assign a batch no whenever they create a production order. For that, I mapped the production order no as their batch no. But they dont want to craete a batch if raw material for specific production order is not available. So they want the production order to be posted in the system if the planned qty at production ordder equal to or lesser than available qty otherwise system should block its postings. Is it possible through SBO Transaction Notification Stored Procedures?
You can insert a code into the procedure like this ((if you see into it, you see where):
if @object_type=202 and @transaction_type=A
BEGIN
/* The doc entry value of the production order is in the @list_of_cols_val_tab_del variable, starting from it you can check the available component quantities here. */
If /* there is not enough component */
begin
set @error = 11 /* or other non zero number */
set @error_message =There is not enough component
end
END
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.