Dynamics NAV - Customer Sales Statistics (stock report)

(0) Share

Report

Posted on by Community Member

Hello,

I am trying to figure out the exact formula that Dynamics NAV uses in the Customer Sales Statistics report.

I've built a query for analyzing Sales Invoice dollars and quantity by customer, item, date, etc., however when I look at my total numbers by customer it does not match what NAV has. I am wondering if there are other adjustments that NAV is considering (discounts, sales adjustments, allowances, etc.) that I need to build into my query in order to get them to match.

If anyone knows the exact formula that NAV uses in the Customer Sales Statistics report, I would greatly appreciate the help!

Thanks,

Logan

*This post is locked for comments

I have the same question (0)