UOM Qs
I am struggling lot with below scenarios...Please provide me the possible solution or work around. Item code: Hook - Pieces Hook - Packet (10pcs) (1 Cover, 1 Label and 10 pcs Hook) Hook - Box (10 pcs) (1Box, 1 Label and 10 pcs Hook) Hook - 10 Boxes (100pcs) ( 1Big Box, One Label, 10 Boxes i.e., 100pcs) Hook - Box of 525 pcs Hook - Box of 1725 pcs Unit of measure I defined as Piece and UOM Conversion as Pakect (10 pcs), Box (100 pcs), Box of 500 , Box of 1000. After conversions I can use any of the UOM to perform the transaction in purchasing, miscellaenous transaction but my question is If we peform the transaction using Box of 500 UOM conversion and Box of 1000 UOM in purchasing or Misc transaction. If I want to track in the system, system is showing the balance only in Primary UOM i.e. piece... my client wants to track how many Box of 500, Box of 1000 are there in the stock. If they receive sales orders from customer, first they check Boxes, packets, finally pcs... exaple: 1525 pcs order means.. they check any availbility of Box of 1000, Box of 500 finally they pick from loose piece from the Organisation. They are very concern about Tracking in the system... without knowing how many are there very difficult for them proceed further. Second issue is: They send three item codes to outside processing: A , B, C Item codes become Item code Z They issue A, B, C items to outside vendors for processing, they pack in packets, boxes returns to Client in multiple receipts, they want to track all against to issue of items. Some times outside processing vendors send more / less: 3,00,000 piece Hook send along with B (Label) C (Cover)... to 3 vendors as below Ram - 1,00,000 he returns only 95000 .. remaining is shortage Ravan - 1,00,000 he return more 1,06,000 - remaining is surplus Lakshman - 1,00,000 he returns only 97000 - remaining is shortage While issuing items to outside vendors for packing, they are not counting all items because small pieces, they think 1 lacs pieces are there but more or less will be there... how to achieve this scenarios in the system, tracking and adjustment. Outside vendros are returning in multiple receipts, like 1,00,000 they return ten times, client wants to track all the receipts and finally whatever shortage or suplus for respective receipt of 3,00,000 they want to adjust in the system as well as in supplier account. Third issue is: If UOM conversion tracking is solved by Intra class, picking is the problem.. my client requirement is If they receive Sales order from Customer for 10111 pcs. First they pick Boxes like Box of 5000, second Box of 1000, finaly they pick 111 pcs from loose pick. Box of 5000, Box of 1000 and Loose pcs they maintain at different sub Inventories, After doing pick release as per our picking rule system generate pick slip report. First system pick by orderwise, if there is no enough quantity to satisfy in respective sub inventory it will goto sub inventory order 2... In my case how to achieve this. Please do the needful Quick responses highly appreciated.
if you are in R12 then use
if you are in R12 then use secondary tracking UOM. No solution for 11i. For third issue you can use correct picking rule.