Navision 4 SP1 on SQL "flow fields" doesn't update

taith

](*,) ](*,) ](*,) ](*,) ](*,)
just installed the new italian sp1 on a sql but...surprise the flow fields doesn't not update if something is changed....

for example
look at a customer balance

try to delete cust ledger entries and....the balance is the same....

nice work Bill

grrrrrr
[-X

P.S.
with standard database all seems to work fine

ara3n

where are u deleteing the ledger entries? from SQL? You should not touch those tables from sql. Post a journal instead.

ara3n

also customer balance doesn't come from cust ledger entry. it comes from detail cust. ledger entry. Take a look at the flowfields.

ara3n

And don't blame bill for everything. :whistle:

taith

all the flow field doesn't work fine in SQL local installation

if you change something new registration, or whatever you want the flow field doesn't update himself

Marije_Brummel

I remember reading that sometimes the SIFT tables ar not updated if you change ledger entry information using SQL.

I think it had something to do with updating the keys.

Remember the flowfields do not read the ledger entry tables but special SIFT tables that are mainaned seperate from the source tables.