I noticed that I have a variance between the revenue on my financials and the report in Power BI called "Sales by Customer." There is a line item in Power BI that makes up for the variance. This one is unique as the Entry Type and Document Type are different than the others. This line item says "Sales Line" and "Order." While the rest says "Direct Costs" and "Sales Invoice." When I look at the sales order, this was a partial ship leaving 34 units not yet shipped to the customer. Why would Power BI consider the 34 unshipped units as part of sales for the month?
Is this a standard Power BI report you got as part of the Power BI deployment?
The report can, of course, be modified to exclude unshipped items. You'll probably have to make that change.
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.
210
Share
Report
All responses (
Answers (
