Key Field in POP_RecptHistoryLine 1

[cfcanter]

We are running MAS 200.

I am trying to create a Received-Not-Invoiced report. If a canned report in MAS 200 exists, I doubt we can use it. Our predecessors were not very savvy in MAS and did more work arounds than anything. However, if you know of one I'll start there.

In Crystal Reports:
My objective is to compare receipts from the period 2/28/07 to 4/30/07 to invoices from the same period. Any receipt without an invoice will be considered "Received-Not-Invoiced". I want to extract receipts from the POP_RecptHistoryLine table and match them to the AP12_InvHistHeader via the PORecptNumber.

the problem I am having is it is taking 5+ hours to extract the data from the POP_RecptHistoryLine, even when I restrict the period to 2/28 to 4/30.

What is the key field to search on in POP_RecptHistoryLine?
Is there a better way to do what I am trying to do?

Thank you!

Craig Canter
Controller
Elgin IL

 

[BigLouie]

Why don't you just run the purchases clearing report. It will show amount received and amount invoiced?

Also you can do this all with a report based on just the POP and PO2. The POP is the receipt file and the PO2 is the line detail. Link on the purchase order number. You should be able to get what you want.

 

[cfcanter]

Hi Big Louie -

I'm sorry to ask again, but I'm not getting it. I'm getting two receipts: One appears to be the actual receipt and the other the receipt of the invoice. For example: PO GC18042 will have receipt G020971 and I017014. The kicker is that I017014 will appear for more than one PO. Is I017014 the batch the invoice was posted under? What am I missing here?

Craig Canter
Controller
Elgin IL

 

[BigLouie]

A "G" record is the receipt of goods record and the "I" record is the receipt of invoice record.