User Support Forum

When running an AP Custom report for disbursements, manual and computer generated checks, I need to show the description from the invoice that was entered into the Maintain Invoices. However, when a check is issued for multiple invoices, the description field is distorted and picks up one of the invoice descriptions. How can we modify the description field on the custom report for checks with multiple invoices to reflect this check is for multiple invoices?

NorwalkUMC wrote:When running an AP Custom report for disbursements, manual and computer generated checks, I need to show the description from the invoice that was entered into the Maintain Invoices. However, when a check is issued for multiple invoices, the description field is distorted and picks up one of the invoice descriptions. How can we modify the description field on the custom report for checks with multiple invoices to reflect this check is for multiple invoices?

Just a quick question ... which version are you running ??

PCPlus11

I can't duplicate what you're seeing.

When I print one check to a vendor who has three open invoices using Custom Reports, as long as I include Transaction Detail in the output, I get all three descriptions.

You'll have to describe your query and output for your custom report unless their are other theories out there.

NeilZ?

JohnDMeyers wrote:I can't duplicate what you're seeing.

When I print one check to a vendor who has three open invoices using Custom Reports, as long as I include Transaction Detail in the output, I get all three descriptions.

You'll have to describe your query and output for your custom report unless their are other theories out there.

NeilZ?

Sorry John ... no idea, I don't do any Custom Reports in Accounting, so I can't assist here.

Here are the details of the AP Custom Report:

Record Filter: (Transaction dates between 10/01/2010 and 10/29/2010) and
(Type exactly matches Manual Check or Computer Check)

Output Fields: Transaction Date, Reference, Vendor Name, Transaction Amount, Transaction Type, Transaction Description

Order by: Transaction Date, Reference

When multiple invoices are paid to the same vendor, on this report the Transaction Description is one of the invoice descriptions.

Thanks.

The only thing I see that may be happening is that the date is too restrictive. Unless all the checks are entered within that date range, and posted within that date range, there may be some problem.

Try expanding the date range back to your current working month (if it is not Oct), and to include all the check dates.