Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Financial Analytics - Auto Validation report will be used to identify discrepancies found in the financial amounts found between the source and the Azure SQL pool tables in Synapsefor finance. The report data is refreshed daily (except on Sundays) and shows the number of differences found for each record type in a summary table along with a visual representation of the table. A detail table lists each record where differences were found and shows the actual amounts in the source and SQL pool tables along with a column that shows the difference between the two amounts.

...

Validation Detail

Shows the amounts found pulled for each record. The source table and SQL pool amounts are shown for each record type, validation date, fiscal year, accounting period, business unit, account, operating unit, fund code, department, initiative, project, and product.

...