Welcome, Guest. Please Login.
05/12/24 at 13:15:59
News:
Home Help Search Login


Pages: 1
Send Topic Print
LINKING PO & INVOICE (Read 1075 times)
carolg
Full Member
***


I Love EvoERP!

Posts: 169
Gender: female
LINKING PO & INVOICE
04/07/11 at 13:35:07
 
We are trying to produce a report showing price difference between original PO and final invoice.  So we are trying to link the PO line items to Invoice line items.  Which file names should we be using? We can't find a good link.
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: LINKING PO & INVOICE
Reply #1 - 04/07/11 at 17:48:23
 
That won't work because when the invoice is entered at a different price the PO line price is updated.  Use IN-E or IN-O for type "C" transactions.
Back to top
 
 

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


I Love EvoERP!

Posts: 169
Gender: female
Re: LINKING PO & INVOICE
Reply #2 - 04/08/11 at 06:53:03
 
OK - I thought so.  That the PO changes once the invoice is posted.  IN-O produces too many lines of information to export to excel or use Crystal. But I can use IN-N-A to get price changes, but it is based on total quantities.    IN-N-A report shows the total parts of a transaction (ie: 30)  and the total price difference for that transaction(ie: 30*1=30).  I want the price change of the qty of 1 part, (ie: $1)  not 30.  So I figured if I put that information into a Crystal Report then I could manipulate the data to show me the price difference individually. So I am looking for where the file names would be located for the IN-O or IN-N-A, specifically the C Transaction Type field.
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: LINKING PO & INVOICE
Reply #3 - 04/08/11 at 07:34:59
 
INVTXN is the Inventory transaction file.
Back to top
 
 

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


I Love EvoERP!

Posts: 169
Gender: female
Re: LINKING PO & INVOICE
Reply #4 - 04/08/11 at 08:05:33
 
Thank you
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print