on 11-15-2007 12:20 PM
Hi all,
Is there an option in PLD to determine the company logo on the layout of an Invoice based on the selected item? For instance to set a UDF (True or False) on the item, when selected in a sales document to determine which company logo is selected on the printout.
Here is the contents of the thread
I would like to change a logo (picture) on a form based on the value in another field. Any help would be appreciated. The general idea would be something like this:
if (Field_xxx > 59) {
use picture 1
} else {
use picture 2
}
Also, any documentation on the layout designer and/or XL Reporter would be great. Thanks in advance.
Daan Posthumus
Posts: 112
Questions: 7
Registered: 6/8/07
Forum points: 216
Re: Print Layout Designer ?
Posted: Nov 1, 2007 4:36 PM in response to: Sam Grady Reply E-mail this post
I gave a solution to a similar issue and I quote it here for you:
Say for eg. your wh codes are 01, 02 and wh names are 'Sales', 'Showroom'. You will need text fields for each wh code and for each wh name 01, 02. and 'Sales', 'Showroom'.
Now a formula for each occurance - Lets assume your fields have the following unique ID's:
The existing variable displaying the wh code = F_01
Your 01 text field = F_02
Your 02 text field = F_03
Your 'Sales' Text field = F_04
Your 'Showroom text field = F_05
Your formula's will be - F_01==F_02 and F_01==F_03
Now link the text fields containing the wh names to the formulas (Field properties - general tab) - eg. link F_04 to the first formula. Make the formulas not visible.
Now the wh name should display according to the wh code.
For your situation you will use the company name instead of wh code.
Let me know if you need more help
Regards
Daan
jimmy michael
Posts: 1,087
Questions: 60
Registered: 3/8/07
Forum points: 1,526
Re: Print Layout Designer ?
Posted: Nov 1, 2007 6:07 PM in response to: Sam Grady Reply E-mail this post
For your second query, come and join this mailist :
http://groups.yahoo.com/group/SBO_Knowledge_Village
SBO_Knowledge_Village-subscribe@yahoogroups.com
for more easy SAP B1 documentation exchange and help another among mailist members.
Rgds,
Adrian Johnson
Posts: 32
Questions: 0
Registered: 9/19/07
Forum points: 92
Re: Print Layout Designer ?
Posted: Nov 1, 2007 6:40 PM in response to: Sam Grady Reply E-mail this post
Sam,
Easiest option is to add two formula fields to the layout (hide them)
Field_xxx > 59
Field_xxx <= 59
Add two picture fields.
Use the Link To field on the properties form, general tab. Link one picture to the first formula field and the second one to the other formula field.
Regards,
Adrian
DAAN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
If you search the forum by typing <b>Print Layout Designer ?</b> you will find a thread that dealt with this issue.
That should give you a good idea of how to proceed with the layout
Regards
Daan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.