how to calculate margin in purchvenditemstastics report in d365
Hi, The Vendor/Item statistics report displays a summary of products that your organization has purchased from each vendor during the date range that you specify. The data on this report comes from PurchVendItemStatisticsTmp table, VendInvoiceJour table, VendInvoiceTrans table. You can filter the data to display on the report. To calculate the quantity of items as well as the margin, you can add a custom expression to the report that joins the above tables and sums the relevant fields. The margin calculation in FO is generally as shown in the screenshot. You can view the following document about margin management, which gives the margin calculation formula and related settings.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.