Report builder - cash requirements

As we did not have any vendors with terms beyond 30 days, we just adjusted
the age columns in A/P to age every 7 days. Then we printed the A/P aging
for 5 weeks in the future and we had our weekly cash requirements. Doesn't
handle the discount portion however.

Rick Lane
Intelligent Systems Integration, Inc.
661 B Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275

"Helping Business Make Intelligent Use of Technology"

-----Original Message-----
From: eli3@... [mailto:eli3@...]
Sent: Thursday, October 18, 2001 11:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] report builder - cash requirements


Has anyone had success creating a cash requirements report?
This would show projected cash requirements based upon invoices
received by vendor, by date (and or range), including any discount,
totaled by vendor????

thanks in advance.

Lee





[Non-text portions of this message have been removed]
Has anyone had success creating a cash requirements report?
This would show projected cash requirements based upon invoices
received by vendor, by date (and or range), including any discount,
totaled by vendor????

thanks in advance.

Lee
In Crystal, yes.

Troy Funte
Liberty Electronics

----- Original Message -----
From: eli3@...
To: vantage@yahoogroups.com
Sent: Thursday, October 18, 2001 11:42 AM
Subject: [Vantage] report builder - cash requirements


Has anyone had success creating a cash requirements report?
This would show projected cash requirements based upon invoices
received by vendor, by date (and or range), including any discount,
totaled by vendor????

thanks in advance.

Lee


Yahoo! Groups Sponsor



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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
What about the "Aged Payables" report?
-----Original Message-----
From:
sentto-20369-24797-1003419770-jhellebuyck=stremel.com@...
[mailto:sentto-20369-24797-1003419770-jhellebuyck=stremel.com@...
t.com]On Behalf Of eli3@...
Sent: Thursday, October 18, 2001 10:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] report builder - cash requirements


Has anyone had success creating a cash requirements report?
This would show projected cash requirements based upon invoices
received by vendor, by date (and or range), including any discount,
totaled by vendor????

thanks in advance.

Lee


Yahoo! Groups Sponsor



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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
I have one for Version 3.0 that has columns for past due, current, due in 1
week, 2 weeks, 3 weeks, and 4 weeks and greater. It shows the discount
amount and discount date, but I think it still arranges it by the due date
disregarding any discount available. I wanted the report to include
invoices on hold, so you would have to fix that if you didn't want to see
those invoices. I haven't gotten in yet to see if any table changes will
affect this report for the newer versions. Let me know if anyone could
still use this report and I will post it.
Nora Story
Spectra Technologies, Inc.
817-540-4475, ext. 105
nora_story@...

> Has anyone had success creating a cash requirements report?
> This would show projected cash requirements based upon invoices
> received by vendor, by date (and or range), including any discount,
> totaled by vendor????
>
> thanks in advance.
>
> Lee
>
This report was basically useless for me. We pay our bills on time (knock
on wood) and don't need to see the past due invoices aged. What we really
needed to see was a weekly breakdown of what was due in the future.
Nora Story>
> What about the "Aged Payables" report?
> -----Original Message-----
>