FrontAccounting forum — Grand total in the Report -Aged Customer Analysis-

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

null@example.com (malcrf) — Wed, 17 Oct 2012 08:48:30 +0000

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

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

null@example.com (juju) — Sat, 25 Jun 2011 00:29:37 +0000

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

Thanks for sharing with me
Jujuk

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

null@example.com (joe) — Fri, 24 Jun 2011 20:40:07 +0000

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

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

null@example.com (juju) — Fri, 24 Jun 2011 14:35:49 +0000

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

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

null@example.com (joe) — Fri, 24 Jun 2011 10:36:12 +0000

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

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

null@example.com (joe) — Fri, 24 Jun 2011 08:49:02 +0000

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

/Joe

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

null@example.com (juju) — Fri, 24 Jun 2011 08:33:32 +0000

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

Jujuk

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

null@example.com (juju) — Fri, 24 Jun 2011 08:24:17 +0000

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

Jujuk

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

null@example.com (joe) — Fri, 24 Jun 2011 07:47:04 +0000

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

/Joe

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

null@example.com (juju) — Fri, 24 Jun 2011 07:41:33 +0000

I've used FA 2.3.5

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

null@example.com (joe) — Fri, 24 Jun 2011 07:31:53 +0000

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

Grand total in the Report -Aged Customer Analysis-

null@example.com (juju) — Fri, 24 Jun 2011 06:36:14 +0000

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