P4312 and P43E20 PO has been received and closed with on open quantity

Karim

Member
Version: 8.11 SP1 Tools 8.97

We have about 50 PO's that are in a 400, 999 status and have a quantity to receive greater than 0. How can i clean this up? Can I run a SQL update to simply remove quantity and amount to receive:

UPDATE [JDE_PRODUCTION].[PRODDTA].[F4311]
set PDAOPN = 0,
PDUOPN = 0
where PDDOCO = 17782

These orders are old, the problem is the effect on the G/L?
 
Back
Top