how can we show one form values into another form

Solution (Verified) This post has 1 verified solution | 3,260 Views | 17 Replies | 1 Follower

95 Posts
648 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA
pressi posted on 2012-12-4 11:03 rated by 0 users

hi every one,

i have two forms like accountability and approval form.while iam entering the data into accountability form when i click submit function it will goes to the approval form..but i have 3 field ref no,quater,and description..these fields does not existing data.

i set the table relation for the forms even though the values are not getting..plz give me reply 

Solution (Verified) Verified Solution

5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-5 7:41
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV
Verified by pressi

Yhen you need to add code to assign new field values also..

  • | Post Points: 106

All Replies

5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-5 7:41
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV

What are the tables behind those forms?

Are they same or different?

If different, How are you inserting data from accountability table to approval table?

using TRANSFERFIELDS and assigning via code?

  • | Post Points: 6
95 Posts
648 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA

Different tables like accountability has general line table and approval has approval line table..but some common fields is present inthat form..some fields like line no,document no,amount values are inserting while clicking submit into accountbaility form..Remaining rf no,ref decsription,quater does not have values.

in the function button i can use this transfer code??

  • | Post Points: 6
5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-5 7:41
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV

If some fields are flowing means there must be code written with TRANSFERFIELDS or assigning..

Please check what code is written..

If transferfields is used then you must have same field ID and data type in both tables..

  • | Post Points: 6
95 Posts
648 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA

ya the 2 fields has same id in the two tables..i added one field in the approval line table so can i add in the field in the gen.journal table.where can i write the codein that field validate trigger??

can u suggest me that code

 

  • | Post Points: 6
5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-5 7:41
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV

Check the code under submit button first.

How the field values are flowing to approval table..

  • | Post Points: 6
95 Posts
648 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA

it has one codeunit like workflowmanagement in that insertapprovingline function is there in that fileds are assigning .when we r submitting it will go to linedistribution buffer.

  • | Post Points: 6
5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-5 7:41
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV
Verified by pressi

Yhen you need to add code to assign new field values also..

  • | Post Points: 106
95 Posts
648 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA

k thank u

  • | Post Points: 5
95 Posts
648 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA

hi mohana i added the field in codeunit..2 fields are flowing into other form..one field was not flowing..that field is option field..i added this field in temporary table..how i can write code for option string??

..i wrote for the two fields like this


  TempLineDistBuffer."Receipt Ref. No." := GenJnlLine."Receipt Ref. No.";
  TempLineDistBuffer."Receipt Description" := GenJnlLine."Receipt Description";
  TempLineDistBuffer.Quater := GenJnlLine.Quater;//this one was not gng to another form..plz suggest me

5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-5 7:41
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV
Suggested by Mohana

I think values from TempLineDistBuffer table will be inserting into final table..so please check that place also..

  • | Post Points: 6
95 Posts
648 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA

I checked that one also..but  this option string field is not effecting.

5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-5 7:41
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV

Try to print the value in above code using

Message('%1',GenJnlLine.Quater)

check what is the result..

  • | Post Points: 6
95 Posts
648 Points
Joined: 2012-11-8
Last Online:
2013-2-27 14:09
Location: INDIA

Only displaying what i selected in the option filed..it does not affecting on the other form

  • | Post Points: 6
5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-5 7:41
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV
Suggested by Mohana

Did you check also in TempLineDistBuffer.Quater field..after assigning the values.

Are you sure you have added the code in assigning values frpm TempLineDistBuffer.Quater  table to end table?

  • | Post Points: 7
Page 1 of 2 (18 items) 1 2 Next > | Get this RSS feed