Performance issue - posting invoices

JTPro

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

nunomaia

Why don't run the adjust cost at the end of posting?. Why don't run the adjust cost every 2 or 3 days?

Alex_Chow

Just change the Automatic Cost Adjustment to Never on the Inventory Setup.

JTPro

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

ara3n

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.

Savatage

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.

ara3n

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.

nunomaia

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.

ara3n

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.

Alex_Chow

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_Hollender

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?

ara3n

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!!!

Miklos_Hollender

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...

ara3n

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.

Lion

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.