Invoice -add data from contract

[Former Member]

Hi,

I would like to add details to invoice script from conditions in contract, details that didn't appear in standard invoice, details like commons, calculate object est.

I didn't found connection between tables VIRAINVITEM- RE Invoice Item and VICDCOND-conditions.

Can anybody help me?

Thanks

Ifat

[Former Member]

Hello Christian,

Thank you for your answer, I almost gave up.

I saw you answer but something is missing:

1. Why table VIRADOC is necessary it's not connecting to other table?

2. Between VIRAINVITEM and VIRADOCITEM the connection is 1 to many,

I need 1 to 1 relationship between lines in invoice and table VICDCOND.

Maybe there is another why to bring data to invoice, data from adjustments and conditions comments.

I would like to attach file with the draw of tables and connections, but didn't found this option in the forum.

I hope that you will understand my questions.

Thank you

Ifat

[CPalzenberger]

Hello Ifat,

please have a look at this thread:

It already contains some helpful hints on how to achieve a concrete link between these two tables.

Hope this helps.

Regards,

Christian