RE: Drop Ship Reconciliation
Hi Jennifer-
Drop ships are complicated, aren't they? :)
In your previous reply, I read you use the Shipment Notification tool. Is this because you need to bill the customer before the invoice is actually received/posted from the vendor?
I have used it before, but remember it was a real pain.
I've read recommendations in the past about creating a separate inventory site (called drop ship or whatever) and then running all of your drop-ship sales and purchase orders through that site. It adds a bit of overhead, but a perfectly good solution. This way, you have more information in GP for what has been shipped, what needs to still be invoiced, and you can bill the customer before the invoice is posted from the vendor. If there is any kind of cost difference, it will get fixed at the time the vendor invoice is posted (just like regular inventory shipments).
The site can also be tied to a specific GL account (like your drop-ship account) so these transactions aren't in your normal inventory transactions in the GL. Just remember to exclude this site from your inventory reporting!
As for the costs not updating when the sales document and purchase order are linked: this has happened to me in the past too. Found out it was because someone had the sales order open when the vendor invoice was being posted. The lock on the sales order prevented the cost and quantity received update from happening.
Joe