Page 1 of 1

print accounting on check stubs

Posted: Mon May 14, 2007 10:39 am
by lisak
Is there a way to print the accounting flow on a check stub. Basically, can you show what account was debited?

Posted: Mon May 14, 2007 10:51 am
by Zorak
Version 10 allows you to choose to print account distributions on the bottom check stub in Accounts Payable.

If using v10, the option to turn on is under File > Preferences > Accounting Setup > Accounts Payable.

Posted: Mon May 14, 2007 5:15 pm
by tborgal
If you are using a custom check layout imported from a previous version it will not work without doing the layout all over. If you have made a lot of modifications like I have that is little disappointing because I don't want to have to redo what has already been done.

Posted: Wed May 16, 2007 2:18 pm
by Jeff
Tom,

We noramlly tell people to redo the layout because many items in the layout may need to be changed to add the new items.

That said, here is how you can add the account distribution to an existing custom check layout:

Make a backup of all files, this will also backup your custom check layout.
(you can also make copies of the chkcust.frx & chkcust.frt files in the layout folder these are the custom check files)

Open the edit layout for your custom check.

Ungroup the bottom stub. (Click the bottom stub area once and select format -> ungroup.)

At this point all the objects in the bottom stub area will be selected. Make sure they are still all selected and double click on one of the field objects. This will display a Multiple Selection dialog. On the properties page, check the "apply these conditions to the selected ojects upon saving:" option and enter "empty(AcctDist)" in the "Print only when expression is true:" area. Now click OK

(What this does is keeps the bottom stub from printing when we have account distributions.)

Regroup the bottom stub by selecting Format -> Group.

Now add a new "Field" object to the check layout. (click the field button on the toolbar and click and drag to create the field)

For the expression enter "AcctDist" and size the field to cover the bottom stub area.

That should all the changes that are necessary to add the account distribution to a custom check.

If you have a problem, just copy the chkCust.* files back into the layout folder.

You don't want to just delete the bottom stub becuase Payroll check don't print the account distribution so you will want the existing layout to print in those cases.

Posted: Thu May 17, 2007 2:44 am
by NeilZ
Hmmm ... looks like that could be a neat addition to either the 'tales from tech 2' emails, or just to the knowledge base in general!!

Posted: Thu May 17, 2007 8:20 am
by tborgal
I tried this on an off sight computer and it does work. However it did some overwriting on the header of the distribution section. The reference information was printed twice. The second time it was bold and on top of the header. Could this have something to do with the adjusted layout of the stub? Also I expected the account info to be in addition to what was already on the stub, not replacing it. Kind of caught me off guard. Not necessarily a bad thing just an unexpected thing.

PS

Neil don't you ever sleep??

Posted: Thu May 17, 2007 9:03 am
by Zorak
It sounds like some of the things may not have gotten the "Print When" assigned. Every item should print with either A. Distributions or B. No distributions.

Posted: Thu May 17, 2007 10:33 am
by tborgal
Your probably right. I tried it again today and it seemed to work OK. I would like to leave some of the original information on the stub, including name and address of the vendor and the check number. I was able to leave the check number, but when I left the name and address the distribution did not print out. Could have something to do with what fields are in the front and back of the form. I'll have to play with this a little more on a test version to see if I can get the results I would like.