SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

Bug In Accounts Receivable Report (Patches)

posted by Gregory West(R) E-mail, Manitoba Canada, 14.10.2016, 09:55

I have bumped into an issue in the accounts receivable aging report. When
I
ask for an aging report in the past what I get is a report on all
invoices
created on or before the specified date and all payments up to TODAYS
date,
not the specified date.

What this means is I have a Balance Sheet saying I have 200K in AR on
March
31st, 2016. But when I do an aging report I am told I have less then
10K.
These two amounts should match. I am being asked for the aging of AR
over
time, and SQL Ledger is not able to do this. If this an easy fix, or is
it
a major change?

IMHO you're using the wrong report.
Aging (or Ageing) report is for sending Statements, eg monthly.
If you wanna see what woz outstanding at 31 March 2016, try
AR, Reports. Outstanding, To = 31/03/2016 (or 03-31-2016, or your format),
Continue.
This report should be alignment with your Balance Sheet.
Tip. Tick the boxes, Due, Subtotal.
HTH

Good morning. I tried the outstanding report using the dates From:2015-05-01 to:2016-04-30 (Their fiscal year) and the report came out blank. But on the year end balance sheet the AP is about 200K So this did not work either. Of course all these invoices are paid off as of today, but back in May they were not.

---
Gregory A. West
DB&W Systems Limited

 

Complete thread:

Back to the forum
Board view  Mix view
971 Postings in 319 Threads, 324 registered users, 59 users online (0 registered, 59 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum