Is there a verification report that can be ran to verify that the quantity of items on a drop ship order which is committed to a Sales order have been invoiced? A Sales order was entered for quantity one and is committed to a drop ship order which was updated to match the vendor invoice with a quantity of 100. The sales order is not showing as open in the open sales order report as quantity one has been fulfilled. However, 99 items from the purchase order shipped to the customer and have not been invoiced to them as this quantity wasn't included on the sales order.
*This post is locked for comments
I think no standard report available for your requirement. Please have a look on the below link for SQL view of SOP and POP link.
victoriayudin.com/.../sql-view-to-show-items-with-sop-pop-link
Hope this helps!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156