Conexus Sg Blog Dynamics SL SQL Query for AP & GL out of balance research

Are you struggling to determine why your Periodic AP Report and GL Balance Report do not tie for the AP account in Dynamics SL? Here is a quick query you can run to help find the vendor that is out of balance: Example: 2005 = AP account Period out of balance was Jan 2017 select [...]