Hello, I would like to use the drill down functionnality to record changes to à history table. This seems to be possible - the budget module seems to do this (entering à new budget value => record to budget ledger of changes) - but I don’t understand how it works ! details : this should manage reevaluations in a very simple way : a form on item ledger with a specific flowfield called Reevaluation Amount. the flowfield is the sum of aan amount field in a new table. when entering a value in the flowfield, it records it in the new table but I need to get there the item ledger entry n° too !
quote:
when entering a value in the flowfield
It is not posible to do so ! What looks like this is a trick ! - It is a normal field - It Has the Propertie DrillDownButton - It Has some code in the OnDrillDown-trigger
thank you for your answer - but i think i was not very clear so - one time again : when i said : “the flowfield is the sum of aan amount field in a new table. when entering a value in the flowfield, it records it in the new table but I need to get there the item ledger entry n° too …” its what i GET as result. it IS a flow field ! I hope you see what I mean. Proceding in this way works - but there is only the probleme of getting the item ledger entry n° in my record. But perhaps THIS is not possible - this is why I am asking… If this is not possible - what alternative solutions ?
Hi Trennert, I’m a bit confused as to what your exact problem is. If your new flowfield “Reevaluation Amount” is placed directly on the “Item Ledger Entry” record I don’t see how you can avoid getting the “Item Ledger Entry No.” in the records of your new table, since this field implicitly must be the very basis of your drilldown filter. Provided the CalcFormula of your flowfield looks something like this: Sum(MyTable.Amount WHERE (Item Ledger Entry No.=FIELD(Entry No.))) the field “Item Ledger Entry No.” in your table will be populated automatically. If your setup looks differently, I’m sure you can obtain the “Item Ledger Entry No.” on the OnIsert() trigger of your new table. And, jammicky, it’s not a trick, it’s not code on the OnDrillDown-trigger, it’s how Navision works if you make a flowfield editable! — Additional info ------- If you’re problems stems from entering records directly in the drilldown form of your new table you might want to check out the properties PopulateAllFields and DelayedInsert of said form. Alternatively add code to the OnNewRecord trigger.
quote:
And, jammicky, it’s not a trick, it’s not code on the OnDrillDown-trigger, it’s how Navision works if you make a flowfield editable!
But only if the transaction table has a primary key that consist of an integer. Otherwise Navision wont create and records. When Navision creates these records the field that the FlowField calculates is validated, so You can put code in the transaction table that runs when You enter data in the flowfield. Look in Job Budget Entry. There You find code in the amount field.
That’s correct and I’m sure you mean the Quantity field [;)]
Thank’s. That’s correct
quote:
And, jammicky, it’s not a trick, it’s not code on the OnDrillDown-trigger, it’s how Navision works if you make a flowfield editable!
NICE ! Never heard of this !
Hello sv, It works now ! Thank you for the hint for the form properties (PopulateAllFields and DelayedInsert) I had another problem because I used an existing form with controling code on the OnModify-Trigger… Bye