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.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: 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]
