on 10-06-2008 10:55 AM
Hi Experts,
I have a PO with several lines which consist of item type and text type. I want the text type to appear in the print layout just like a normal line item, but I do not know how to do it. Usually, the item type field blocks the text type field and produces no data.
I'm using 2005 sp01 pl45. Any help will be rewarded.
Thanks.
Don
Rogelio,
All you need to do is to use the link option: link the 'normal' fields to a formula saying the line is regular, the 'text' field to a formula saying the line is 'text'.
1. Create a Variable type field for the line type:
Field_xx1: variable 157
2. Create a Formula field for the text type field:
Field_xx2: Field_xx1=='T'
3. Create a Formula field for the non-text type fields:
Field_xx3: Field_xx1!='T'
4. Now link all your non-text fields to Field_xx3 using the 'Link To' option in the field Properties, General tab and link the text field to Field_xx2.
You can position the text and non-text fields on top of each other as with the linking only the proper one will be displayed in each line.
Hope it makes sense.
Regards,
Nat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rogelio,
To find out what's wrong please make your repetitive area high enough, make the formula fields visible and position them to be seen if printing. If you print preview the document this way you will see if there is a problem with the formulas and if this is the reason it doesn't work.
The formulas should display value '1' if they are 'true' and should be empty if they are 'not true'. So the formula for the regular line must show 1 in the regular line and must be empty in the text line and vica versa.
When looking into this kind of problem it usually helps to use different colours for the different formula fields so on the print preview it is easy to see if a field is there but empty or if it's not there at all.
Please let me know if it solves the issue.
Regards,
Nat
Hi
Open the Item master Record which you want to add text in PO repetitive area. Goto that Item Master record remarks add the text what you want to print.
Now Goto PLD,
create a Database field and choose A/R- invoice- Rows(INV1) Table
then choose Text in column.
Hope this will Solve your issue
By
Kalai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.