Positive Pay Reports

Jared,



Thanks. Glad I wasn't overlooking the obvious. But what do you do with
Voids? Do they just do a "refresh all" and resubmit previously
submitted data back to the bank? I think we had to do that before and
it wasn't a problem.



Regarding your second paragraph, I couldn't agree more. It certainly
sparks debate here on this forum. I've done so much with Vantage and
ASP and our intranet that I rarely create BAQ's anymore and when I do it
feels like I've digressed back to 80's technology.



If you're an ASP guy.... Check out this product:
http://xlinesoft.com/asprunnerpro/index.htm



It's called ASPRunner Pro. Within minutes you can create super slick
ASP pages with exporting capabilities, multi-column sorts, etc. And the
price is right.



In fact, I'm going to use this for Positive Pay. You can easily export
results to Excel, CSV, etc. and even pick-and-choose what you want to
export.



The only reason I like views, By the way, is I don't like giving
permissions for anything to hit the tables directly. Using views
mitigates the risk of record locking and foolish behavior. But either
way, it sure beats the heck out of Progress.



....and let the flaming SQL/Progress debates begin... :-)









Vic





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of k99ja04
Sent: Friday, August 06, 2010 10:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Positive Pay Reports





We do essentially what you discussed Vic. We are also SQL and I just run
a query from within Excel that populates a table. When accounting wants
new data they just do a Data > Refresh All. We also base on CheckDate.
The query performance is fine so I never saw the need to create a SQL
View.

On a tangent, I just don't understand how non-SQL customers do it. I
have been asked for so many reports that I just don't see how to easily
do within Vantage. Admittedly I am weak on BPMs, but solid on Crystal. I
have written BAQs that take minutes where the same data is returned from
a SQL query in seconds. It's so much easier to write a SQL query and
spit out a ASP.NET GridView page on our intranet. We're talking less
than 15 minutes start to end assuming the query itself is
straightforward enough. I know Progress has ODBC access, but the
development tools are "clunky" to be polite. With SQL Server Reporting
Services support in 9.05, it seems like a slam-dunk for SQL server.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Vic
Drecchio" <vic.drecchio@...> wrote:
>
> Happy Friday.
>
>
>
> I'm curious to know what you all may be doing for Positive Pay reports
> for your banks.
>
>
>
> I've always queried CheckHed and that data seems just fine. I would
> filter on a date range and Finance was happy.
>
>
>
> I've always used CheckHed.CheckDate for the transaction date and this
is
> what I'd let the report filter upon when Finance is running for a
> certain period.
>
>
>
> This is all good except in the event of a Voided check. Obviously if
> the Check was posted and cut on 07/03/2010 and it was voided on
> 08/04/2010 the voided data never gets included in "this week's"
positive
> pay report because the CheckDate hasn't changed. Therefore the bank
> never gets word of our void. There's no VoidDate in CheckHed.
>
>
>
> Voided transactions are in APTran. So then I thought about using
APTran
> for the Positive Pay report as voided transactions are individual
> records with their own corresponding TranDates. But, being that APTran
> is the child table to CheckHed there can be multiple records for one
> check. Multiple Invoices/Payments can be on one collective Check
> Payment. So, that doesn't seem to work either.
>
>
>
> Luckily I'm a SQL customer so I'm certain I can come up with a
creative
> SQL View to get me what I need but I wanted to make sure I wasn't
> overlooking something else obvious.
>
>
>
>
>
> Thank you!
>
>
>
>
>
> Vic
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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



I'm curious to know what you all may be doing for Positive Pay reports
for your banks.



I've always queried CheckHed and that data seems just fine. I would
filter on a date range and Finance was happy.



I've always used CheckHed.CheckDate for the transaction date and this is
what I'd let the report filter upon when Finance is running for a
certain period.



This is all good except in the event of a Voided check. Obviously if
the Check was posted and cut on 07/03/2010 and it was voided on
08/04/2010 the voided data never gets included in "this week's" positive
pay report because the CheckDate hasn't changed. Therefore the bank
never gets word of our void. There's no VoidDate in CheckHed.



Voided transactions are in APTran. So then I thought about using APTran
for the Positive Pay report as voided transactions are individual
records with their own corresponding TranDates. But, being that APTran
is the child table to CheckHed there can be multiple records for one
check. Multiple Invoices/Payments can be on one collective Check
Payment. So, that doesn't seem to work either.



Luckily I'm a SQL customer so I'm certain I can come up with a creative
SQL View to get me what I need but I wanted to make sure I wasn't
overlooking something else obvious.





Thank you!





Vic





[Non-text portions of this message have been removed]
We do essentially what you discussed Vic. We are also SQL and I just run a query from within Excel that populates a table. When accounting wants new data they just do a Data > Refresh All. We also base on CheckDate. The query performance is fine so I never saw the need to create a SQL View.

On a tangent, I just don't understand how non-SQL customers do it. I have been asked for so many reports that I just don't see how to easily do within Vantage. Admittedly I am weak on BPMs, but solid on Crystal. I have written BAQs that take minutes where the same data is returned from a SQL query in seconds. It's so much easier to write a SQL query and spit out a ASP.NET GridView page on our intranet. We're talking less than 15 minutes start to end assuming the query itself is straightforward enough. I know Progress has ODBC access, but the development tools are "clunky" to be polite. With SQL Server Reporting Services support in 9.05, it seems like a slam-dunk for SQL server.


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Happy Friday.
>
>
>
> I'm curious to know what you all may be doing for Positive Pay reports
> for your banks.
>
>
>
> I've always queried CheckHed and that data seems just fine. I would
> filter on a date range and Finance was happy.
>
>
>
> I've always used CheckHed.CheckDate for the transaction date and this is
> what I'd let the report filter upon when Finance is running for a
> certain period.
>
>
>
> This is all good except in the event of a Voided check. Obviously if
> the Check was posted and cut on 07/03/2010 and it was voided on
> 08/04/2010 the voided data never gets included in "this week's" positive
> pay report because the CheckDate hasn't changed. Therefore the bank
> never gets word of our void. There's no VoidDate in CheckHed.
>
>
>
> Voided transactions are in APTran. So then I thought about using APTran
> for the Positive Pay report as voided transactions are individual
> records with their own corresponding TranDates. But, being that APTran
> is the child table to CheckHed there can be multiple records for one
> check. Multiple Invoices/Payments can be on one collective Check
> Payment. So, that doesn't seem to work either.
>
>
>
> Luckily I'm a SQL customer so I'm certain I can come up with a creative
> SQL View to get me what I need but I wanted to make sure I wasn't
> overlooking something else obvious.
>
>
>
>
>
> Thank you!
>
>
>
>
>
> Vic
>
>
>
>
>
> [Non-text portions of this message have been removed]
>