Sparkrock / MS Dynamics

Note: Sparkrock is built on Microsoft Dynamics so instructions below MAY apply for Dynamics

We need two reports: 1. G/L Register report and 2. Vendor list

Max number of lines when running reports appears to be 500k.(can be changed)

Instructions:

1. G/L Register report

All Reports -> Under ‘Finance’ -> General Ledger  -> Reports -> Entries -> select ‘G/L Register’

Options:

Include Account Desc -> toggle to yes

Include Dimensions -> toggle to no (this is important as will generate WAY too many lines if on)

Under - Filter: G/L Register

Source Code -> PURCHASES

Under - Filter: G/L Entry

Posting Date -> enter dates separated by two periods. Eg. 01/01/22..01/01/26  would be Jan 1 2022 to Jan 1 2026

When report finishes generating will ask to Print or Send to

-          Select ‘Send to…” Choose ‘Microsoft Excel Document (data only)

2. Vendor - List report
All Reports -> Under ‘Finance’ -> Payables -> Reports -> Vendor – List
Options: leave all blank
Send to… -> select ‘Microsoft Excel Document (data only)