Welcome, Guest. Please Login.
05/12/25 at 16:10:33
News:
Home Help Search Login


Pages: 1
Send Topic Print
RNI - Cross Ref w/Invoices (Read 1078 times)
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
RNI - Cross Ref w/Invoices
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?
Back to top
 
 
Email   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: RNI - Cross Ref w/Invoices
Reply #1 - 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.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
Re: RNI - Cross Ref w/Invoices
Reply #2 - 09/09/03 at 07:24:24
 
So, no.  I have no way in DBA to see what POs go with what invoices?
 
 cry
Back to top
 
 
Email   IP Logged
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
Re: RNI - Cross Ref w/Invoices
Reply #3 - 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.
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: RNI - Cross Ref w/Invoices
Reply #4 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
Re: RNI - Cross Ref w/Invoices
Reply #5 - 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?
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: RNI - Cross Ref w/Invoices
Reply #6 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print