i am new to Dynamics NAV 2009 ,I am doing delevelopment side. i have a problem. in NAV , sales invoice sometime lines will add automatically and sometimes amounts will change.. when we are using naive database there is no issue .but since we are using SQL we got this issue. I cant understand whats the matter. If you can please help me to solve this proble its greate help to me. Thank you Shan Abeywicrema please contact me via firstname.lastname@example.org
Your question is not clear.
"Sometimes lines will add automatically"
So out of nowhere a three line order will show four?
Are you inserting data directly into tables by some 3rd party app?
Amounts change? change how? Is the change due to the additional line?
not enuf details to provide any help.
am not using 3rd party tool. sometimes lines will duplicate and
values are change like :: actual value 1020 it will change 2010
like wise.. now we are using SQL database. earlier we have used native
Since this is obviously not standard behavior of the system. You need to explain in MUCH MORE detail what is going on else you will have to contact your Nav partner to find out what's going on.
Because saying a value changes tells nothing. Is this value a price, a cost, a item number , a quantity?
When do you see this duplicate? right after you enter an item number, after a quantity, aftee you walk out of the room and come back? on releasing? do you use different currencies? has the sales order system been modified in anyway? Who did the changes? have them look at their code. Can you duplicate it at will? Have you turned on the debugger and follwed thru an order from beginning to end and see where & how this can happen?
the questions go on and on - and without details - it's just a guessing game.
When get orders from get shipment lines its not duplicated i go thru all the fileds by arrow keys and click on external document no filed then i see all the lines are duplicated. .I check on validate trigger but cant understand what happend bcoz i delete line and get again using get shipment function it not duplicated but dlete and do again it duplicated
The only thing I will add to the post by Savatage99 (who we really appreciate for all of their input thus far) is that it sounds like somehow you are setting a filter so it appears that the line is no longer there. You reprocess and then the filter is somehow cleared. The result is that more than one line appears. I would really watch your Table Filtering to make sure that the reason you are seeing lines appear and then disappear is because of filtering the lines.
As previously posted, I would highly recommend working with your partner on a screen sharing session to review the results of what you are seeing through a screen sharing session when the issue occurs to determine what is happening.
The key thing is that NAV will not randomly add or delete lines. However, with filtering, you could be inadvertantly filtering records and then not seeing correct information.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13