DupliciteRecords

  • Thread starter Thread starter MIke_Mc
  • Start date Start date
M

MIke_Mc

Having problem in creating a report that would show the PO detail such as
item nbr, item desc, qty received, unit cost from the Purchase order file and
from payment file the invoice nbr, invoice amt, cheque nbr and date.

PO Line and Payment file match is on Invoice nbr. But because the invoice
nbr is not unique in Payment file, My Po Line detail records get duplicate.

My boss has requested me to show the item detail and invoice enteries on the
same sheet.

so. if 4 items were purchased, my reports should list 4 items on the and
than show a total for the invoice amount. then would list the invoice nbr(s)
- (for split payment) and cheque nbr(s) under the invoice amount files.

The problem I having is when ever I have a plit payment my po detail would
get deplicated. What should I go to get rid of the duplciate records on my
reports
 
Hello, I am able to create the report, using a sub-report option. Where I
created to seperate queries/report. for each po detail and payment detail.
Than created a third report linking both report using the inv nbr field, in
detail I showed the item infor and in the inv footer I am showing the payment
info.

It is working for me, but if there is a better process that I would follow ,
Please advise.
 
Back
Top