Hi Nopes, in your case "regeneration" will be much faster than "net change".
Regards Harry ________________________________ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ax Dev Sent: 18 December 2006 12:54 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!! Hi Harry, Yes, I was referring 'Net Change'. We ran Regeneration for the whole system. And after one week of last Regeneration Run, we were using 'Net change' instead of 'Regeneration', because it make sense to run the master planning for the last one week. But during the one week period, records are created in InventSumLogTTS table very rapidly. So it took more than 3 hours which is not acceptable from clients' point of view. So just curious to know is there any way to improve the execution time of 'Net change' for this one week of records? Otherwise, we need to convince them to use Regeneration all the time as it is taking 1 hour of time frame, after using the clean job of InventSumLogTTS table. Thanks & Regards, Harsh On 12/18/06, Harry Deshpande <[EMAIL PROTECTED]<mailto:harryd%40microsoft.com>> wrote: > > Hi > > What is incremental run? Are you referring to net change? The assumption > that incremental run should take less time that regeneration is not correct. > If you have a huge number of records in InventSumLogTTS table then > "regeneration" is faster than "net change". > > Why do you run net change for the complete system at all? Why not just > regeneration? > > Regards > > Harry > > ________________________________ > From: > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com>[mailto: > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com>] > On Behalf Of Ax Dev > Sent: 18 December 2006 12:18 > To: > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com> > Subject: Re: [Axapta-Knowledge-Village] Problem with the explosion feature > at the sales line!!!! > > Hi Harry, > > I also have some problem related to Master Planning where InventSumLogTTS > table is the main culprit. We had a client with huge database, and they > tried to run Master Planning using Principle as Regeneration. It took more > than 8 hours for execution and at last it gives the error like Deletion of > records from InventSumLogTTS table exhausted the memory. We analyzed the > code and found that during Regeneration, we don't need the records in > InventSumLogTTS table(as these are required for Incremental Run). So we > created a truncate job to delete the records from InventSumLogTTS table > before Regeneration Run. And now it took around 1 hour and it executed > successfully. Now the problem is; if we are doing Incremental Run, it took > more than 3 hours, which is not exceptable from client's point of view, if > Regeneration is taking 1 hour, then Incremental Run should take less than > that. But Incremental Run is using records from InventSumLogTTS table, we > can't delete/truncate this table. Do you have any suggestions how to > improve > the Incremental Run process, it would be really helpful.? > > Thanks & Regards, > Harsh > > On 12/18/06, Harry Deshpande <[EMAIL > PROTECTED]<mailto:harryd%40microsoft.com><harryd%40microsoft.com> > <mailto:harryd% <harryd%25>40microsoft.com>> wrote: > > > > Hi > > > > It looks like the problem is with InventSumLogTTS and not with master > > planning. > > > > Check the records in inventsumlogtts after each step (the steps are > > slightly different) > > > > i.e > > > > 1. create sales order > > 2. create purchase order > > 3. receive item > > 4. post sales > > > > Ideally you should have records created in InventSumLogTTS after each > > step. Please also try this on standard installation. > > > > regards > > > > harry > > > > ________________________________ > > From: > > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com> > <mailto:Axapta-Knowledge-Village%40yahoogroups.com > ><Axapta-Knowledge-Village%40yahoogroups.com>[mailto: > > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com> > <mailto:Axapta-Knowledge-Village%40yahoogroups.com > ><Axapta-Knowledge-Village%40yahoogroups.com>] > > On Behalf Of Ricardo Cortés > > Sent: 18 December 2006 02:00 > > To: > > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com> > <mailto:Axapta-Knowledge-Village%40yahoogroups.com > ><Axapta-Knowledge-Village%40yahoogroups.com> > > Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion > feature > > at the sales line!!!! > > > > Hi Harry, > > > > I'm running in ax 3.0 sp 5. > > > > After invoice the first sales order there isn't any record on that table > > (InventSumtts) for the item. There are only two records on inventSum > table. > > The net requirement form for that item shows two lines with on hand, one > > with positive quantity and other with negative quantity. > > > > Do you know what is happening? > > > > Regards > > > > Ricardo Cortes > > > > Harry Deshpande <[EMAIL PROTECTED]<mailto:harryd%40microsoft.com> > > <harryd%40microsoft.com><mailto: > harryd% <harryd%25>40microsoft.com> <harryd%40microsoft.com><mailto: > > harryd% <harryd%25>40microsoft.com>> escribió: > > hi > > > > Which version are you running? > > > > You will have to do some investigation > > > > after you invoice the first sales order, what are the records in > > InventSumLogtts table? > > > > regards > > > > harry > > > > ________________________________ > > From: > > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com> > <mailto:Axapta-Knowledge-Village%40yahoogroups.com > ><Axapta-Knowledge-Village%40yahoogroups.com> > > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [ > > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com> > <mailto:Axapta-Knowledge-Village%40yahoogroups.com > ><Axapta-Knowledge-Village%40yahoogroups.com> > > <mailto:Axapta-Knowledge-Village%40yahoogroups.com>] On Behalf Of > Ricardo > > Cortés [EMAIL > > PROTECTED]<mailto:ricardocortesrivero%40yahoo.com.mx><ricardocortesrivero%40yahoo.com.mx> > <mailto:ricardocortesrivero%40yahoo.com.mx><ricardocortesrivero%40yahoo. > com.mx> > > <mailto:ricardocortesrivero%40yahoo.com.mx>] > > Sent: Friday, December 15, 2006 10:53 PM > > To: foro > > Subject: [Axapta-Knowledge-Village] Problem with the explosion feature > at > > the sales line!!!! > > > > Hi all, > > > > I've been having troubles with the explosion at the sales line, it is > > showing that i have inventory on hand when there isn't. > > > > The scenario to reproduce teh problem is: > > > > Create a sales order for an item without inventory on hand > > Run the explosion from the sales line > > The explosion form will show you a planned purchased order, this is > > correct. > > Firm the planned purchased order, receive the item and invoice the sales > > order. > > > > Create a new sales order for the same item (the item don't have > inventory) > > Run the explosion from the sales line again > > The explosion form will show that the item has inventory onhand when the > > reality there isn't. > > > > If you check the net requirement thru the sales order you can see that > > axapta is showing two lines in on hand one with a positive quantity and > > other with neative. So, like axapta is seeing lines with on hand for > this > > item is not calculating the requirement and is not plannig the purchase > > order. > > > > I know that Axapta in the explosion only take into account a few > > transaction for the item, but in this case it seems that is not settling > the > > previous transaction and that is why the result from the explosion is > wrong. > > > > Only running the Master planning for all the items in the regeneration > > mode fix the problem. > > > > Does any one have an idea of what is happening or if this is a bug? > > > > Thanks in advance > > > > Ricardo Cortes > > > > __________________________________________________ > > Correo Yahoo! > > Espacio para todos tus mensajes, antivirus y antispam ¡gratis! > > Regístrate ya - http://correo.yahoo.com.mx/ > > > > [Non-text portions of this message have been removed] > > > > --------------------------------- > > Do You Yahoo!? La mejor conexión a Internet y 2GB extra a tu correo por > > $100 al mes. http://net.yahoo.com.mx > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
