RE: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are
Hi Ok now copy the data to a test system. Clear out the inventory reference (set it to none) and inventory reference number (set it to ) manually. Close the production order and check if the problem goes away. This will confirm the root cause of the problem Regards Harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of futzawm Sent: 22 January 2007 18:33 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are Hi Harry, thanks for the response. I can't find the line in any of the BoM journals (there isn't a BoM journal associated with that particular production which has not been registered). So just to be sure, would the line in the database you mention be the line in the 'InventTrans' table--i.e., the line with references? Thanks again! Mikki --- In Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: Hi If this field is filled up then there is a BOM journal that has not been posted. If you cant see this in the form then search for the line in the database. If (you find the line) Delete this line and you should be ok else Let me know. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. 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 futzawm Sent: 17 January 2007 18:21 To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are Thanks for your response, Harry. I believe you are referring to the 'General' tab of the 'Transactions' form. Yes, there's an inventory reference (the field is 'TransChildRefId' and the Type is 'Picking List Journal'). Would that be of significance? Note that the status of the transaction is 'On order' as pointed out in my original question. Regards. Mikki --- In Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com, Harry Deshpande harryd@ wrote: hi Is there any inventory reference on the inventory transaction for the item? I dont have Ax in front of me right now, but this reference is I think on the second tab and the field is InventRefChildId or something similar 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 futzawm [EMAIL PROTECTED] Sent: Monday, January 15, 2007 9:23 PM To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Production closing error: Quantity ordered may not be reduced, as there are.. Please help on the following problem (I have seen similar questions in the forum but none Were resolved): We are trying to close a production order and the following error is being generated: Calculating BOM Consumption Posting - Picking list journal Journal: PJ Voucher: PV Line No: 1 Item No: 00123 Quantity ordered may not be reduced, as there are not enough stock transactions with 'on order' status. The items are 'Sold', 'Deducted' or 'Picked'. The production was started with the item in question but another item was substituted during production. Registration of the picking list journal was thus done with the item consumption = 0. There are no transactions with 'Sold', 'Deducted' or 'Picked' status for the item as referring to that particular production. However, the item transactions show a quantity equal to the original started quantity with status 'On Order' for that particular production (therefore, no reason for the error not enough stock transactions with 'On Order' status). I saw one earlier response to this type of problem by fvatne where it was suggested that the problem can be a result of mismatch between different dimensions. This seemed a logical reason but the problem was not solved even after we removed all dimension restrictions
RE: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are
hi The two fields on inventtrans transchildtype and transchildrefid. you will have to change the field properties to enable allowedit regards harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.com [EMAIL PROTECTED] On Behalf Of futzawm [EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 8:49 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are I am sorry Harry, but exactly where and how do I do that? I mean I copied the data to a test environment and I do know how to make manual changes on tables (though I am very uncomfortable doing that). But I am not sure exactly which table and exactly which fields to change (clear out the inventory reference, inventory reference number). Thanks for bearing with me! Mikki --- In Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: Hi Ok now copy the data to a test system. Clear out the inventory reference (set it to none) and inventory reference number (set it to ) manually. Close the production order and check if the problem goes away. This will confirm the root cause of the problem 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 futzawm Sent: 22 January 2007 18:33 To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are Hi Harry, thanks for the response. I can't find the line in any of the BoM journals (there isn't a BoM journal associated with that particular production which has not been registered). So just to be sure, would the line in the database you mention be the line in the 'InventTrans' table--i.e., the line with references? Thanks again! Mikki --- In Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com, Harry Deshpande harryd@ wrote: Hi If this field is filled up then there is a BOM journal that has not been posted. If you cant see this in the form then search for the line in the database. If (you find the line) Delete this line and you should be ok else Let me know. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. 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 futzawm Sent: 17 January 2007 18:21 To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are Thanks for your response, Harry. I believe you are referring to the 'General' tab of the 'Transactions' form. Yes, there's an inventory reference (the field is 'TransChildRefId' and the Type is 'Picking List Journal'). Would that be of significance? Note that the status of the transaction is 'On order' as pointed out in my original question. Regards. Mikki --- In Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com, Harry Deshpande harryd@ wrote: hi Is there any inventory reference on the inventory transaction for the item? I dont have Ax in front of me right now, but this reference is I think on the second tab and the field is InventRefChildId or something similar regards harry From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village
Re: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are
Hi, I am not sure if you have already solved this. Can you please check the InventTransID of the problemed Line, to see if that exists in inventTrans table with status 'Onorder' and the same line exits in InventJournalTrans table?. I beleive the journal posting is incomplete/errored/messed up and didnget updated properly. or if are a techy guy, you might want to put in a debug point near and around Inventmovement / upd classes/subclasses to see where irs erroring out. Good Luck, Subbu 1 less for double master. futzawm [EMAIL PROTECTED] wrote: Hi Harry, thanks for the response. I can't find the line in any of the BoM journals (there isn't a BoM journal associated with that particular production which has not been registered). So just to be sure, would the line in the database you mention be the line in the 'InventTrans' table--i.e., the line with references? Thanks again! Mikki --- In Axapta-Knowledge-Village@yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: Hi If this field is filled up then there is a BOM journal that has not been posted. If you cant see this in the form then search for the line in the database. If (you find the line) Delete this line and you should be ok else Let me know. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of futzawm Sent: 17 January 2007 18:21 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are Thanks for your response, Harry. I believe you are referring to the 'General' tab of the 'Transactions' form. Yes, there's an inventory reference (the field is 'TransChildRefId' and the Type is 'Picking List Journal'). Would that be of significance? Note that the status of the transaction is 'On order' as pointed out in my original question. Regards. Mikki --- In Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com, Harry Deshpande harryd@ wrote: hi Is there any inventory reference on the inventory transaction for the item? I dont have Ax in front of me right now, but this reference is I think on the second tab and the field is InventRefChildId or something similar regards harry From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of futzawm [EMAIL PROTECTED] Sent: Monday, January 15, 2007 9:23 PM To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Production closing error: Quantity ordered may not be reduced, as there are.. Please help on the following problem (I have seen similar questions in the forum but none Were resolved): We are trying to close a production order and the following error is being generated: Calculating BOM Consumption Posting - Picking list journal Journal: PJ Voucher: PV Line No: 1 Item No: 00123 Quantity ordered may not be reduced, as there are not enough stock transactions with 'on order' status. The items are 'Sold', 'Deducted' or 'Picked'. The production was started with the item in question but another item was substituted during production. Registration of the picking list journal was thus done with the item consumption = 0. There are no transactions with 'Sold', 'Deducted' or 'Picked' status for the item as referring to that particular production. However, the item transactions show a quantity equal to the original started quantity with status 'On Order' for that particular production (therefore, no reason for the error not enough stock transactions with 'On Order' status). I saw one earlier response to this type of problem by fvatne where it was suggested that the problem can be a result of mismatch between different dimensions. This seemed a logical reason but the problem was not solved even after we removed all dimension restrictions on the particular item. How would we be able to resolve this problem? Would be very grateful for some pointers. Thanks. Mikki [Non-text portions of this message have been removed] - Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are
Hi If this field is filled up then there is a BOM journal that has not been posted. If you cant see this in the form then search for the line in the database. If (you find the line) Delete this line and you should be ok else Let me know. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of futzawm Sent: 17 January 2007 18:21 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are Thanks for your response, Harry. I believe you are referring to the 'General' tab of the 'Transactions' form. Yes, there's an inventory reference (the field is 'TransChildRefId' and the Type is 'Picking List Journal'). Would that be of significance? Note that the status of the transaction is 'On order' as pointed out in my original question. Regards. Mikki --- In Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: hi Is there any inventory reference on the inventory transaction for the item? I dont have Ax in front of me right now, but this reference is I think on the second tab and the field is InventRefChildId or something similar regards harry From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of futzawm [EMAIL PROTECTED] Sent: Monday, January 15, 2007 9:23 PM To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Production closing error: Quantity ordered may not be reduced, as there are.. Please help on the following problem (I have seen similar questions in the forum but none Were resolved): We are trying to close a production order and the following error is being generated: Calculating BOM Consumption Posting - Picking list journal Journal: PJ Voucher: PV Line No: 1 Item No: 00123 Quantity ordered may not be reduced, as there are not enough stock transactions with 'on order' status. The items are 'Sold', 'Deducted' or 'Picked'. The production was started with the item in question but another item was substituted during production. Registration of the picking list journal was thus done with the item consumption = 0. There are no transactions with 'Sold', 'Deducted' or 'Picked' status for the item as referring to that particular production. However, the item transactions show a quantity equal to the original started quantity with status 'On Order' for that particular production (therefore, no reason for the error not enough stock transactions with 'On Order' status). I saw one earlier response to this type of problem by fvatne where it was suggested that the problem can be a result of mismatch between different dimensions. This seemed a logical reason but the problem was not solved even after we removed all dimension restrictions on the particular item. How would we be able to resolve this problem? Would be very grateful for some pointers. Thanks. Mikki [Non-text portions of this message have been removed]