1 Topic by juju (edited by juju 06/24/2011 06:37:41 am)

  • juju
  • juju
  • Senior Member
  • Offline
  • From: Indonesia
  • Registered: 02/02/2011
  • Posts: 62

Topic: Grand total in the Report -Aged Customer Analysis-

I do a print to an excel format, once I do AutoSum in coloum Grand Total receivables aged 31-60 Days, Over 60 Days, And Total Balance does not match the results AutoSum excel.
It seems there is an error/bug in the query Aged Customer Analysis Report


Thanks & Best Regard

Jujuk

ING NGARSO SUNG TULODO, ING MADYO MANGUN KARSO, TUT WURI HANDAYANI
  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Grand total in the Report -Aged Customer Analysis-

In release 2.3.5 there is a selection 'Show also Allocated'. We did some corrections in release 2.3.5 for this. If you don't have this option, please upgrade to 2.3.5 and try again.
It should have been fixed.

/Joe

  • juju
  • juju
  • Senior Member
  • Offline
  • From: Indonesia
  • Registered: 02/02/2011
  • Posts: 62

Re: Grand total in the Report -Aged Customer Analysis-

I've used FA 2.3.5

ING NGARSO SUNG TULODO, ING MADYO MANGUN KARSO, TUT WURI HANDAYANI
  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Grand total in the Report -Aged Customer Analysis-

What happens if you select 'Show also Allocated'? Please help me finding this bug.

/Joe

  • juju
  • juju
  • Senior Member
  • Offline
  • From: Indonesia
  • Registered: 02/02/2011
  • Posts: 62

Re: Grand total in the Report -Aged Customer Analysis-

if I selected "Show Also Allocated:" mismatch grand total ranging from 1-30 Days, 31-60 Days, Over 60 Days and Total Balance

Jujuk

ING NGARSO SUNG TULODO, ING MADYO MANGUN KARSO, TUT WURI HANDAYANI

6 Reply by juju (edited by juju 06/24/2011 08:33:49 am)

  • juju
  • juju
  • Senior Member
  • Offline
  • From: Indonesia
  • Registered: 02/02/2011
  • Posts: 62

Re: Grand total in the Report -Aged Customer Analysis-

whether it mismatch relates to a data "Customer Credit Note"?

Jujuk

ING NGARSO SUNG TULODO, ING MADYO MANGUN KARSO, TUT WURI HANDAYANI
  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Grand total in the Report -Aged Customer Analysis-

Thanks Jujuk. I now see something spurious here. I will have a closer look.

/Joe

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Grand total in the Report -Aged Customer Analysis-

Hello again,

I see that Customer Payments are not included in the records shown. This is because of a join with the payments terms in the SQL in rep102.php and for the customer payments these values are 0 and there exist no payment term with a value of 0. This is fixed. A bug will be created on Mantis and you can download a new rep102.php file from here.

/Joe

9 Reply by juju (edited by juju 06/24/2011 02:39:15 pm)

  • juju
  • juju
  • Senior Member
  • Offline
  • From: Indonesia
  • Registered: 02/02/2011
  • Posts: 62

Re: Grand total in the Report -Aged Customer Analysis-

Thanks joe.
I want to make the age varies from 30 days, 60 days, 90 days and over 120 days. Where I found the function get_customer_details ?

Jujuk

ING NGARSO SUNG TULODO, ING MADYO MANGUN KARSO, TUT WURI HANDAYANI
  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Grand total in the Report -Aged Customer Analysis-

The interval of 30 days, set in company_prefs, only cover 2 periods of 30 days. If you want to extend this you would have to print the report in Landscape and add the columns and algorithms in file /reporting/rep102.php.
And the same thing in /sales/includes/db/customers_db.inc, function get_customer_details.
The on screen customer transactions also use the function get_customer_details.
Another approach is to extend the interval to 45 days. And use the report as is now.

/Joe

11 Reply by juju (edited by juju 06/25/2011 12:37:42 am)

  • juju
  • juju
  • Senior Member
  • Offline
  • From: Indonesia
  • Registered: 02/02/2011
  • Posts: 62

Re: Grand total in the Report -Aged Customer Analysis-

I've added two intervals aged customer transactions in report 102, all goes well

Thanks for sharing with me
Jujuk

ING NGARSO SUNG TULODO, ING MADYO MANGUN KARSO, TUT WURI HANDAYANI
  • Registered: 11/18/2011
  • Posts: 5

Re: Grand total in the Report -Aged Customer Analysis-

juju wrote:

I've added two intervals aged customer transactions in report 102, all goes well

Thanks for sharing with me
Jujuk


Is this something you can share? I also need such a report.

thanks