Performance issue - posting invoices

JTProJTPro Member Posts: 169
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

Comments

  • nunomaianunomaia Member Posts: 1,153
    Why don't run the adjust cost at the end of posting?. Why don't run the adjust cost every 2 or 3 days?
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Alex_ChowAlex_Chow Member Posts: 5,063
    Just change the Automatic Cost Adjustment to Never on the Inventory Setup.
  • JTProJTPro Member Posts: 169
    Thanks for your responses.

    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 Application Version: 4.0SP1
    Navision Database Version: 4.0
  • ara3nara3n Member Posts: 9,256
    Hello JTPro
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • SavatageSavatage Member Posts: 7,142
    1000 invoices - just curious on the amt of line items per inv (average)?

    we also do as aran says - but we post them directly from the client on the server. really speeds things up.
  • ara3nara3n Member Posts: 9,256
    our client avg amt is 200 dollars and daily they ship 1K orders. They use whs mgt. They just ship the orders. The NAS scheduler does the invoicing. at night. It runs adjust cost. It creates SO comming from other systems.
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • nunomaianunomaia Member Posts: 1,153
    10 GB in only 2 months, probably in 1 year you will have a huge database. :)

    You probably will have 2 databases, one compressed and other in production. I don’t think Navision has designed to have grown so fast.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • ara3nara3n Member Posts: 9,256
    new year is their high sale season becauase of new year resolution. I am guessing the sales will come down. We also brought a lot of setup data., and we have a test company. i am guessing 1-3 gig a month.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Alex_ChowAlex_Chow Member Posts: 5,063
    JTPro wrote:
    Thanks for your responses.

    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

    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.
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    Ara3n,

    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?
  • ara3nara3n Member Posts: 9,256
    Job scheduler notifies with an email if an job fails.
    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!!!
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    Job scheduler notifies with an email if an job fails.

    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...
  • ara3nara3n Member Posts: 9,256
    I'm using Navision job scheduler to setup the jobs.

    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • LionLion Member Posts: 39
    JTPro wrote:
    Thanks for your responses.

    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

    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.
    Regards,
    Maciej Rutkowski
Sign In or Register to comment.