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.com<mailto: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.com<mailto: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.com><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.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto:Axapta-Knowledge-Village%40yahoogroups.com> [mailto:Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto: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><mailto: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><mailto:harryd%40microsoft.com><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.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED]<mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto:Axapta-Knowledge-Village%40yahoogroups.com>] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]<mailto:ricardocortesrivero%40yahoo.com.mx><mailto: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] __________________________________________________ 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] __________________________________________________ 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] [Non-text portions of this message have been removed]