Matching Part Numbers to Invoices

[cfcanter]

I am using Crystal reports against MAS 200.

I need to extract the last invoice for each item purchased. I am willing to download into excel and sort to determine the latest invoice. The problem I am having is that I don't understand what tables to link the AP_History table to in order to extract the item number.

Please: What table(s) do I use and what are the linking fields so I may extract last invoice for each part?


Thank you!

Craig Canter
Controller
Elgin IL

 

[adamroof]

in Mas90 its the CI_Item table and IM_InventoryMasterfile for the AR module, maybe the CI stores the same for AP?

CI_Item.ItemCode = AP_History.ItemCode ?

we dont really use the AP module, so dont know 100%.

 

[cfcanter]

Sorry, that doesn't work. I need to tie from the invoice back to the item that the invoice is paying.

Craig Canter
Controller
Elgin IL

 

[BigLouie]

Use AP_13, group on Item, do a subtotal on the invoice number looking for the MAX and that should do it.