Printing a (changed) order

Lars Pelzer

Is it possible in Coresuite Designer to do the print changes made in a Sales Order in red?

Process:

1). Create Sales Order with a few items
2). Print Sales Order (Layout Designer>Choose Document Type: Order(picking))
3). Amend the Sales Order and add a new row with an item
4.) Print Sales Order with original items in black and the new information in red

Thanks in advance,
Lars

Philipp Knecht

Hi Lars

Assuming that you have an UDF on the row (RDR1) like:

LineNum | U_Section
0 0
1 0
2 0
3 1 <-- Here starts the second batch
4 1

Then you could define Styles named Section1 - SectionXX (Depending on the max of batches you have).

Then you yould assign the Stylename in the bindings like : "Section" & DocumentRow("U_Section") for every textBox in the Detail.

hth

Lars Pelzer

Is it also possible without an UDF?

Philipp Knecht

Hi Lars

I don't think so.

But even better (with UDF) . You can set the PrintDate in an UDF PrintDate on the rows after printing and then do the coloring according the date.

Let me know if this solution is suitable. We can offer you a remote support (~ 1 hour)

hth

Lars Pelzer

Hi Philipp,

I have followed your instructions, I have made a query that linked to the UDF-field (U_Section).


[quote]"Philipp"]
Hi Lars

Assuming that you have an UDF on the row (RDR1) like:

LineNum | U_Section
0 0
1 0
2 0
3 1 <-- Here starts the second batch
4 1

Then you could define Styles named Section1 - SectionXX (Depending on the max of batches you have).

Then you yould assign the Stylename in the bindings like : "Section" & DocumentRow("U_Section") for every textBox in the Detail.

hth
[/quote]


Query:
SELECT (CASE WHEN T0.Printed = 'N' THEN '0' ELSE '1' END) FROM ORDR T0 WHERE T0.DocNum = $[ORDR.DocNum]

Then in the Layouts Designer i have put for every field in the Detail:
"Section" & DocumentRow("U_Section")

So when the field has the value is 1 then it's will be filled with RED.
"RED" & DocumentRow("U_Section") = "1".

Can you tell me why this doesn't work?

Thanks in advance!


Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/descecrator/scr1.JPG]scr1.JPG[/url]

Philipp Knecht

Hi Lars

I don't think this Query will work but this is another issue...
Did you declare the Styles Red1 - Red10 in the Stylesheet Editor?

Then you have to bind: "Red" & DocumentRow("U_Section")
to the StyleName Property.

hth