Business Analytics-Updating the VMS_Master_Invoice weekly report (David G's report) (Copy) | Scribe

    Business Analytics-Updating the VMS_Master_Invoice weekly report (David G's report) (Copy)

    • Laura DiNitto |
    • 17 steps |
    • 44 seconds
      1
      Open the master invoice report in the Excel Desktop application (not web/online). Current file location is in the Sharepoint folder located in the DWSMSPTeam site, Power BI Source Reports > Shared Externally. Current file is named: VMS_MasterInvoice_AllClientData_2023_csv_updated_Oct
      2
      Go to ManageRight to run the individual invoice reports.
      3
      Run the report named "Invoice Details - Rates and Hours"
      4
      Run separately for each client.
      5
      For each client, ensure that your date filter returns only the most recent invoice data. (Note - VNS Health uses an invoice date that matches date effective.)
      6
      Click "Search"
      7
      When the report data loads in ManageRight, Click "Export drop down menu" and select CSV (comma delimited).
      8
      Click "File Explorer" and "Downloads" to find the report you just ran.
      9
      You need move the report from your downloads folder to the online folder entitled "VMS_Invoices_2023_csv" located on the DWSMSPTeam sharepoint site (SourceNow OneDrive) at Power BI Source Reports > Shared Externally > VMS_Invoices_2023_csv. Click "Power BI Source Reports (OneDrive)" in your file explorer to expand the subfolders.
      10
      Move the file from your Downloads folder to the Sharepoint folder named "VMS_Invoices_2023_csv". You can drag the file and drop to move.
      11
      Repeat for all active ManageRight clients. Once you have downloaded and moved all of the invoice reports to the Sharepoint OneDrive folder, open the master invoice report in Excel.
      12
      Click "Data"
      13
      Click "Queries & Connections"
      14
      In the panel on the right, Click "VMS_Invoices_2023_csv"
      15
      Click here to "Refresh" (it checks the VMS_Invoices_2023_csv folder and adds and combines all of the new reports you moved to that folder). The number of rows loaded should increase.
      16
      Once you have refreshed the data, you can update the various pivot tables and other sheets that pull from this data. You can also update the other queries that are depending on the master data sheet (Neovia sheet, SourceNow only sheet).
      17
      After you have updated and saved this Master report, open the VMS_MasterInvoice_Neovia_SharedwithOntimeStaffing report in desktop app. Follow the steps to open queries&connections and refresh the query data. After the data updates, refresh the pivot table sheets, save and close.