ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> General DBA Topics >> LINKING PO & INVOICE
http://www.istechforum.com/YaBB.pl?num=1302208507

Message started by carolg on 04/07/11 at 13:35:07

Title: LINKING PO & INVOICE
Post by carolg on 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.

Title: Re: LINKING PO & INVOICE
Post by Lynn_Pantic on 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.

Title: Re: LINKING PO & INVOICE
Post by carolg on 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.

Title: Re: LINKING PO & INVOICE
Post by Lynn_Pantic on 04/08/11 at 07:34:59

INVTXN is the Inventory transaction file.

Title: Re: LINKING PO & INVOICE
Post by carolg on 04/08/11 at 08:05:33

Thank you