HOW TO PULL THE AVERAGE FREIGHT DAYS REPORT FROM POWERBI

This guide offers a step-by-step process for generating the Average Freight Days report in PowerBI. This information is used by the Accounts Payable Department as a tool to cross reference when publishing the INVERR10 report. INVERR10 is also knows as..... Invoice Error Report Invoice Exceptions Report Exceptions BOT "The BOT"

Amber Schmitz
|
19 steps
|
3 minutes

Navigate to PowerBI in Google Chrome

Once PowerBI is open, click "Browse" from the menu on the left hand side of the screen.

Select the report labeled "Vendor Codes (TTI).

Click the drop down under "Entity".

Click "NDC"

Click the 3 dots in the right hand corner of the report. *The 3 dots will not be visible unless you hover over the report or the corner of the report.*

Click "Export Data"

Select "Data with current layout" then click "Export"

Click the icon in Google Chrome for "Downloads"

Open the downloaded report by clicking on it

Click "Enable Editing"

Click "File"

Click "Save As"

Click "Browse"

Open the "AP CLOSE" folder located here: G:\\Finance\\PROCURE TO PAY\\MONTH-END\\AP CLOSE

Click the folder labeled with the current year.

Double-click "US BU"

To update the name of the saved report, click the field next to "File name:"

Type AVERAGE FREIGHT DAYS_P***X***\*\*\_FY20***XX*** then click "Save".\ \ **EXAMPLE:** AVERAGE FREIGHT DAYS_P**2**\_FY20**25**