payment voucher

[anuedwardlobo]

I was thinking of designing a "payment voucher" that would be printed when a user "prints a check".
How do I get a list of fields that "print a check" gives so that I can catch them in crystal report.
Any help would be greatly appreciated.

 

[Jay Converse]

Edit any of the APCHK*.RPT files.

 

[anuedwardlobo]

I cannot get check number to print ? The field showing on the form is "@check number"

 

[anuedwardlobo]

Is there also a way to query the invoices I pay in the AP file and pull the nominal accounts debited or credited on that invoice ?

thanks for the help

 

[Jay Converse]

1. @check number is a formula, you need to edit it.
2. Join to APADV to APOBL to APIBH in a subreport.

 

[ettienne]

The @check number formula is supressed as well, you not to uncheck the suppress box to print it on your check form.

You would also need APIBD to get the GL accounts.

 

[anuedwardlobo]

I tried creating the sub-report as follows:

Linked
apadv to apobl (payeecde & Refnum -> idvend and idinvc
apobl to apibh (idvend and idinvc to idvend and idinvc
apibh to apibd (cntbtch, cntitem to cntbtch, cntitem)

and then selected to display fields idglacct and amtgldist

on the links field I linked apadv.refnum to apadv.refnum
apadv.payeecde to bkreg.payeeid

What else needs to go here.
Sorry I am new to crystal reports and would appreciate any possible help.

 

[anuedwardlobo]

the link in select expert looks like this

{APADV.REFNUM}={?Pm-APADV.REFNUM} and
{APADV.PAYEECDE}={?Pm-BKREG.PAYEEID}

 

[anuedwardlobo]

resolved...thanks for all the help. I just have one query on the join type which I have asked as a seperate thread