AP check formats

Hi Wayne,
I just sent a modified copy of such a report to Wendy Pursche. She is going to test it on Thursday in 4.0 because I couldn't test it from here(we are still on 3.0), . ... in case you don't have it already.

Essentially, you ...(after backing up the main report)
1. make a copy of the main report (the copy will become a subreport).
2. Delete the groupings in the main report, and clear the details section. (leave the page footer as is for the actual check print area).
3. Insert the copy of the report as a subreport, and place it in the details section of the main report.
4. Edit the subreport by deleting the Page footer (the check print part) leaving only the itemized list of invoices.
5. Create a link to the subreport, linking on Checknumber.
6. Do steps 3 - 5 and place the duplicate subreport in the details section below the first one. You can expand the details section and drag the subreports around until they print out in the right place on the Check form.

Hope this works.
Troy Funte
Liberty Electronics



----- Original Message -----
From: Wayne Cox
To: vantage@egroups.com
Sent: Monday, December 04, 2000 8:40 AM
Subject: [Vantage] AP check formats


Hi All.

We're still on Vantage 3, and printing our AP checks on a 2 part
form. Our new Finance Guy wants to switch to a laser printed check when we
upgrade to 4.0. He asked if it was possible to print a duplicate of the
invoice data / remittance advice on the stub, such as:
-----------------------
1. top 3rd
[ invoices - our file copy ]
-----------------------
2. middle 3rd
[ invoices - duplicate of 1st section, to stay with check ]
-----------------------
3. bottom 3rd
[ the check ]
-----------------------

In just a quick initial stab with Crystal, I'm not sure how to duplicate
the invoice detail, or to force the vertical spacing.

Has anyone created a similar check form they'd be willing to share, or have
suggestions on how to do this?

-Wayne Cox


eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



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

We're still on Vantage 3, and printing our AP checks on a 2 part
form. Our new Finance Guy wants to switch to a laser printed check when we
upgrade to 4.0. He asked if it was possible to print a duplicate of the
invoice data / remittance advice on the stub, such as:
-----------------------
1. top 3rd
[ invoices - our file copy ]
-----------------------
2. middle 3rd
[ invoices - duplicate of 1st section, to stay with check ]
-----------------------
3. bottom 3rd
[ the check ]
-----------------------

In just a quick initial stab with Crystal, I'm not sure how to duplicate
the invoice detail, or to force the vertical spacing.

Has anyone created a similar check form they'd be willing to share, or have
suggestions on how to do this?

-Wayne Cox
You can create sections 'details a' ,'details b', and so on. Put your
fields in each section and they will print in duplicate. In the section
expert just highlight details and click on 'insert'. I have done this on
other reports not a check but it should work. Spacing seems like a lot of
trial and error to get it working right. Once you have the second details
section you could 'play around' to see what happens. Going to be a
challenge if you are including multiple invoices on one check.

Jerry Boyle
SIPCO, Inc
Meadville, Pa. 16335
814.724.2243

From: Wayne Cox [mailto:wmc@...]
Subject: [Vantage] AP check formats
We're still on Vantage 3, and printing our AP checks on a 2 part
form. Our new Finance Guy wants to switch to a laser printed check when we
upgrade to 4.0. He asked if it was possible to print a duplicate of the
invoice data / remittance advice on the stub, such as:
-----------------------
1. top 3rd
[ invoices - our file copy ]
-----------------------
2. middle 3rd
[ invoices - duplicate of 1st section, to stay with check ]
-----------------------
3. bottom 3rd
[ the check ]
-----------------------
Has anyone created a similar check form they'd be willing to share, or have
suggestions on how to do this?
I just created a Crystal check form for our AP person. The form has a
subreport on the top and middle part of the check stub that lists (or
suppose to) all the invoices for that check. Then she tears off the top
part for our records and sends the middle part of the stub and check to the
Vendor. It's not completely problem free yet. I'm having Troy Funte look
it over for me to show me the error of my ways. If you want to I'll send it
to you when it's error free. Or, if you're better at Crystal than I am (I'm
not an expert at all), I'll send you my beta version.

Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...

----- Original Message -----
From: Wayne Cox <wmc@...>
To: <vantage@egroups.com>
Sent: Monday, December 04, 2000 11:40 AM
Subject: [Vantage] AP check formats


> Hi All.
>
> We're still on Vantage 3, and printing our AP checks on a 2 part
> form. Our new Finance Guy wants to switch to a laser printed check when
we
> upgrade to 4.0. He asked if it was possible to print a duplicate of the
> invoice data / remittance advice on the stub, such as:
> -----------------------
> 1. top 3rd
> [ invoices - our file copy ]
> -----------------------
> 2. middle 3rd
> [ invoices - duplicate of 1st section, to stay with check ]
> -----------------------
> 3. bottom 3rd
> [ the check ]
> -----------------------
>
> In just a quick initial stab with Crystal, I'm not sure how to duplicate
> the invoice detail, or to force the vertical spacing.
>
> Has anyone created a similar check form they'd be willing to share, or
have
> suggestions on how to do this?
>
> -Wayne Cox
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)