I need a custom report created that will clean up old Received not Invoiced purchase receipts.
1. Report takes Purchase Order number input
2. Check to make sure PO is fully received with no amounts pending
-> If amounts pending display error: "POxxxxx is still open"
3. Post an Invoice against the received not invoiced amount from the PO
Skills: sql server, microsoft dynamics, microsoft dynamics nav