on 10-31-2014 8:33 AM
Hi Experts,
We make the process order manually and do the confirmation against the order. In confirmation (cor6) we book both production & consumption on daily basis.
For Example:
Can we get the report in the following manner in one screen. This report will help us to find that which user is deviating the standard BOM or which user is not issuing the material against the finished goods date-wise
Finished Good Code | Finished Goods Description | Qty Produced | Components Code | Component Description | Qty as per BOM | Actual Qty withdrawn | Difference from BOM | Posting Date |
---|---|---|---|---|---|---|---|---|
FG0001 | Product A | 100 kg | RM001 | Raw Material X | 40 | 50 kg | -10 | 1.10.2014 |
RM002 | Raw Material Y | 30 | 45 kg | -15 | 1.10.2014 | |||
RM003 | Raw Material Z | 20 | 25 kg | -5 | 1.10.2014 | |||
FG0001 | Product A | 200 kg | RM001 | Raw material X | 80 | 90 kg | -10 | 2.10.2014 |
RM002 | Raw Material Y | 60 | 80 kg | -20 | 2.10.2014 | |||
RM002 | Raw Material Z | 40 | 0 kg | -40 | 2.10.2014 | |||
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajasekar,
Here the system show the order quantity and based on the BOM ratios it calculate the requirement qty.
But my requirement is as such that system should calculate the requirement qty based on the confirmation qty and accordingly compare it with withdrawn qty for each confirmation done by user.
Regards,
Hi Sun Riser,
Try with COOIS.
Otherwise I would create a custom report or create an LIS Info Structure with the corresponding update rules, etc.
Kind Regards,
Mariano
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi sun riser,
Please check with the standard report 'COOISPI' with option 'Components' here you can find both required as well withdrawn qty. You can add the existing fields in layout into the report by using change layout option. Please check and revert.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Create a Z report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
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.