Sales Order Items Matrix and RDR1 table

[Former Member]

Hi,

I have to change values of some columns in SO item matrix.

For e.g, I need to change the 'order quantity' of a particular SO row.

Is there any mapping between RDR1 table, and the matrix row#?

i.e, if I want to change linenum= 3 and Vis_Row = 3 of a RDR1 row, how can I find out which row# in matrix I have to change?

Generally matrix row# is RDR1.Vis_Row+1, but not always.

The exceptions will be: If there is a text comment in SO, or the lines are deleted,...

Please let me know how I can achieve the mapping.

(I dont want to search in all of the matrix lines for a RDR1 match.)

Thanks in advance.

Regards,

Geetha

[Former Member · Accepted solution]

try this select

select row_number() over(order by t.visorder, t.itemcode desc), * from
(
select r.itemcode, r.dscription, r.visorder, r.linenum from ordr o, rdr1 r where o.docentry = r.docentry and o.docentry = 83
union all
select '', linetext, aftlinenum, lineseq from rdr10 where docentry = 83
) t order by t.visorder, t.itemcode desc

[Former Member]

Hi Petr!

It works so nicely, thank you so much.

(I'm changing your points to 'Solved the problem')

Regards,

Geetha

[Former Member]

Thanks a lot, Petr.

I will try it out.

[Former Member]

I have a similar problem, i want fill the good receipt form with some hard coded string, do you have a short exemple for assigning hard coded string to a system form please?