Eliminating multiple A/P Checks to one vendor

Yahoo Archive
1
We use a software program called Print Boss, which works great with all of
our forms, including checks. Let me know if you want more information!

Rebecca
P-K Tool
-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Tuesday, May 18, 2004 12:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Eliminating multiple A/P Checks to one vendor


Jeff,

Unfortunately, we find the same problem. Our solution is to count the
number of invoices and then edit the Payable list to print as many checks
as
necessary. Cumbersome? Heck, yes. Would I like another solution? Yes
again. But in the meantime, we do what we have to. We print checks twice
a
month and may only have 1 vendor "over the limit." I try to remember that
there are other things Epicor has fixed....hoping this will be one in the
very near future! ;(

The only other workaround I could see for you (since you have such a large
number of invoices) would be to perhaps enter the invoices in a
spreadsheet
as they came in (Number, Date, Inv #, amount, etc). When it's time to
print
checks, total the invoices necessary and enter 1 invoice in your system.
Then print out the section of the spreadsheet associated with that
"invoice"
and enclose it with the check for the vendor's reconciliation needs.

HTH

Tricia Simon, Controller
Riten Industries, Inc.


-----Original Message-----
From: j_milbrath [mailto:jeffrey.milbrath@...]
Sent: Wednesday, May 12, 2004 5:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Eliminating multiple A/P Checks to one vendor


It appears Vantage is not capable of printing only one A/P check
when paying more vendor invoices than will fit on one check form.
Has anyone developed a Crystal Report form that will accomplish
this? Or, is indexing the check number to skip the voids an issue
that can't be overcome.

Every other system I have ever worked with would print "VOID" on the
check forms until it reached the form with the final invoice
selected for payment and then print the total of all invoices
selected on the final check form.

We are currently on version 6.1, printing carbonless copy pin fed
check forms on a dot matrix printer with the check positioned on the
bottom 1/3 of the page. Up to 27 vendor invoices will print on the
top 2/3 remittance detail section of each check form. I'm cutting a
check to pay over 500 invoices to a related company only to find
that Vantage actually cuts me 22 individual checks! This will be an
even larger issue if I get my wish to change to laser printed
checks, where I will then have only enough room on the vendor
remittance section for 12 invoices. (1/3 of the form will be our
file copy of the remittance.) Many more vendors would get many more
checks. Not sure I like paying our bank to process unnecessary
checks.

CAN ANYONE HELP ???

Jeff Milbrath
Controller
Hartford Finishing, Inc.
jeffrey.milbrath@...




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







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 Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

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



[Non-text portions of this message have been removed]
2
It appears Vantage is not capable of printing only one A/P check
when paying more vendor invoices than will fit on one check form.
Has anyone developed a Crystal Report form that will accomplish
this? Or, is indexing the check number to skip the voids an issue
that can't be overcome.

Every other system I have ever worked with would print "VOID" on the
check forms until it reached the form with the final invoice
selected for payment and then print the total of all invoices
selected on the final check form.

We are currently on version 6.1, printing carbonless copy pin fed
check forms on a dot matrix printer with the check positioned on the
bottom 1/3 of the page. Up to 27 vendor invoices will print on the
top 2/3 remittance detail section of each check form. I'm cutting a
check to pay over 500 invoices to a related company only to find
that Vantage actually cuts me 22 individual checks! This will be an
even larger issue if I get my wish to change to laser printed
checks, where I will then have only enough room on the vendor
remittance section for 12 invoices. (1/3 of the form will be our
file copy of the remittance.) Many more vendors would get many more
checks. Not sure I like paying our bank to process unnecessary
checks.

CAN ANYONE HELP ???

Jeff Milbrath
Controller
Hartford Finishing, Inc.
jeffrey.milbrath@...
3
Jeff,

Unfortunately, we find the same problem. Our solution is to count the
number of invoices and then edit the Payable list to print as many checks as
necessary. Cumbersome? Heck, yes. Would I like another solution? Yes
again. But in the meantime, we do what we have to. We print checks twice a
month and may only have 1 vendor "over the limit." I try to remember that
there are other things Epicor has fixed....hoping this will be one in the
very near future! ;(

The only other workaround I could see for you (since you have such a large
number of invoices) would be to perhaps enter the invoices in a spreadsheet
as they came in (Number, Date, Inv #, amount, etc). When it's time to print
checks, total the invoices necessary and enter 1 invoice in your system.
Then print out the section of the spreadsheet associated with that "invoice"
and enclose it with the check for the vendor's reconciliation needs.

HTH

Tricia Simon, Controller
Riten Industries, Inc.


-----Original Message-----
From: j_milbrath [mailto:jeffrey.milbrath@...]
Sent: Wednesday, May 12, 2004 5:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Eliminating multiple A/P Checks to one vendor


It appears Vantage is not capable of printing only one A/P check
when paying more vendor invoices than will fit on one check form.
Has anyone developed a Crystal Report form that will accomplish
this? Or, is indexing the check number to skip the voids an issue
that can't be overcome.

Every other system I have ever worked with would print "VOID" on the
check forms until it reached the form with the final invoice
selected for payment and then print the total of all invoices
selected on the final check form.

We are currently on version 6.1, printing carbonless copy pin fed
check forms on a dot matrix printer with the check positioned on the
bottom 1/3 of the page. Up to 27 vendor invoices will print on the
top 2/3 remittance detail section of each check form. I'm cutting a
check to pay over 500 invoices to a related company only to find
that Vantage actually cuts me 22 individual checks! This will be an
even larger issue if I get my wish to change to laser printed
checks, where I will then have only enough room on the vendor
remittance section for 12 invoices. (1/3 of the form will be our
file copy of the remittance.) Many more vendors would get many more
checks. Not sure I like paying our bank to process unnecessary
checks.

CAN ANYONE HELP ???

Jeff Milbrath
Controller
Hartford Finishing, Inc.
jeffrey.milbrath@...




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
4
As another work around, you might try going the other way. Don't print detail at all on the check stubs then create a report that prints the detail on a separate sheet of paper. Group by check number and force a new page and it should come out fine. This way you can have 3 checks per page. The only added work would be matching the checks up to the detail printouts. This way your not wasting more expensive checks with VOID printed on them.

Just a thought,
Jeremy


-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Tuesday, May 18, 2004 12:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Eliminating multiple A/P Checks to one vendor


Jeff,

Unfortunately, we find the same problem. Our solution is to count the
number of invoices and then edit the Payable list to print as many checks as
necessary. Cumbersome? Heck, yes. Would I like another solution? Yes
again. But in the meantime, we do what we have to. We print checks twice a
month and may only have 1 vendor "over the limit." I try to remember that
there are other things Epicor has fixed....hoping this will be one in the
very near future! ;(

The only other workaround I could see for you (since you have such a large
number of invoices) would be to perhaps enter the invoices in a spreadsheet
as they came in (Number, Date, Inv #, amount, etc). When it's time to print
checks, total the invoices necessary and enter 1 invoice in your system.
Then print out the section of the spreadsheet associated with that "invoice"
and enclose it with the check for the vendor's reconciliation needs.

HTH

Tricia Simon, Controller
Riten Industries, Inc.


-----Original Message-----
From: j_milbrath [mailto:jeffrey.milbrath@...]
Sent: Wednesday, May 12, 2004 5:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Eliminating multiple A/P Checks to one vendor


It appears Vantage is not capable of printing only one A/P check
when paying more vendor invoices than will fit on one check form.
Has anyone developed a Crystal Report form that will accomplish
this? Or, is indexing the check number to skip the voids an issue
that can't be overcome.

Every other system I have ever worked with would print "VOID" on the
check forms until it reached the form with the final invoice
selected for payment and then print the total of all invoices
selected on the final check form.

We are currently on version 6.1, printing carbonless copy pin fed
check forms on a dot matrix printer with the check positioned on the
bottom 1/3 of the page. Up to 27 vendor invoices will print on the
top 2/3 remittance detail section of each check form. I'm cutting a
check to pay over 500 invoices to a related company only to find
that Vantage actually cuts me 22 individual checks! This will be an
even larger issue if I get my wish to change to laser printed
checks, where I will then have only enough room on the vendor
remittance section for 12 invoices. (1/3 of the form will be our
file copy of the remittance.) Many more vendors would get many more
checks. Not sure I like paying our bank to process unnecessary
checks.

CAN ANYONE HELP ???

Jeff Milbrath
Controller
Hartford Finishing, Inc.
jeffrey.milbrath@...




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








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
5
Jeff,

The way I've accomplished this on our 3 part laser checks is this:

1) Go into the Section Expert, choose Details on the left, click on
the X-2 Pencil icon next to Suppress and enter
"{APTRAN.LINECNTR}>27".
This will suppress all detail lines with a line number greater than
27.

2) If we have any checks that go over 15 lines (the most we can fit)
in the Group Footer for checkhed.checknum I turn on a text field
"*** See Separate Remittance Advice ***". To do this create a formula
call "Lines" with this in it

Maximum ({APTRAN.LINECNTR},{CHECKHED.CHECKNUM})

Put the text in the footer, right click on it, choose "Format Text".
On the common tab, click on the X-2 Pencil icon next to Suppress, and
type in:

{@Lines}<=27

this will turn off the text for any check with less than 27 lines of
invoices. Then you can create a separate report for the remittance
advice.

You could also do this for Docckamt {@Lines>27} to turn this off if
there's
more lines than what will fit. Then you could put the text field on
top
of the Docckamt field and one or the other would be visible depending
on
the number of invoice lines.

We will only print remittance advices for checks with more than 15
lines,
because 15 & less will fit on the check (and this wastes less paper).

Rebecca Snyder

PS. We haven't gone live with Vantage, yet, but it works great in our
test environment. I may be learning Vantage, but I've used Crystal
Reports for many years.


-----Original Message-----
From: j_milbrath [mailto:jeffrey.milbrath@...]
Sent: Wednesday, May 12, 2004 5:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Eliminating multiple A/P Checks to one vendor


It appears Vantage is not capable of printing only one A/P check when
paying more vendor invoices than will fit on one check form. Has anyone
developed a Crystal Report form that will accomplish this? Or, is
indexing the check number to skip the voids an issue that can't be
overcome.

Every other system I have ever worked with would print "VOID" on the
check forms until it reached the form with the final invoice selected
for payment and then print the total of all invoices selected on the
final check form.

We are currently on version 6.1, printing carbonless copy pin fed check
forms on a dot matrix printer with the check positioned on the bottom
1/3 of the page. Up to 27 vendor invoices will print on the top 2/3
remittance detail section of each check form. I'm cutting a check to pay
over 500 invoices to a related company only to find that Vantage
actually cuts me 22 individual checks! This will be an even larger issue
if I get my wish to change to laser printed checks, where I will then
have only enough room on the vendor remittance section for 12 invoices.
(1/3 of the form will be our file copy of the remittance.) Many more
vendors would get many more checks. Not sure I like paying our bank to
process unnecessary checks.

CAN ANYONE HELP ???

Jeff Milbrath
Controller
Hartford Finishing, Inc.
jeffrey.milbrath@...




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








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