Invoice VS Receipt Difference

[iwells]

Hi,

I'm wondering if someone can help me out ... I'm working on a report and I'm trying to find a table in the Accpac database that would indicate the differences between what unit costs/exchanges rates/quantity were receipted as compared to what was invoiced.

I've looked in the PO module and I don't see anything obvious and I'm currently digging through AP, but I'm not having much luck.

Thanks!

 

[ettienne]

PO receipt tables (PORCPL) and PO invoice tables (POINVL).

 

[iwells]

So there's no detail table that stores the difference between those tables? In other systems I've seen with similar types of transactions there detail tables that provide the source documents (receipt/invoice) with columns for the original and modified value. I can go directly to the original values and compare if necessary but made an assumption ...

 

[ettienne]

IDK, try POINVL....