[6.1] Highest A/R Balance for Customer

system · February 17, 2006, 1:33pm

Thanks, Dick! I'll give this a try.

On Fri Feb 17 11:09 , 'PLAMAN DICK' <dick.plaman@...> sent:

>Rebecca,
>Yes, I get the open invoices. The filters are Company = ' ',
>InvcHead.OpenInvoice = yes, and InvcHead.Posted = yes.
>I sort on Customer Name and then Invoice Num.
>The T-1 filter is the days since the cash receipts were posted.
>Let me know if you have any questions.
>
>Regards,
>
>
>[Non-text portions of this message have been removed]
>
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have

already linked your email address to a yahoo id to enable access. )

>(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal

Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.

>(2) To search through old msg's goto:

http://groups.yahoo.com/group/vantage/messages

>(3) To view links to Vendors that provide Vantage services goto:

http://groups.yahoo.com/group/vantage/links

>Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>
>
>

system · February 17, 2006, 11:06am

Just got asked for a report to show highest A/R balance (our exposure) we've had for various customers. I need the max balance and when it occured (if possible).

I'm thinking of a transaction based report and a running total column. Might even dump to Excel and graph it.

Any ideas what tables would be needed for AR transactions and payments? Would they be in the same table?

Better yet...anyone with an RB report like this that they could share?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[Non-text portions of this message have been removed]

system · February 17, 2006, 11:25am

Hey Todd,
I have an RB export that looks at the InvHead table and subtracts the
CashDtl. Our Finance
Department wanted it to be an aging report so it is in buckets of
current - 30- 60 - 90 - 120
By customer. Finance dept also wanted by product group so that info
comes along.
Let me know if you want to see a sample of the output or just want the
report.

One other thing, finance wanted the report to agree with the progress
version of the aged
Receivables so there is a run-time filter that needs to be set (T-1)
that subtracts the days
Elapsed since the cash detail was posted so I get the same info in the
same buckets.

Regards,

system · February 17, 2006, 11:58am

Dick,

I wrote an RB for the controller for similar reasons (just not the buckets) using
InvHead and CashDtl. However, none of the open invoices show on that report
(another user suggested CashDtl is tied to closed invoices). May I ask if you
found a way around that?

Thanks,
Rebecca
P-K Tool

On Fri Feb 17 9:25 , 'PLAMAN DICK' <dick.plaman@...> sent:

>Hey Todd,
>I have an RB export that looks at the InvHead table and subtracts the
>CashDtl. Our Finance
>Department wanted it to be an aging report so it is in buckets of
>current - 30- 60 - 90 - 120
>By customer. Finance dept also wanted by product group so that info
>comes along.
>Let me know if you want to see a sample of the output or just want the
>report.
>
>One other thing, finance wanted the report to agree with the progress
>version of the aged
>Receivables so there is a run-time filter that needs to be set (T-1)
>that subtracts the days
>Elapsed since the cash detail was posted so I get the same info in the
>same buckets.
>
>
>
>Regards,
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have