video1.0<iframe src="https://www.loom.com/embed/96c29f12562e4475901a8c7f565bd158" frameborder="0" width="1280" height="960" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>9601280Loomhttps://www.loom.com9601280https://cdn.loom.com/sessions/thumbnails/96c29f12562e4475901a8c7f565bd158-f5e92583d824ceec.gif81.8412In this video, I walk you through how to access the purchasing table from Sage Impact using the Insert Query button. I demonstrate how to connect to a new spreadsheet and select the PL Document and PL Document Entry objects, which correspond to purchase orders and their lines, respectively. I also explain how to choose all fields or specific ones from the field list and add access to related fields like the document editor and item master. Please follow along and try this in your own Sage Impact environment to familiarize yourself with the process.