cancel
Showing results for 
Search instead for 
Did you mean: 

Display Text Line AR Invoice C.R.

Former Member
0 Kudos
349

Hi Experts,

we are migrating our templates from PLD to C.R.

The only problem is how to display text lines and subtotals in the final layout. In PLD was quite straight - forward, while in CR seems quite complicated.

How is it possible to join correctly INV10 on INV1 to display in the correct order all the extra lines?

Any idea about it?

Thank you very much

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

There is a visorder field in the lines table to help to get the lines in the right order

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks Julie

i am trying to use visorder, but it has the same number as linenum , so i am a bit confused on how to set up a correct query .

former_member206488
Active Contributor
0 Kudos

HI,

Vis order shows the correct order of lines and not same as line number.

for e.g if you have 4 lines on order and delete one of the line and update order,

check the visorder and line num fields, vis order- you can check difference.

Thanks,

Neetu

Former Member
0 Kudos

I have just had to create one with this option. I imported the SAP "Generic" layout package to see how they do it & they use a stored procedure - one of the SAP ones - to get it running. Would recommend you do have a look at these as they handle multi currency & lots of other stuff (except BOM display)