[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, 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:[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 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.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
[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, 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]
[Axapta-Knowledge-Village] Re: Cancel Reservations Generated by Production Orders
Thanks, Markus, please be here always:-)! If you mean the picking list which reserved the item in the first place, yes those picking lists are open. And it is those reserved items that I want to release. I do not want to (or let's say can't) delete the picking list (or the picking list line) for that specific production, I just want it to release the items that it has automatically grabbed and wait for its turn, so to speak. I have changed the parameters so as to prevent automatic reservation in the future but the problem is what should we do for the items already reserved? I tried to remove the reservation from the picking list line as you suggested but the result is exactly the same--i.e., the reservations form comes up but with no figures in the 'Reservations' field and so no possibility of deleting the reservation. I also read somewhere that one possible solution is to reverse the status of the production back to 'Created' but that sounds to me as an extreme type of a solution. Surely there's a simpler way of removing reservations of the kind I mention? Thanks a lot again Markus, I do appreciate your help. Mikki --- In Axapta-Knowledge-Village@yahoogroups.com, markusotte2 [EMAIL PROTECTED] wrote: Hi. It's me again! Probably there are opened picking lists for the items? Then the reservations are tranfered from the ProdBOM to the picking list. You habe to delete the picking list or remove the reservation from the picking list line. Cheers! Markus --- In Axapta-Knowledge-Village@yahoogroups.com, futzawm futzawm@ wrote: Hi all. We have reservations on some items generated by production orders. We wanted to cancel these reservations through the method outlined in the manual (Item--Transactions--Select line with Reserved Physical--[button]Inventory--Reservation: and try to change/cancel the Reservation field). However, this field comes up empty in some cases (even though there's a quantity reserved on the item as can be viewed in the transactions form) and so no changes can be made (negative quantities are not allowed in the field). How can one release/cancel the reservation in such a case? A related question: why is it that in some cases it is possible to see (and thus edit) the reserved quantity and in other cases not? We have AX3.0 SP3. I would greatly appreciate any help in this matter! Thanks. Mikki
[Axapta-Knowledge-Village] Re: Inventory Issue and Receipt cost problems
Thank you very much for your response, Markus, and your effort to help. Sorry for not having responded immediately, I was not able to. I am including below the settings you asked for. However, I have also noted that sometimes, the cost distributes correctly as you state although I have not been able to discover why only sometimes. Would greatly appreciate your help in identifying why. Thanks again! Mikki Number Groups: General Tab: Allocation Group: Only for inventory transactions: Checked (allows for multiple number per purchases, etc.); On physical update: Checked Activations Tab: Purchase Activation: Checked; Order Activation: Not Checked; Inventory Activation: Checked Inventory Model Group: Setup Tab: Ledger integration: Register financial inventory; Physical Udate: both parameters are not selected. Inventory Dimension Group: General Tab: Serial number control: checked; Blank receipt/issue allowed: not checked; Physical/Financial inventory: not checked --- In Axapta-Knowledge-Village@yahoogroups.com, markusotte2 [EMAIL PROTECTED] wrote: Hi. I tried to reproduce your problem, but I could 't achieve. So I need all settings: -Inventory model group, Setup -Dimension group, Serial number, General -Serial number group, on physical update? In my example the first packing slip distributed the physical cost equally to each serial numbered item (Transactions, Tab:Update, Physical cost amount), as you required. Cheers! Markus --- In Axapta-Knowledge-Village@yahoogroups.com, futzawm futzawm@ wrote: Hello, I am stuck on a problem that I hope someone will help me solve. (I posted this on the Dynamics AX community site but unfortunately no one has replied). (I am using AX 3.0 Sp3) We have an item which requires serial numbers. The serial number group parameters were setup for Only for stock transactions and Purchase Activation (automatic generation of serial numbers). The dimension group the item was assigned to had serial numbers as primary stocking. I noticed that if the items arrive in groups (of 2 or 3, say from an original order of 20), then updating the packing slip (delivery note) will assign the physical cost to the first item (and not distribute it equally to each serial numbered item). This in itself would not have been a problem since (I assume) recalculation after financial posting would correct the costs or, one can use the adjustment form to do the same. The problem arose when (let's say due to a rush on the order) Shipping somehow generated an invoice for partial shipment without first creating and posting the packing slip. The shipped items (per each S/N) now show as having a financial cost on the On-hand form (but 0 quantity). Transactions on the item have an amount on the 'Cost Amount' field for the receipt (Purchased) transaction but nothing on the corresponding issue (Sold) transaction (to offset, I believe). An inventory close has been made since those transactions but the period was not closed. How does one correct this? Recalculations do not do it and I also was not able to get the transactions to adjust (Closing and Adjustment -- Adjust -- Transactions -- Select: Item number and all other selection criteria as well--the form comes up empty). I would greatly appreciate for some help on how one goes about rectifying this situation. A related question is, was this situation really caused by shipping not generating a delivery note before posting an invoice? (I assumed that AX automatically completes previous steps if not explicitly performed). Thanks a lot! Mikki
[Axapta-Knowledge-Village] Cancel Reservations Generated by Production Orders
Hi all. We have reservations on some items generated by production orders. We wanted to cancel these reservations through the method outlined in the manual (Item--Transactions--Select line with Reserved Physical--[button]Inventory--Reservation: and try to change/cancel the Reservation field). However, this field comes up empty in some cases (even though there's a quantity reserved on the item as can be viewed in the transactions form) and so no changes can be made (negative quantities are not allowed in the field). How can one release/cancel the reservation in such a case? A related question: why is it that in some cases it is possible to see (and thus edit) the reserved quantity and in other cases not? We have AX3.0 SP3. I would greatly appreciate any help in this matter! Thanks. Mikki