on 05-24-2016 8:35 PM
Hello
We have just implemented SAP and using production orders.
Is there any way production order can be set up in such a way that if any stock in the BOM is not present the production order is highlighted (in different colour).
Also this can give notification to the buyer or the planner either to buy the articles or plan a production run
Thanks for your help.
Hi Chetan,
It is not possible but you can achieve this through third party add-on.
Thanks,
Harshal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It is not possible to highlight insufficient qty item in production order. You can create production order even without qty and this is useful for your production department.
For those insufficient stock, you can create query and advice purchaser to run this query to create PO.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Nagarajan,
If that is the case then the planner has to check the stock of each item in the BOM before creating a production order. This is just waste of time and also if there are 50 items in a BOM there is no accuracy.
No I am not asking to highlight the insufficient quantity in the production order.
What I want is either to restrict creating a production order if there is insufficient quantity or to highlight the production order itself if there is insufficient quantity
There must be a way of automating this.
Thanks
Chetan
Try this:
IF @transaction_type IN ('A') AND
(@Object_type = 202)
BEGIN
If EXISTS (SELECT T0.docentry FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.[DocEntry] = T1.[DocEntry] left join OITM T2 on T2.Itemcode = T1.itemcode
WHERE T1.[ItemCode] in (select T2.[Itemcode] from OITM T2
where T2.[OnHand] = 0) and T0.[Status] = 'P' and T0.[Docentry] = @list_of_cols_val_tab_del)
Begin
SET @error = 14
SET @error_message = N'Please check instock quantity'
End
END
Thanks
No, you can not, but u can set alert to notify them that some of the items are out of stock but have open production orders.
Frank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
12 | |
11 | |
6 | |
6 | |
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.