Skip to Content
0
Apr 25, 2017 at 08:35 PM

SQL query to link OPOR (a/p purchase order) and ODPO (a/p down payment) in SAP B1

1348 Views

I can usually tease these out, but I'm having a hard time linking these two tables. What I ultimately need is PO info with the paidtodate from the a/p down payment invoice. I started to just go with Journal Entries, but was still having issues getting back to the PO.