Performance Delay in NAV 2009

abnainas

When I Try to fill Automatic serial numbers in the item tracking lines window for quantity of 2000 units of an item the system takes more than 10 minutes to assign the serial and lot no.,in usual work the quantity will be larger than this as a usual(ex. 30000,100000 or larger) which make the system not responding. note that we use "customized serial number" function in the item tacking lines window to assign serial and lot numbers,

Please advice

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

kine

You need to do some performance optimization of your system. Monitor the system, find the source of performance problem, remove it...

David_Singleton

abnainas wrote:

When I Try to fill Automatic serial numbers in the item tracking lines window for quantity of 2000 units of an item the system takes more than 10 minutes to assign the serial and lot no.,in usual work the quantity will be larger than this as a usual(ex. 30000,100000 or larger) which make the system not responding. note that we use "customized serial number" function in the item tacking lines window to assign serial and lot numbers,

Please advice

With this volume of serial numbers you really need to look at a different solution.

abnainas

Hi David,

Did you face this problem?

Do you have a suggestions to solve it?

Best Regards

David_Singleton

abnainas wrote:

Hi David,

Did you face this problem?

Do you have a suggestions to solve it?

Best Regards

I did a number of Serial Number solutions, mostly before the current system. I have never liked the current system. It really is a general purpose system, it works OK in most companies, but never ideal.

I would suggest an analysis of how the client works and build a custom system. I know it goes against all logic to create something that already exists, but in your case it will probably be a better solution.

ara3n

Is this in NAV 2009 or older version.

In older version is was true that you would get a no response. In 2009 they've added a dialog and have restructured the code to run much faster.


The reason is that the form opens on temporary records, and at the end the form needs to write the records to the sql server.


I which CAL added the option to bulk insert temp records in one statement instead of looping through temp records and inserting them at once.

On my 3 year old laptop it takes 10000 serial no be auto generated in 30 sec. and 2 min to write it back to sql.


If you think about the actual time, putting 10K serial no stickers on your inventory will take you weeks. the auto assigning serial no will not be an issue.

Also if your client is daily dealing those huge number, you might want to look for a mod as david mentioend or look into AX.

abnainas

Hi ara3n

it's with NAV 2009.

Do u have a solution for this problem.. My customer want to assign 50000 serial on one shot...

Please advice.

David_Singleton

As Rashed points out, assigning the serial numbers is not an issue. The issue comes later down the track i how you manage them.

Why for instance does your client need this level of tracking? Do they manufacture the items?

David_Singleton

Also importantly how many items do the company have per month, so

No Items x no of serial numbers = no of ILE.

abnainas

My customer working in Telecommunication sector.... They have a lot of serials to generated.

David_Singleton

abnainas wrote:

My customer working in Telecommunication sector.... They have a lot of serials to generated.

That doesn't answer any of the questions. If everything is secret and you don't want to provide information, whats the point of asking questions?

abnainas

Dear David ,

I don't hide anything... As I told you, they have an average of 50000 serials to be generated for one item. They doing this every day.

Please, do you have any suggestions?

Thanks in advance.

David_Singleton

abnainas wrote:

Dear David ,

I don't hide anything... As I told you, they have an average of 50000 serials to be generated for one item. They doing this every day.

Please, do you have any suggestions?

Thanks in advance.

You need to answer some questions.

This is the sort of thread that mibuso is great for. It is not standard Navision, so you wont find the answers in the books or from Microsoft, so if you can give details REAL DETAILS of what the client does (their business, not Navision code) then members here will share ideas and experiences.

But YOU have to fully understand the need first before any help will makes sense:

David Singleton wrote:

I would suggest an analysis of how the client works and build a custom system.

David Singleton wrote:

how many items do the company have per month, so No Items x no of serial numbers = no of ILE.

David Singleton wrote:

Why for instance does your client need this level of tracking?

David Singleton wrote:

Do they manufacture the items?

Plus other information such as:
- You sometimes mention 30,000 and sometimes 50,000 and sometimes 100,000 is that S/N per item, is that S/Ns per month, per day?
- What level of tracking do you have? Why this level of detail?
- When are the S/Ns used?
- How are the items organized?
- Is this a FIFO/LIFO, Standard or Specific costing scenario? (Don't even think about Average).
- How do the warehouse staff actually pull items? (do they search for a specific S/N or do they pull LIFO and then write down the S/N or what?

So far you have thrown out a number of 50,000 without any reference to what it means.

If you can't answer all the above questions (and lots more) then you are not even close to looking at Navision, you still have a couple of days of work on site doing analysis with the customer.

abnainas

Thanks a lot for your reply.

I will give you a full details tomorrow.

Best Regards,

ara3n

My guess, they probably just need to track the SN at the time of sale, so they don't need to enter 50K Serial no and track it throughout the system.

abnainas

Dear David ,

how many items do the company have per month, so No Items x no of serial numbers = no of ILE.

They have about 100-200 hundred items per month. And the average serial numbers are 50,000 but sometimes they deal with 1,000,000-1,500,000 serials once or twice a year.


Why for instance does your client need this level of tracking?

Any telecommunication company needs such tracking system as they need to identify which serial has been sold or damaged for proper processing.

Do they manufacture the items?

No, They don't but they wish to recognize what is defected in order to return to the vendor.


Plus other information such as:
- You sometimes mention 30,000 and sometimes 50,000 and sometimes 100,000 is that S/N per item, is that S/Ns per month, per day?
50,000 per month.

- What level of tracking do you have? Why this level of detail?
Any telecommunication company needs such tracking system as they need to identify which serial has been sold or damaged for proper processing.

- When are the S/Ns used?
At any inbound or outbound transactions.
- How are the items organized?
- Is this a FIFO/LIFO, Standard or Specific costing scenario? (Don't even think about Average).
Tracking doesn't have anything to do with their costing and yeah it's average, why shouldn't I think of average?

- How do the warehouse staff actually pull items? (do they search for a specific S/N or do they pull LIFO and then write down the S/N or what?
They pull it specifically. By serial no.

Best Regards,

kine

- Is this a FIFO/LIFO, Standard or Specific costing scenario? (Don't even think about Average).
Tracking doesn't have anything to do with their costing and yeah it's average, why shouldn't I think of average?

Average is worst case of costing and there are no reason to use it, even when boss want to have some report with average costs (you can calculate the average when he need even when you use FIFO or standard cost). In average, each time you post something into history, the cost must be recalculated. It means when you run the Adjust cost job, it will take much longer than with other costing. I am sure, that David will describe it better, this is my view of average cost, from technical side.

David_Singleton

Hi Ahmad,

I am really not sure how to help you or even if its possible. This requires going back on site and working with the customer. Your comments seem to suggest that you don't really have a full picture of how the client works. You answer questions by saying "this is standard in this industry.

Before you can design a new system for the client, you have to have all the business procedures documented and need to know exactly how they work.

Dr_mjh

Hi there,

Regarding the average costing, from accounting point of view actually average costing is in between (conservative) it is not like FIFO where COGS is in its minimum or like LIFO where COGS is in its maximum and for that the GAAP and IFRS has prevented the use of LIFO some time a few years ago (but I think it's back now) thus it's quite logic that people and myself like average costing because it doesn't overestimate or underestimate COGS. However, regarding performance issues it is always not recommended to make the automatic cost posting field in the inventory setup not ticked and the automatic cost adjustment to be either periodic or never and to ahve the adjustment batch to be run manually periodically run to enhance performance issue.

Regarding the industry business yes, it should gathered and documented but as standards for the same industry will always be same and as far as I know that tracking of serial no. in telecom. industry is a must and when you even suggest that to not track would give the impression that you lack the knowledge in the inducstry for the customer.

Regarding Ara3n; "I which CAL added the option to bulk insert temp records in one statement instead of looping through temp records and inserting them at once.

On my 3 year old laptop it takes 10000 serial no be auto generated in 30 sec. and 2 min to write it back to sql."

What did you do exactly to get that results? i.e.: it is not standard NAV isn't it?

Thank you for your cooperation.
Best Regards