Sales Invoice is taking too much of time on post

Markandey_Pandey · 2010-01-02

Hi All,

when i am posting sales invoices its taking around 5 minutes of time. What may be the reason for that.
However this is happening only for few items and customers rest is working fine and taking not more that 5 seconds.

Can anybody suggest me the solution.

Markandey_Pandey · 2010-01-04

Hi all

can anybody tell me what is the reason for this.
its taking too much time every time an invoice is posted.

kapamarou · 2010-01-04

Most probably it is some customization that needs some investigation, but it could be anything from Hardware / Software setup to bad design, absence of optimization, network issues...

Start by searching this site for performance optimization, read everything you find and then start investigating your issue.

This is a huge topic.

Cem_Karaer · 2010-01-04

Analysis views updating online can choke off all posting. If you have analysis views, prefer updating them by batch processing.

Markandey_Pandey · 2010-01-04

cemkaraer wrote:

Analysis views updating online can choke off all posting. If you have analysis views, prefer updating them by batch processing.

I am very new to navision not having much idea about this, can u plz explain me how to do batch processing.

ssingla · 2010-01-04

If you are new to NAV then forward the issue to your seniors. Performance analysis needs a good amount of experience.

garak · 2010-01-04

Hi, some questions:

1. is there a senior NAv developer on your side (for a better help)?
2. how looks your Hardware (what for an storage, how many RAM, what kind of CPU, network, etc)
3. SQl or Native
4. if SQL exist there some Manint. jobs?
5. is there some customized code?
6. are there some statistic datas written like Analysis View or some other "entries"
7. How many lines has the Sales invoice
8. is this ever or only on some hours?

Like ssingla said: "Performance analysis needs a good amount of experience".

Regards

Markandey_Pandey · 2010-01-05

Hi all
i am attaching the screen shot of the progress window that is being displayed for 5-10 minutes when a sale invoice is posted.

kapamarou · 2010-01-05

It could be related with the Automatic Cost Adjustment in the Inventory setup.

Edit:
Or Automatic Cost Posting in the Inventory setup.

garak · 2010-01-05

Native database or SQL?

Alex_Chow · 2010-01-05

Markandey Pandey wrote:

Hi all
i am attaching the screen shot of the progress window that is being displayed for 5-10 minutes when a sale invoice is posted.

Try setting your Automatic Cost Adjustment to Never on the Inventory Setup and posting again.

garak · 2010-01-05

Alex Chow wrote:

Markandey Pandey wrote:

Hi all
i am attaching the screen shot of the progress window that is being displayed for 5-10 minutes when a sale invoice is posted.

Try setting your Automatic Cost Adjustment to Never on the Inventory Setup and posting again.

But then u must run the Cost Adjustment manual for example at the end of the day / week or what else or run it automaticly at the evening per NAS.

Markandey_Pandey · 2010-01-06

kapamarou wrote:

It could be related with the Automatic Cost Adjustment in the Inventory setup.

Edit:
Or Automatic Cost Posting in the Inventory setup.

Hi,
In inventory Setup there is a field "Automatic Cost Adjustment", if i am setting it to "Never"
then my problem is resolved but will it cause any problem if yse then whats the solution.

Marije_Brummel · 2010-01-06

What you are doing is extremely dangerous. You have obviously no idea what impact your actions have.

Please, please, go to your NAV partner or a performance specialist and let them handle it for you.

Alex_Chow · 2010-01-06

Markandey Pandey wrote:

kapamarou wrote:

It could be related with the Automatic Cost Adjustment in the Inventory setup.

Edit:
Or Automatic Cost Posting in the Inventory setup.

Hi,
In inventory Setup there is a field "Automatic Cost Adjustment", if i am setting it to "Never"
then my problem is resolved but will it cause any problem if yse then whats the solution.

You need to run the adjust cost process periodically. For high transaction volumn companies, running adjust cost for every posting does not make sense.

I suggest you setup the adjust cost process to run using the job queue.

garak · 2010-01-06

Ask your partner for an better help and support.
If you have a lot of transactions between the Purchase Shipment -> Sales Shipments / Invoices and then the Purchase Invoice for the Purch. shipment, then the system has to adjust the Unit cost for these Sales entries. It's better then, also to minimize blockes and slow posting routines to run these coste adj. at the evening (for example with a NAS or a logged on Client).

regards

ssingla · 2010-01-07

Markandey Pandey wrote:

cemkaraer wrote:

Analysis views updating online can choke off all posting. If you have analysis views, prefer updating them by batch processing.

I am very new to navision not having much idea about this, can u plz explain me how to do batch processing.

I would suggest you to call your partner if you are working for a client else call your seniors. Do not try to experiment with the system else you might create a mess trying to solve the issue.

Markandey_Pandey · 2010-01-14

You need to run the adjust cost process periodically. For high transaction volumn companies, running adjust cost for every posting does not make sense.

I suggest you setup the adjust cost process to run using the job queue.[/quote]

How to do this, actually there are different fields in the job queue, what fields i need to set to run this batch job say everyday at 5 PM

Sales Invoice is taking too much of time on post

Comments

Categories