on 07-20-2018 12:23 PM
Hello,
I have a form based on SELECT FROM OINV
I would like to put there also information about Down Payment what is actually in ODPI column DocTotal.
Do anybody has idea how to join it?
Hi Zdenek,
Unless you need to have fetch the details of more than one downpayment invoices, you don't have to join the ODPI table.
The downpayment amount is already stored in the OINV table, the field is OINV.DpmAmnt for local currency and OINV.DpmAmntFC for foreign currency.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Zdenek,
You can either change your SQL command and add there a join with ODPI table or add another command based on ODPI and join them via CR.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.