I have a "Days to Pay" report in which I take the invoice ClosedDate and
subtract from it the InvoiceDate. I then average these (pre-pass) for all
closed invoices (paid) for the customer and sort the report from High to Low
ang # of Days. It corresponds pretty well with the Customer Tracker figure.
It gives the credit manager a good look at who is most likely to affect DSO
based on past trends. An invoice by invoice details version could highlight
cases where one credit issue skewed an otherwise OK payment history.
-Todd C.
-----Original Message-----
From: Todd Hofert [mailto:
thofert@...]
Sent: Thursday, December 20, 2001 10:08 AM
To: Vantage List (E-mail)
Subject: [Vantage] RB Report
I have been asked to create a report that shows Customer, Ship via, FOB,
Credit Limit, Credit Hold, and Average Days to Pay. How can I acquire the
average days to pay? I can see it in the Invoice Aging of Customer tracker.
Does that value get stored or is it calculated? If calculated can anyone
help me with calculating that value in report builder? If stored, where is
it?
Thanks in advance
Todd Hofert
Spartan Graphics, Inc.
(616)887-8243
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=214563.1778827.3296761.1261774/D=egroupweb/S=17050071
83:HM/A=867009/R=0/*
http://www.crystalvoicelive.com/whatFamily.asp?Affiliate
Id=00120002>
<
http://us.adserver.yahoo.com/l?M=214563.1778827.3296761.1261774/D=egroupmai
l/S=1705007183:HM/A=867009/rand=899185343>
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/.
<
http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<
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
<
http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]