Aged trial balance report summary

[guyinstyle]

Dear all gurus,

I need your urgent help.

When I query Accpac 5.5 or Sage 500 to get the summarized debtor report I only get 2 customers instead of 8 customers.
I checked the A/R Invoice batch list and found that all the transcation already been posted but still i am only getting 2 customers in the aged trial balance summary report.
When I run the day end process I noticed that all customers are processed but the final report shows only two.

Your urgent advise should be highly appreciated.

Thanks.

 

[Jay Converse]

Is this a custom report?
Did you check the box for zero balance customers?

 

[guyinstyle]

Hi Tuba2007,

I am not an ACCPAC expert, sorry for any inconvineance.

No this is not a custom report secondly can you please guide me from where I can check zero balance customers?

Thanks in advance.

 

[Jay Converse]

It's a checkbox when you print. Labeled "Customers with a zero balance".

 

[guyinstyle]

Thanks Tuba,

Let me run this report with my finance team and then i'll get back to you at my earliest.

Many thanks.

 

[guyinstyle]

Hi Tuba,

Actually the customer balance is not zero. What happen here, if the customer is in USD it will appear in the summary but if the customer is in functional, the grand total appears but the detail per customer is not appearing.
Also this is not a customized report so I am not sure what makes the problem.

I tested this on my local accpac and works 100% as normal.

please guide.

many thanks.

 

[Jay Converse]

I've never heard of this problem before, nor has it been reported on the Sage forums. If it works on your system, it implies they have a custom form.

 

[guyinstyle]

any suggestions guys on my query???? Please !!!!!

 

[Jay Converse]

The experts always watch this forum. From the start, it doesn't add up.

For example, there is no such thing as a "summarized debtor" report in Sage Accpac 5.5. Which again implies it's a custom report.

But, if you truly mean the new Sage 500, meaning MAS instead of Accpac, then you're in the wrong forum.

 

[guyinstyle]

Hi Tuba,

Thanks for your suggestion. One of my old accpac consultant resolve it.
The report is working fine, only they use the wrong parameters to run the report.

Thanks for all your help, much appreciated.

 

[guyinstyle]

Can someone told me how I close this thread?
Thanks.