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. Margin Management (innovation-product-documentation.azurewebsites.net) Best Regards, Hana
Was this reply helpful?YesNo
Under review
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.
123
Share
Report
All responses (
Answers (
