Aged Receivables Report

Yahoo Archive
1
Thanks..that is what I thought it was going to be.

Kersten MacLennan
IT/ERP Analyst
Semrock
A Unit of IDEX Corporation
3625 Buffalo Road, Suite 6
Rochester, New York 14624

585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation

Hundreds of Thousands of Ion Beam Sputtered filters delivered -
extensive inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Nigel Kerley
Sent: Wednesday, November 19, 2008 10:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Aged Receivables Report



Hi Kersten,

I don't believe you can add more buckets inside Vantage. You can't
add Calculated Fields to the report definition without the SDK.

So the only way I can think of would be to amend the Crystal Report
and put some new formulas in there.

If you added in the field "ARDtls.CurDueDate" into the standard
report definition, then maybe a formula like "ARDtls.CurDueDate >
RptParameter.AgingDate + ###" would work. The ### being your new
bucket.

HTH.

Nigel.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"kam4085" <kmaclennan@...> wrote:
>
> I need to modify our receivables report. The standard has a current
> bucket and then 5 past due buckets. I need to have 9 past due
buckets.
> The entire report is populated through calculated fields. Is there
a
> way I can get to these so I can modify and add more? The current
report
> takes whatever is left beyond the next to last bucket and
calculates
> the balance due for the last bucket. I need to split this value up
and
> then add calculations for the new paramters. I know I can add
> calculated fields in the report definition but I don't know how to
> define the calculations.
>
> Any help would be appreciated.
>
> Kersten
>






[Non-text portions of this message have been removed]
2
Does anyone have a Crystal Report made up that includes only the over
30,60,90 and 120 day invoices? The report in Vantage prints out future
and current invoices. This report is usually too long for what we need.
If you have another report made up I'll take a look at that as well.
Please send it to my email if you have one.



Thanks,



Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate@...>





[Non-text portions of this message have been removed]
3
I need to modify our receivables report. The standard has a current
bucket and then 5 past due buckets. I need to have 9 past due buckets.
The entire report is populated through calculated fields. Is there a
way I can get to these so I can modify and add more? The current report
takes whatever is left beyond the next to last bucket and calculates
the balance due for the last bucket. I need to split this value up and
then add calculations for the new paramters. I know I can add
calculated fields in the report definition but I don't know how to
define the calculations.

Any help would be appreciated.

Kersten
4
Hi Kersten,

I don't believe you can add more buckets inside Vantage. You can't
add Calculated Fields to the report definition without the SDK.

So the only way I can think of would be to amend the Crystal Report
and put some new formulas in there.

If you added in the field "ARDtls.CurDueDate" into the standard
report definition, then maybe a formula like "ARDtls.CurDueDate >
RptParameter.AgingDate + ###" would work. The ### being your new
bucket.


HTH.

Nigel.

--- In vantage@yahoogroups.com, "kam4085" <kmaclennan@...> wrote:
>
> I need to modify our receivables report. The standard has a current
> bucket and then 5 past due buckets. I need to have 9 past due
buckets.
> The entire report is populated through calculated fields. Is there
a
> way I can get to these so I can modify and add more? The current
report
> takes whatever is left beyond the next to last bucket and
calculates
> the balance due for the last bucket. I need to split this value up
and
> then add calculations for the new paramters. I know I can add
> calculated fields in the report definition but I don't know how to
> define the calculations.
>
> Any help would be appreciated.
>
> Kersten
>