When you deal with diverse document types like Sales Report, you know how significant accuracy and focus on detail are. This document type has its specific structure, so it is essential to save it with the formatting intact. For this reason, dealing with this sort of documents might be a struggle for conventional text editing software: one wrong action might ruin the format and take extra time to bring it back to normal.
If you wish to bind side in Sales Report with no confusion, DocHub is an ideal tool for this kind of duties. Our online editing platform simplifies the process for any action you may want to do with Sales Report. The sleek interface is suitable for any user, no matter if that individual is used to dealing with this kind of software or has only opened it the very first time. Gain access to all modifying tools you require easily and save time on day-to-day editing activities. You just need a DocHub account.
Discover how straightforward document editing can be regardless of the document type on your hands. Gain access to all essential modifying features and enjoy streamlining your work on papers. Sign up your free account now and see instant improvements in your editing experience.
[Music] hi everyone welcome to today's session today we'll be walking through how to create excel reports that have a live link to business central via what we refer to as an odata link for today's demo we're going to be walking through just a very simplified version of a sales by customer by item report and it's going to include these fields so we're going to show the sell to customer name the posting date of the transaction the document number the item number item description quantity sold sales and cost gross profit and gross margin um so the main driver of this report is actually going to be the item ledger entries report and then a few of these fields such as item description uh we're going to need to pull that with a vlookup from the items table and then the sell to customer name we're actually going to pull in the posted sales shipments table we're going to keep this report uh pretty basic but you could also add in uh posted sales return receipts posted sales credit memos if yo...