Category Archives: GP SQL

GP 2010 Item last sold: Including BOM components

Starting with the SQL view for last sale by customer and item by Victoria Yudin¬†with a couple modifications.¬† I created some queries to recursively capture all of the components associated with the items sold as well and where they are … Continue reading

Posted in GP, GP 2010, GP SQL | Leave a comment