By using this website, you agree to our Terms of Use (click here)
I've made an inquiry that compares our POs to our Invoices. I linked the POOrder field with the APInvoices tables through the OrderNbr and DocDesc classes respectively. This works well since every PO that gets entered as an AP receives the order number as its description. However, this does not allow the inquiry to call any credit memos that contain the PO order number but also contains more description. I tried relating the two tables through a DocDesc contains OrderNbr, but this still does not include the credit memos and makes the inquiry load slowly. Any advice on how to make this work?
I believe the link that you are looking for is automatically stored on the AP Bill line for you.
If you join from APTran to POOrder on APTran.POOrderType=POOrder.OrderType and APTran.PONbr=POOrder.OrderNbr, I think that will get you what you are looking for.
Then of course you can join from APTran to APInvoice on APTran.TranType=APInvoice.DocType and APTran.RefNbr=APInvoice.RefNbr.
Or from APTran to APRegister on APTran.TranType=APRegister.DocType and APTran.RefNbr=APRegister.RefNbr.