Dynamics NAV - Cannot Post Purchase Order - Must be equal to 'xxx' in Purch. Rcpt. Line:Document no.='xxx'

Cause:
This occurs when there are multiple lines on a PO that have Purch_ Rcpt_ Line.Quantity Invoiced=0 and Purch_ Rcpt_ Line.Qty_ Invoiced (Base)=0 , However one of the lines has actually been invoiced, resulting in the error when the posting tries to process that line that has already been invoiced.

sometimes this may happen if there are multiple receipts, but a single invoice

Resolution:
Update Purch_ Rcpt_ Line.Quantity Invoiced=[Quantity] and Purch_ Rcpt_ Line.Qty_ Invoiced (Base)=[Quantity (Base)], [Qty_ Rcd_ Not Invoiced] = 0

update [CRONUS$Purch_ Rcpt_ Line]
set [Quantity Invoiced] = [Quantity], [Qty_ Invoiced (Base)] = [Quantity (Base)], [Qty_ Rcd_ Not Invoiced] = 0
 where [Document No_] = '107133962' and No_ = '546024443'