Hi I am going on leave, may not check my emails, so I will lay out the possible scenarios.
If clearing these fields does not solve the problem then please recheck if you have cleared the correct inventtrans record(s). If it still does NOT solve the problem then I am not sure as to why you are facing the problem. If it solves the problem then 1. The root cause of your problem is that if a journal is deleted from the header record then it misses a line or two. (I am guessing that you are using 3 tier). To be very honest, this is not a problem with Ax. My best guess is that your hardware and/or aos and/or sql server setup is not optimal. You should log and resolve this issue thru official Microsoft support 2. I would recommend putting a restrict delete action on production journal header table asap. This means users will be forced to go to the line to delete the journal. This will prevent this issue from happening till you resolve your problem. 3. It is up to you whether to clear these fields in the live system, (so that the current problematic production orders can be closed). You will have to make a complete check to make sure nothing else is going to get affected. 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 Harry Deshpande Sent: 23 January 2007 22:15 To: Axapta-Knowledge-Village@yahoogroups.com Subject: 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<mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED]<mailto:Axapta-Knowledge-Village%40yahoogroups.com>] On Behalf Of futzawm [EMAIL PROTECTED]<mailto:futzawm%40yahoo.com>] Sent: Tuesday, January 23, 2007 8:49 PM To: Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.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.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto: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.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 futzawm > Sent: 22 January 2007 18:33 > To: > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto: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.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto: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.com<mailto:Axapta-Knowledge-Village%40yahoogroups.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><mailto:Axapta-Knowledge-Village%40yahoogroups.com>] On Behalf Of futzawm > > Sent: 17 January 2007 18:21 > > To: Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto: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.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto: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.com<mailto:Axapta-Knowledge-Village%40yahoogroups.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><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.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto:Axapta-Knowledge-Village%40yahoogroups.com><mailto: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: PJXXXX > > > Voucher: PVyyyy > > > 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] > > > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]
