If we want to get the value of balance filed of perticular vendor from vendor table in new table
how can we get that value?
When I try it shows me error " balance must be in primary key in vendor table" but balance is the flow field and flow filed will not become a primary key.
0
Answers
http://ssdynamics.co.in
I just want to get the value of Amount field in the new table for specific vendor.
It show me error
"The field below must be included i tables primary key"
Field :- amount
Table :- Vendor ledger entry
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
You need to use Detailed Vendor Ledger Entry.
Kine Wrote I tried to define a flow field in Purchase Header table with relation to "Buy from Vendor No." field by using the detailed vend ledger entry table and it worked. Why to write the C/AL code :-k
http://ssdynamics.co.in
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I create a new table having fileds vendor no. and balance
Now what I want, when I insert vendor no. in first field it will takes a balance/amount of that vendor automatically in 2nd field.
Please tell me what can I do?
http://ssdynamics.co.in
Sorry but I am not able to solve the problem
Field Class : FlowField
CalcFormula : Sum("Detailed Vendor Ledg. Entry".Amount WHERE (Vendor No.=FIELD(Customized Table vendor field)))
I hope this will solve the problem.
http://ssdynamics.co.in
This solution solved my problem \:D/ :P :whistle: