I'm a .NET developer and am largely a novice with the GP table structures, so hopefully this makes sense..
All of our invoices are processed through the Bank Rec tables - specifically CM20202. Payments are batched into that table and then an external, third-party application reads and processes the records for payment. I have another application - an app that I'm writing - that needs to pull the record of some of those payments, tie them back to their corresponding Purchase Order, and send that information to another third-party site.
So as that third-party application processes transactions, I would like to read something from that CM20202 record - probably DOCNUMBR, since it appears to be unique - and work backwards. I believe the data I need for the Purchase Order lines is stored in POP10500, and I believe it contains the line items and receipts for each transaction processed against a PO.
What I need to know is this...is there a way to build a join back from CM20202 to POP10500?
If this doesn't make sense, ask a question and I'll try to clarify. I'm as much trying to understand how stuff works as solve my problem.
Thanks in advance!!
Joel