Option Dr/Cr in customer card

"Debit Amount" and "Credit Amount" are calculated fields (FlowFields), you cannot update other fields based on their value, because the value is calculated "On Flight".

firstly u have to usee the calcfield function bcoz credit amount and debit amount r the flow fields

vyanku wrote:

I create field Dr/Cr type option,optionstring DR,CR
and write a code on ON validate DR/CR

IF "Debit Amount" > "Credit Amount" THEN
"Dr./Cr." := "Dr./Cr." ::DR
ELSE
"Dr./Cr." := "Dr./Cr." ::CR;

But I will not updated automatically in the card. If i update it from backend then it will reflect in the card.
What can I do ??

Hi Vyanku,

In Navision, often when you try to do something, its best to take a step back, and say "what do I want to achieve" NOT "how do I want to do it".

Reading between the lines, it looks as though what you really want is a field on the Customer card that shows if the customer is in Debit or in Credit. Also maybe you are trying to update this into an actual field in the customer Table (assuming "Dr./Cr." is an option field and not a variable.

This can beter be done by just calculating based on "Balance", and compare this to zero. Then display based on "Balance" > 0.

Also it is not wise (if this is what you are doing), to have a field in a table updated from processing on a form. Rather just have the value calculated when you run the form.

hey Eric, sorry forth ecross post, you were faster

David Singleton wrote:

hey Eric, sorry forth ecross post, you were faster

You are forgiven, my friend O:)

vyanku wrote:

thanks
But how to update the value of DR/CR.??
Suppose balance is become +ve then Dr should be automatically updated from CR to DR. Is there any function for update option value???

Its very important if you will start developing in Navision to learn about flowfields and how they work. they are key to the whole application, and you really will not be able to get far unless you first understand how they work.

Once you understand how flow fields work you will understand what we are suggesting.

Flow Fields and Flow Filters are explained clearly in the Navision Manuals. Also once you have read about them, then start playing with a test database and look at fields like Inventory in table 27, and the Balance vs Amount fields in table 15.

We are suggesting to delete your field in the table, and to create a variable on your form.

OnAfterGetRecord or OnOpenForm (statistics), just update your variable with the right Option value...

f we change the customer (like next costomer) then also OnValidate trigger of balance field is executed.

This is not true. OnValidate trigger is called just when the value in the field is changed. Not when you go to another record. And because this field is calculated and is not editable, there is no event which will fire this trigger.

vyanku wrote:

But I just want to show the Dr or CR .So that client can understand that Customer balance is DR or CR.

Can't they just look at the "Balance" field and see if it's negative or positive?

here's a simple answer if you just want it to standout on the customer card

OnFormat(VAR Text : Text[1024];)
IF "Balance ($)" < 0
THEN CurrForm."Balance ($)".UPDATEFORECOLOR(255)
ELSE CurrForm."Balance ($)".UPDATEFORECOLOR(0);

EDIT**Didn't realize it was a post from 2007 :oops: