Journal Voucher Printout - Project Code and Dist. Rule

[former_member277944]

Hello Experts,

I need to have a Project Code and Distribution rule (which is being entered in Journal Voucher entry) on Journal voucher print layout.

I used Database fields with BTF1.Project and BTF1.ProfitCode, but it diaplays the first Project code for all the vouchers and all rows in all Printouts instead of displaying specific Project Codes and Profit Centers.

Can somebody please help.

Thanks & Regards,

[former_member184718]

Hi Shazad,

If you want to display specific Project codes and Profit centres, then do the followings:

1. In the Journal voucher Print Layout, create two text fields for Project code and Profit centre

2. Add the project code and profit centre name in the text fields

3. Create two formula fields and in the content tab of each formula field, check for the equality of project code text field with actual project code value and do the same for profit centre

4. Now link formula field which test for project code equality with BTF1.Project and link formula field which test for ProfitCenter with BTF1.ProfitCode

I hope this helps you.

Regards,

Hari

[former_member277944]

Thanks for reply, I could not understand point number 3.

[former_member184718]

Hi,

I have explained in detail below:

1. In the Journal voucher Print Layout, create two text fields for Project code and Profit centre

          Proj Code                                   Profit Center

     Field Name: F_130             Field Name: F_131   

     Field Type: Text                    Field Type: Text

     Visible: False                        Visible: False

2. Add the project code and profit centre name in the text fields

        Proj Code                                   Profit Center

     Field Name: F_130             Field Name: F_131  

     Field Content: A                    Field Content: B

3. Create two formula fields and in the content tab of each formula field, check for the equality of project code text field with actual project code value and do the same for profit centre

     Proj Code                                   Profit Center

     Field Name: F_132                  Field Name: F_133

     Field Type: Formula                 Field Type: Formula

     Field Content: F_130=="A"     Field Content: F_131=="B"

     Visible: False                            Visible: False

4. Now link formula field which test for project code equality with BTF1.Project and link formula field which test for ProfitCenter with BTF1.ProfitCode

Field: BTF1.Project                    Field: BTF1.ProfitCode

Link To: F_132                          Link To: F_133

For your case, you replace the value "A" in the content of field F_130 with your own Project Code and replace the value "B" in the content of field F_131 with your own Profit Center.

Also replace the values "A" and "B" in the formula fields, F_132 and F_133 with your own Project Code and Profit Center.

I hope now you are clear.

Thank you,

Hari

[former_member277944]

Thanks but in this way the values will hard coded, I need to run it according to the JV number, suppose I put a hard value of JV as 13. Now next time if I take the prinout of JV 15. it will give a problem.

Please comment.

Regards,

[former_member277944]

Kindly see the image below for JV PLD.

[former_member184718]

Hi Shazad,

You can replace the hard coded values with field names containing the JV value.

Thanks.

Hari

[former_member277944]

Thanks for reply Hari,

I have tried it with different options, it does not work rather showing wrong values of Project, in my case: I have just tried with Project Code first.

1. I have one formula field F_112 containg field F_106 (Project Code field) in formula area.

2. I have another formula field F_113 having containing formula: F_112==F_106.

3. Now in field F_106 I have selected field in "Link to Field": F_113.

Please guide ...

Thanks & Regards,

[Former Member]

Hi,

I had faced the same issue. Then i resolved by this way.....

1. Add the formula field Linenum() in repetitive area

2. Link Dist.rule field to this formula field .

3. Then make Linenum() field hide.

Try this........