ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> RNI - Cross Ref w/Invoices
http://www.istechforum.com/YaBB.pl?num=1063111864

Message started by kerric on 09/09/03 at 06:51:04

Title: RNI - Cross Ref w/Invoices
Post by kerric on 09/09/03 at 06:51:04

Is there a way to tell what invoice is related to what PO, via any DBA Report? Either in the MFG module or Accounting?

I have some challenges clearing up some funky PO receipts, and it seems very difficult to cross reference POs to invoices.

If not, what is a good method to reconcile these?

Title: Re: RNI - Cross Ref w/Invoices
Post by aricon on 09/09/03 at 07:15:48

We started to create this in MS Access for one client, before they dropped DBA. If anyone is interested, we could complete this for them.

We use Access because many people have it (you get it with MS Office Pro), so there is very little cost to it, and with the Visual Basic code that we put in, it runs very fast and allows a GREAT deal of flexability.

Title: Re: RNI - Cross Ref w/Invoices
Post by kerric on 09/09/03 at 07:24:24

So, no. I have no way in DBA to see what POs go with what invoices?

:'(

Title: Re: RNI - Cross Ref w/Invoices
Post by kerric on 09/09/03 at 07:49:00

Ok, so now that I have cried about it....

What is the best way to find which PO Invoice matches a Receipt? They still have to be reconciled.

Title: Re: RNI - Cross Ref w/Invoices
Post by Lynn_Pantic on 09/09/03 at 08:10:16

Actually, there is an AP Inquiry program available from IS Tech Support that links PO detail with invoices and checks. A demo is included in themost recent update.

Title: Re: RNI - Cross Ref w/Invoices
Post by kerric on 09/09/03 at 08:21:06

My question is: since I do not have this available update, how do I research the history on the incorrect RNI items now?

Title: Re: RNI - Cross Ref w/Invoices
Post by Lynn_Pantic on 09/09/03 at 15:34:10

If you have version 2002.1 or later, the only thing I can suggest is Maintain Database on teh BKAPHPOL file. Each PO Line item has a place for the Invoice number to be stored when it is entered in AP-C.