News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... how to calculate margi...

Finance | Project Operations, Human Resources, ...

Suggested answer

how to calculate margin in purchvenditemstastics report in d365

(0) Share

Report

Report

Posted on by M_R

125

how to calculate sales qty and margin in purchvenditemstastics report in d365

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

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.

Margin Management (innovation-product-documentation.azurewebsites.net)
Best Regards,
Hana

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans