mibuso.com
Home› NAV/Navision Classic Client

Sales Invoice is taking too much of time on post

Markandey_PandeyMarkandey_Pandey Member Posts: 178
edited 2010-01-14 in NAV/Navision Classic Client
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

Comments

  • Markandey_PandeyMarkandey_Pandey Member Posts: 178
    Hi all

    can anybody tell me what is the reason for this.
    its taking too much time every time an invoice is posted.
    Markandey Pandey
  • kapamaroukapamarou Member Posts: 1,152
    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_KaraerCem_Karaer Member Posts: 281
    Analysis views updating online can choke off all posting. If you have analysis views, prefer updating them by batch processing.
    Cem Karaer @ Pargesoft
    Dynamics NAV Developer since 2005
  • Markandey_PandeyMarkandey_Pandey Member Posts: 178
    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.
    Markandey Pandey
  • ssinglassingla Member Posts: 2,973
    If you are new to NAV then forward the issue to your seniors. Performance analysis needs a good amount of experience.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • garakgarak Member Posts: 3,263
    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
    Do you make it right, it works too!
  • Markandey_PandeyMarkandey_Pandey Member Posts: 178
    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.
    Markandey Pandey
  • kapamaroukapamarou Member Posts: 1,152
    It could be related with the Automatic Cost Adjustment in the Inventory setup.

    Edit:
    Or Automatic Cost Posting in the Inventory setup.
  • garakgarak Member Posts: 3,263
    Native database or SQL?
    Do you make it right, it works too!
  • Alex_ChowAlex_Chow Member Posts: 5,063
    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.
    Confessions of a Dynamics NAV Consultant = my blog
    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
  • garakgarak Member Posts: 3,263
    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.
    Do you make it right, it works too!
  • Markandey_PandeyMarkandey_Pandey Member Posts: 178
    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.
    Markandey Pandey
  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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.
    Marije Brummel | Freelance Business Central Specialist
  • Alex_ChowAlex_Chow Member Posts: 5,063
    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.
    Confessions of a Dynamics NAV Consultant = my blog
    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
  • garakgarak Member Posts: 3,263
    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
    Do you make it right, it works too!
  • ssinglassingla Member Posts: 2,973
    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.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Markandey_PandeyMarkandey_Pandey Member Posts: 178
    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
    Markandey Pandey
Sign In or Register to comment.