Hi Dave, there are a large number of tables you need to be aware of. The core tables are as follows:
Transactions >> Purchasing >> Purchase Order Entry
POP10100 is the Purchase Order Work Header table. This contains the PO Number, date, creditor ID etc. For PO Line information you will need the POP10110 - this is linked to the POP10100 table by the PONUMBER field.All Purchase Orders ever entered are stored in these tables above. The POSTATUS field value changes as the PO is processed - for example a status of '4' indicates that it has been received.
Transactions >> Purchasing >> Receivings Transaction Entry (Eithre a shipment or shipment/invoice)
Work (ie unposted) Receipts are stored in the POP10300 (Header) and POP10310 (Lines).When they are posted they are moved to POP30300 and POP30310 (and when you post a receipt it also updates the POSTATUS in POP10100 above (to be '4')).
Transactions >> Purchasing >> Enter / Match Invoices
When you enter and save a purchase invoice (and match it to a PO) - this is also stored in the POP10300 / POP10310 combination. When you post the purchase invoice it gets moved to the POP30300 / POP30310 combination. At the same time, and entry is created in PM20000 table for this invoice.
Transactions >> Purchasing >> Transaction Entry / Manual Payments etc.
Work (ie unposted) transactions are stored in PM10000. When they are posted they are transferred to PM20000.
Therefore PM20000 contains all Creditor documents whether they are PM Documents (Invoices, credit notes, payments etc) or POP Invoices/returns.
When transactions in the PM20000 table are fully applied, they are automatically transferred to history and are moved to the PM30200 table (Paid Transaction History table).
Depending on where you need to intervene to get your data will decide which tables you look at. One bit of advice would be to only deal with the Open and History tables - since Work transactions can be deleted by users.
Best regards, Ian.
*** Note - just saw Bron's post. This is correct. The above are the main transaction tables - there are a lot more for Tax etc. The best thing you could do (if you don't know the table structures and don't have a decent partner who can help) is start by creating some queries using the tables above untill your queries return the exact data you are looking for.
