Label - SWA_LD_ItemLabel
Chi Fai Cheung
Hi Philippe,I try to use the layout 'SWA_LD_ItemLabel' in the 'Item Master Data' screen which should print the information of the item.
But i want also the 'Unit price' which the user select from the choicebox Price List, how can I do this?
Other question is, the item description in SBO is entered with small letters, but need to be shown in capitals on the Coresuite layout. How can i do this in the Layout Designer?
Thanks in advance,
Chi Fai
Philipp Knecht
Hi Chi FaiIn this case i would make a copy of SWA_LD_ItemLabel because:
- It's designed to be used in marketing doc Printorders
- It's datasource (The query) is fixed to marketing docs.
Don't forget to provide also your won query when you copy it.
hth
Chi Fai Cheung
[quote]"Philipp"]Hi Chi Fai
In this case i would make a copy of SWA_LD_ItemLabel because:
- It's designed to be used in marketing doc Printorders
- It's datasource (The query) is fixed to marketing docs.
Don't forget to provide also your won query when you copy it.
hth
[/quote]
Thanks Philipp, i already did it :).
Other question is the item descriptions in SBO is entered with small letters, but need to be shown in capitals. How can i do this in the Layout Designer?
I have also the following problems is that the customer want to print the label by selecting the items. The label is A4 with 20 labels in 1 page. Now i have create a layout label for 1 item.
How to create it with more then 1 label layout?
Thanks in advance,
Chi Fai
Philipp Knecht
Hi Chi Fai1. In the Expression write dataBand(xyz).ToUpper() to get the Uppercase characters.
2. You need a field or a entry parameter and then you need to extend your query like:
SELECT U_MyQuantity AS @@RepeatRow FROM ...
Or when using Entry Parameter:
SELECT [%LabelQty] AS @@RepeatRow FROM ...
hth
Chi Fai Cheung
[quote]"Philipp"]Hi Chi Fai
1. In the Expression write dataBand(xyz).ToUpper() to get the Uppercase characters.
2. You need a field or a entry parameter and then you need to extend your query like:
SELECT U_MyQuantity AS @@RepeatRow FROM ...
Or when using Entry Parameter:
SELECT [%LabelQty] AS @@RepeatRow FROM ...
hth
[/quote]
Thanks Philipp,
I can't find the 'Expression'-field can you tell me where i have to put in?
Thanks
Philipp Knecht
Hi Chi FaiIf it is not in the bindings (Value Property) youll find a similar expresiion in the GenerateScript.
hth
Chi Fai Cheung
[quote]"Philipp"]Hi Chi Fai
2. You need a field or a entry parameter and then you need to extend your query like:
SELECT U_MyQuantity AS @@RepeatRow FROM ...
Or when using Entry Parameter:
SELECT [%LabelQty] AS @@RepeatRow FROM ...
hth
[/quote]
Hi Philipp,
I still don't understand how to do this, what i have is the following
i have a query and 4 different layouts:
The query:
SELECT T0.[ItemCode], T0.[ItemName], T1.[Price], *
FROM OITM T0 INNER JOIN ITM1 T1 ON T0.ItemCode = T1.ItemCode INNER JOIN OPLN T2 ON T1.PriceList = T2.ListNum
WHERE T0.ItemCode = '[%ItemCode]'
1 parameter for the ItemCode in table OITM
The labels defined in the layout need to be printed on a labelsheet (20 stickers per labelsheet, 2x10). How can I ensure that the single item-label layout is printed multiple times on the labelsheet?
Thanks in advance, Chi Fai
Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/vicichief/scr4.JPG]scr4.JPG[/url]
Philipp Knecht
Hi Chi FaiIt will be best if we solve this via remote support.
Let me know when i can open up an service ticket (121 EUR / hr).
I think one hour should be enough.
Optionally you can buy support packages via our homepage http://www.coresuite.com
hth
Chi Fai Cheung
[quote]"Philipp"]Hi Chi Fai
It will be best if we solve this via remote support.
Let me know when i can open up an service ticket (121 EUR / hr).
I think one hour should be enough.
Optionally you can buy support packages via our homepage http://www.coresuite.com
hth
[/quote]
Thanks.:(
0
Please sign in to leave a comment.
Comments
0 comments