Hello all,
My client has got over 1000 invoices each day. All invoices are posted once , on the end of day (using Post Batch functionality). The problem is that Navision (4.00 SP2) is adjusting costs, that really slows down the whole job. The database is on SQL Server 2000. I looking for some ideas how to speed up this process. I will be very appreciate for any suggest.
Best regards
JTPro
Navision Application Version: 4.0SP1
Navision Database Version: 4.0
0
Comments
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
For some reasons our financial specialists want to keep this setting. So this method is out of discussion.
I'm looking for solution having CostAdjustment set up for every invoice.
Any advice will be appreciate.
Best regards
JTPro
Navision Database Version: 4.0
One of our client had the same issue. We changed the setting, and are running the routine at night everyday automatically by NAS. It works fine for them.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
we also do as aran says - but we post them directly from the client on the server. really speeds things up.
http://www.BiloBeauty.com
http://www.autismspeaks.org
It's 80 user system. They use manufacturing, Navision CRM. credit card processing.
They report every lock that the user get as a support issue.
We've streamlined the process so that I haven't heard a single issue for a month now on anybody getting any locks.
They are so spoiled. The only thing I'm worried is the number of transactions.
They are now live for 2 months, and their db is allredy 10 Gig. with 400K item ledger entries. They have good hardware, but still.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
You probably will have 2 databases, one compressed and other in production. I don’t think Navision has designed to have grown so fast.
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Any particular reason why your financial specialist want to keep this setting?
Like ara3n mentioned, you can just run the adjust cost process before you go home.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
is it a good idea to run adjust costs via the appserver? If there is an error or an endless loop, how users get notified of it?
The server at night kicks everybody out for backup. I have not seen infinite loops in sp3 yet, but if it runs into it, it will be kicked out and the next morning they'll see that the job didn't run.
They check in morning and see if every job ran last night, and if they were successful.
Yes it is a great idea. For this company. Most of the users are stupid. We can't rely on them on doing some of things so we scheduled it.
The consultant went as far as changing most of the setup forms so that they do not change them!!!
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Amazing! Last time I checked it didn't do it. I'll have to check it again.
So you are using job scheduler with the appserver? I always used the appserver to run individual CU's, hacking them into CU 1. Kind of ugly, I think. If I remember correctly job scheduler is designed to have a client always open and have a form open on it that has an ontimer trigger? Does the job scheduler have CU now that can be easily ran by the appserver or you've changed it? I don't think an ontimer trigger can be used from a CU - though the Navision Timer OCX might help. I have a guess it was exactly designed for this kind of thing...
I move the code from the form to a codeunit that gets triggered every few seconds. with the timer event.
I've added email functionality to the codeunit.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I’m working on the same problem. I thing this is a problem with cost adjustment’s batch Job . When I posting and correcting costs after invoice it’s take 30 second/doc if I have 500 invoices it’s take 250 min. If half time, is waits and locks, it’s still 12 times more than I run batch job once for all documents (it take 10 min). I think the problem is when you are trying run batch job from two (ore more) PCs and the same batch job correcting the same item costs. Additional we have problem with costs - for example we bought some item for the highest price 12, but the average cost is 370.
Maciej Rutkowski