Dear All,
I have a problem which i am still troubled by it. The problem goes like this: I have created a budgeted checkbox(boolean) which will be ticked if the purchase line being created is found in the G/L budget table.
I have implemented the logic and it worked, the issue now is : i need to click on the header in order for the checkbox to be ticked. I now need to configure in a way that when i create the purchase line, the checkbox will be ticked without user click on the purchase header.
I have also searched through mibuso forum on topic such as refresh form where suggestions such as using time interval property. However i have tried the suggestions given and it does not work out for me. I hope if anyone encounters similar problem like me and able to provide advices on it.
Appreciate to all who have read this post. Thanks
Best Regards
Answers
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
as far as my knowledge you should use flowfield for this boolean type field and use Exist function in CalcFormula property either you would have to add a field (type bool) in purchase line to update purc header.
http://lmsmfy.com/?q=Update%20Mainform%20from%20Subform
Follow the link and then take a look to the matches. I'm sure more then one has that what u need ;-)
Regards
To Vijay, thank for reply but however i still do not understand your explanation as i am still new to navision thus could you please explain in greater detail? thanks
To garak, thank for replying, i have followed ur link but i do not find the result that i want but thanks anyway
He means add a field to the Header "Budget Line Exists" or whatever name you like type Boolean
for the properties-> fieldclass = flowfield
calcformula would be something like
Exist("Purchase Line" WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.),YourCheckBoxField=FILTER(Yes)))
http://www.BiloBeauty.com
http://www.autismspeaks.org
Dear Savatage,
Thank you for your reply. I had tried the method that you further had explained from Vijay however i still need to click on the purchase header in order to update the boolean field.
Best Regard
Navkid
http://www.BiloBeauty.com
http://www.autismspeaks.org
My Blog - nav.education
Dear Savatage,
I have followed garak's post and look thru the posts,however most of the methods were suggesting about using time interval property and add "Currform.update" which will degrade the system performances. I have also tried out garak method on using Automation XML but it will not updated the option field in the purchase header.