cancel
Showing results for 
Search instead for 
Did you mean: 

CrystalReports - Get value of DownPayment into Invoice form

former_member267979
Participant
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

msundararaja_perumal
Active Contributor
0 Kudos

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.

former_member267979
Participant
0 Kudos

Thanks for the information.

Now I am trying get the value of TAX from the DownPayment also from OINV but unfortunately is not there:

SELECT DpmAppVat FROM OINV WHERE DocNum=11616

returns 0.000000

will I need joint ODPI ? Or do I make something wrongly?

msundararaja_perumal
Active Contributor
0 Kudos

They are also available in DpmVat for local currency and DpmVatFc for foreign currency respectively.

I suggest you give a detailed review on the DB reference from SDK Help.

Answers (1)

Answers (1)

former_member390407
Contributor
0 Kudos

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.

former_member267979
Participant
0 Kudos

I found it!

actually is enough bring from OINV column DpmAmnt


Thank You

Abdul
Active Contributor
0 Kudos

Please close the thread