Debtor View Dates etc
I have an issue with the debtors view -
There appears to be a strange methodology in place for total owing calculation that differs from the balance shown in the summary.
Additional the fact statements cannot be printed for the current day is wierd. I am not sure I understand why.
So Yesterday I was finalizing monthly accounts and found 1 client had had a payment marked off for 3000$ instead of 2000$. So I reversed the incorrect payment and created the correct and new one.
The balance on the summary screen is showing about $3500. (Which is correct)
The balace on the reporting screen is showing 188.00 ?? If I change the date to the 2/3(tomorrow) it corrects itself to the correct balance.
Firstly it should NEVER show the wrong balance....and secondly why cant we print statements for the current day....If the only reason is that they could process a transaction later that day that would make the statement inaccurate I dont think that should prohibit the action atleast make it administratively possible.
Ben
Re: Debtor View Dates etc
G'day all. We have also wondered about why a charge doesn't appear on a statement until the next day. Our only issue there is if someone forgets to put accounting fees on an account. We print and post the following day.
Regards
Simon Slater
Registered Linux User #463789 @ http://linuxcounter.net
Re: Debtor View Dates etc
Ben/Simon - I concur that one should be able to print a statement including transactions on the current day.
I must admit that we do not use Reporting/Debtors. For the street practice, in general we do not let people leave without paying. For the housecall business we issue statements individually using a 'report' that generates a statement back to the opening balance prior to the oldest unpaid transaction - and this includes everything up to the specified 'To Date' which can be today.
Tim A and I have a vague plan to add this facility to the Customer workspace in the next release.
Regards, Tim G
Re: Debtor View Dates etc
So you are effectively using a Statement with out using the Statement workspace...which basically says that Debtor workspace doesnt work for you at all..
Adding a new report is not a solution to the generation within the statement workspace...
The debtor workspace is really quite good...just a few problems under the hood that need addressing
Re: Debtor View Dates etc
No I am not Ben - our management wants to send out statements that cover multiple accounting periods. The standard statement show transactions from the opening balance tranaction prior to the specified statement date. There is no way to ask for one statement that covers multiple accounting periods.
If I ruled the world (and was a competant java programmer), I would tweak Reporting|Debtors to:
Since I neither rule the world, nor am I a competant java programmer, I took advantage of the fact that I can build reports and built something able to generate multi-period statements.
Regards, Tim G
Re: Debtor View Dates etc
I completely get that Tim its a work around that works...ideally tho we want the Debtor workspace to be an effective one stop solution for all practice variants...
Re: Debtor View Dates etc
Hey guys,
So maybe the Debtors workspace should be called Statement Management.
I think I get what your asking for Ben, a Customer Transaction Activity report that includes all Finalised invoices/receipts for a defined period (preferably the current day) with a current balance.
When I asked our Accounts manager (we have literally hundreds of accounts) she said that the terminology she uses is that a Statement refers to a balance for a defined financial period with or without transactional detail that has a starting and finishing balance.
We have a decent number of large accounts that like us, pay based on statement periods, not invoice to invoice.
So I'm cool with how the Statements works. As far as the column totals in the workspace, I think they should stay the way they are.
However, our Accounts manager said that she would love a Workspace that allowed her to do exactly what you describe Ben. She feels it should not be in the Statement space to avoid confusion for accounting-minded people who work in statement periods but instead be a new workspace called something like Customer Activity which would include a customer transaction activity report. The workspace would have the same filters as the current Debtors but instead of Statement Date, it had two other fields;
Start Transaction Date
End Transaction Date
All Transactions flag
I confess some of this really took some explanation for me.
Matt C
Re: Debtor View Dates etc
Well yes but I do have an issue withe the balance calc..
As I said I noted that in the last month a payment was made for 3000 but it should have only been 2000...the clients balance was around 2500 when I reversed the 3000 payment and made the new payment for 2000 the balance should have been 3500 but it was actually about 300.... if I set the date to today...it made no sense...
If I set the date to tomorrow that balance reported correctly.
Re: Debtor View Dates etc
Reporting - Debtors calculates totals based on unallocated balances from Completed and Finalised charges up to the end of the Statement Date.
It won't include any charges done after that, nor will it include any In Progress charges. This is because these won't be included in the statement when End Period is run.