I am facing a problem here while handling a scenario in GRPO. Any suggestions would be greatly appreciated.
GRPO is copied from Purchase order. PO can have upto 200 line items. If the qty of any item is recieved less than the qty in the po, then we have following udf's in the GRPO at row level to update the qty;"Accepted qty, Short/Excess qty, Rejected Qty". The problem arises when accepted qty is zero, coz if the qty field of GRPO is 10 and accepeted is zero, the system still counts 10 in stock as it is system behaviour. NOw we want the stock to be updated by the accepted qty. How can this be handled??
I thought of using dropship whse in case where item is not received, but the problem arises as this can still be copied to A/P Invoice. It solves the issue at inventory level but the accounting gets affected as the material is not recieved physically.How can we handle this scenario???
Thanks in advance,