Hi
I've got a simple SQL query the shows details of invoice payments from APOBL but I'm struggling to join details of the customer or the actual order/invoice they have paid up.
Is anyone able to help me please?
Cheers
Andy
Hi
I've got a simple SQL query the shows details of invoice payments from APOBL but I'm struggling to join details of the customer or the actual order/invoice they have paid up.
Is anyone able to help me please?
Cheers
Andy
Sorry, there is no link between AP and OE.
Thanks for speedy reply... So how do you know who paid an invoice and which one?
Sorry, I'm new to Sage 300
OE goes to AR, not AP. Look at AROBL and AROBP.
<Face Palm>
Of course, Accounts Received!! Doh.
I've re-written the query with the new tables and now it seems to make a bit more sense...
Thank you!
<Face Palm>
Of course, Accounts Received!! Doh.
I've re-written the query with the new tables and now it seems to make a bit more sense...
Thank you!
*Community Hub is the new name for Sage City