RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
Hi Routing this thru official Microsoft support is the right way to do it. What you have in your hand is quite unusual and the problem may lie outside master planning or imts Regards Harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ricardo Cortés Sent: 19 December 2006 17:44 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi, No, after deleting the plan and run again the regeneration worked, but to test more I let the users play in the environment and after a few hours I tested and it didn't work again. I don't know what is happening. Some guy from microsoft say that might be the *.aoc file but i don't know. What do you think? I'm having this issue in differents pc and with differents users. Regards Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com escribió: Hi 'delete the plan'? So after deleting the plan and running 'net change' your problem gets solved? Regards harry From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés Sent: 18 December 2006 23:21 To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi, If I run the master planning in net change the problem persist, what i'm doing now is deleting the plan and doing the scenario, it seems to be working now, but what i don't like is the fact you need to delete the plan or make a regeneration to make it works. Do you think is a problem the way the master plan tables are updated? Regards Ricardo Cortes Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.commailto:harryd%40microsoft.com escribió: hi ok, this is different. If 38 records are being created then it seems the problem is in master planning. Just to make sure, try the following: after invocing the sales order, go into the net requirements screen and run update net requirements (principle : net change). Do you still have the same problem? Have you been able to repro this on the demo system? regards harry From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mxmailto:ricardocortesrivero%40yahoo.com.mx] Sent: Monday, December 18, 2006 8:10 PM To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi Harry, I've been lookig at the InventSumLogTTS table and in each step creates records, but in each step creates more than one record. After finishinsihing the last step(invoice the sales) the item had 38 records. After, I created a new sales order and i did the explosion, but the system showed me onhand. I checked the InventSumLogTTS, and the system added just a new record for that sales order. Only running the master scheduling in regeneration worked to create thye planned purchse order, because with this that table get clean. Do you know what is causing this problem? Regards, Ricardo Cortes Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.commailto:harryd%40microsoft.commailto:harryd%40microsoft.com escribió: 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.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés Sent: 18 December 2006 02:00 To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE:
RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
Hi 'delete the plan'? So after deleting the plan and running 'net change' your problem gets solved? Regards harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ricardo Cortés Sent: 18 December 2006 23:21 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi, If I run the master planning in net change the problem persist, what i'm doing now is deleting the plan and doing the scenario, it seems to be working now, but what i don't like is the fact you need to delete the plan or make a regeneration to make it works. Do you think is a problem the way the master plan tables are updated? Regards Ricardo Cortes Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com escribió: hi ok, this is different. If 38 records are being created then it seems the problem is in master planning. Just to make sure, try the following: after invocing the sales order, go into the net requirements screen and run update net requirements (principle : net change). Do you still have the same problem? Have you been able to repro this on the demo system? regards harry From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mx] Sent: Monday, December 18, 2006 8:10 PM To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi Harry, I've been lookig at the InventSumLogTTS table and in each step creates records, but in each step creates more than one record. After finishinsihing the last step(invoice the sales) the item had 38 records. After, I created a new sales order and i did the explosion, but the system showed me onhand. I checked the InventSumLogTTS, and the system added just a new record for that sales order. Only running the master scheduling in regeneration worked to create thye planned purchse order, because with this that table get clean. Do you know what is causing this problem? Regards, Ricardo Cortes Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.commailto:harryd%40microsoft.com escribió: 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.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés Sent: 18 December 2006 02:00 To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto: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.commailto:harryd%40microsoft.commailto:harryd%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.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mxmailto:ricardocortesrivero%40yahoo.com.mxmailto: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
RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
Hi, No, after deleting the plan and run again the regeneration worked, but to test more I let the users play in the environment and after a few hours I tested and it didn't work again. I don't know what is happening. Some guy from microsoft say that might be the *.aoc file but i don't know. What do you think? I'm having this issue in differents pc and with differents users. Regards Harry Deshpande [EMAIL PROTECTED] escribió: Hi 'delete the plan'? So after deleting the plan and running 'net change' your problem gets solved? Regards harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ricardo Cortés Sent: 18 December 2006 23:21 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi, If I run the master planning in net change the problem persist, what i'm doing now is deleting the plan and doing the scenario, it seems to be working now, but what i don't like is the fact you need to delete the plan or make a regeneration to make it works. Do you think is a problem the way the master plan tables are updated? Regards Ricardo Cortes Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com escribió: hi ok, this is different. If 38 records are being created then it seems the problem is in master planning. Just to make sure, try the following: after invocing the sales order, go into the net requirements screen and run update net requirements (principle : net change). Do you still have the same problem? Have you been able to repro this on the demo system? regards harry From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mx] Sent: Monday, December 18, 2006 8:10 PM To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi Harry, I've been lookig at the InventSumLogTTS table and in each step creates records, but in each step creates more than one record. After finishinsihing the last step(invoice the sales) the item had 38 records. After, I created a new sales order and i did the explosion, but the system showed me onhand. I checked the InventSumLogTTS, and the system added just a new record for that sales order. Only running the master scheduling in regeneration worked to create thye planned purchse order, because with this that table get clean. Do you know what is causing this problem? Regards, Ricardo Cortes Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.commailto:harryd%40microsoft.com escribió: 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.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés Sent: 18 December 2006 02:00 To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto: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.commailto:harryd%40microsoft.commailto:harryd%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.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL
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] 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.comAxapta-Knowledge-Village%40yahoogroups.com[mailto: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés Sent: 18 December 2006 02:00 To: Axapta-Knowledge-Village@yahoogroups.comAxapta-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] harryd%40microsoft.commailto: harryd% harryd%2540microsoft.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.comAxapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [ Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]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
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] 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.comAxapta-Knowledge-Village%40yahoogroups.com[mailto: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ax Dev Sent: 18 December 2006 12:18 To: Axapta-Knowledge-Village@yahoogroups.comAxapta-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]harryd%40microsoft.com mailto:harryd% harryd%2540microsoft.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.comAxapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Axapta-Knowledge-Village%40yahoogroups.com[mailto: Axapta-Knowledge-Village@yahoogroups.comAxapta-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.comAxapta-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] harryd%40microsoft.commailto: harryd% harryd%2540microsoft.com harryd%40microsoft.commailto: harryd% harryd%2540microsoft.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.comAxapta-Knowledge-Village%40yahoogroups.com
RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
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.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com[mailto: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ax Dev Sent: 18 December 2006 12:18 To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-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.comharryd%40microsoft.com mailto:harryd% harryd%2540microsoft.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.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Axapta-Knowledge-Village%40yahoogroups.com[mailto: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-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.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-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
RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
Hi On other things: I would pay more attention to the error message about exhausted memory. Please check out CPU and Mem utilization on AOS as well as SQL server Regards Harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ax Dev Sent: 18 December 2006 12:18 To: Axapta-Knowledge-Village@yahoogroups.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 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.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com[mailto: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés Sent: 18 December 2006 02:00 To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-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.commailto: harryd% harryd%2540microsoft.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.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [ Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mxricardocortesrivero%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
RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
Hi Harry, I've been lookig at the InventSumLogTTS table and in each step creates records, but in each step creates more than one record. After finishinsihing the last step(invoice the sales) the item had 38 records. After, I created a new sales order and i did the explosion, but the system showed me onhand. I checked the InventSumLogTTS, and the system added just a new record for that sales order. Only running the master scheduling in regeneration worked to create thye planned purchse order, because with this that table get clean. Do you know what is causing this problem? Regards, Ricardo Cortes Harry Deshpande [EMAIL PROTECTED] escribió: 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:[EMAIL PROTECTED] On Behalf Of Ricardo Cortés Sent: 18 December 2006 02:00 To: Axapta-Knowledge-Village@yahoogroups.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 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.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]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] __ 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]
RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
hi ok, this is different. If 38 records are being created then it seems the problem is in master planning. Just to make sure, try the following: after invocing the sales order, go into the net requirements screen and run update net requirements (principle : net change). Do you still have the same problem? Have you been able to repro this on the demo system? regards harry From: Axapta-Knowledge-Village@yahoogroups.com [EMAIL PROTECTED] On Behalf Of Ricardo Cortés [EMAIL PROTECTED] Sent: Monday, December 18, 2006 8:10 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi Harry, I've been lookig at the InventSumLogTTS table and in each step creates records, but in each step creates more than one record. After finishinsihing the last step(invoice the sales) the item had 38 records. After, I created a new sales order and i did the explosion, but the system showed me onhand. I checked the InventSumLogTTS, and the system added just a new record for that sales order. Only running the master scheduling in regeneration worked to create thye planned purchse order, because with this that table get clean. Do you know what is causing this problem? Regards, Ricardo Cortes Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com escribió: 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.commailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés Sent: 18 December 2006 02:00 To: Axapta-Knowledge-Village@yahoogroups.commailto: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.commailto:harryd%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.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mxmailto: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,
RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
Hi, If I run the master planning in net change the problem persist, what i'm doing now is deleting the plan and doing the scenario, it seems to be working now, but what i don't like is the fact you need to delete the plan or make a regeneration to make it works. Do you think is a problem the way the master plan tables are updated? Regards Ricardo Cortes Harry Deshpande [EMAIL PROTECTED] escribió: hi ok, this is different. If 38 records are being created then it seems the problem is in master planning. Just to make sure, try the following: after invocing the sales order, go into the net requirements screen and run update net requirements (principle : net change). Do you still have the same problem? Have you been able to repro this on the demo system? regards harry From: Axapta-Knowledge-Village@yahoogroups.com [EMAIL PROTECTED] On Behalf Of Ricardo Cortés [EMAIL PROTECTED] Sent: Monday, December 18, 2006 8:10 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi Harry, I've been lookig at the InventSumLogTTS table and in each step creates records, but in each step creates more than one record. After finishinsihing the last step(invoice the sales) the item had 38 records. After, I created a new sales order and i did the explosion, but the system showed me onhand. I checked the InventSumLogTTS, and the system added just a new record for that sales order. Only running the master scheduling in regeneration worked to create thye planned purchse order, because with this that table get clean. Do you know what is causing this problem? Regards, Ricardo Cortes Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com escribió: 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.commailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés Sent: 18 December 2006 02:00 To: Axapta-Knowledge-Village@yahoogroups.commailto: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.commailto:harryd%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.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mxmailto: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
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] 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 [EMAIL PROTECTED] On Behalf Of Ricardo Cortés [EMAIL PROTECTED] 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]
RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
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:[EMAIL PROTECTED] On Behalf Of Ricardo Cortés Sent: 18 December 2006 02:00 To: Axapta-Knowledge-Village@yahoogroups.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 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.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]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]
RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
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 [EMAIL PROTECTED] On Behalf Of Ricardo Cortés [EMAIL PROTECTED] 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]