Re: [Axapta-Knowledge-Village] Remainder cost value on warehouse
Before change, The client was using weighted avg. per warehouse/batch number. After change, The client now uses weighted avg date. per warehouse/serial number. The batch number dimension is discontinued. The stock was cleared out on the 01/05/2006 and brought back in on the same day, A stock close was not done until the end of the month. Not running a stock close after removing the stock have caused the problem? How do we correct the values? The newer transactions are matched correctly and do not have any values on them. The reason why they switched inventory model groups is because the adjustments were too large and unexplainable.The intial setup was incorrect. After the changes to the setup were made things are looking much better. The open values on the old transactions however needs to be cleared. Thanks again for all your help - Original Message From: James Flavell [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, February 9, 2007 4:28:52 PM Subject: RE: [Axapta-Knowledge-Village] Remainder cost value on warehouse Without knowing what the BEFORE and AFTER setting are it is not really possible to say how to fix. Before used batch, after still used batch but added serial number? OR batch number longer used/active? To be honest you say you cleared out the stock with a stock journal and then brought in new stock with serial number. I assume you did an inventory close in between doing these two steps right? Maybe you can post the exact steps you did plus the dimension settings before and after, e.g. 1) Clear out stock 2) Closing 3) Deactivate batch dimension 4) Enable serial 5) Bring in stock I think your stock was not cleared out (could be due to several reasons) but it could be something else also...need more info -Original Message- From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Anisha Fakir Sent: 09 February 2007 18:55 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: Re: [Axapta-Knowledge- Village] Remainder cost value on warehouse One more thing, the value is sitting on the old transactions. The transactions with the batch numbers. After the setup changes occurred this issue does not appear on the serial transactions. How do I get rid of the values on the old transactions? Regards, Anisha - Original Message From: James Flavell [EMAIL PROTECTED] com To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Friday, February 9, 2007 12:04:38 PM Subject: RE: [Axapta-Knowledge- Village] Remainder cost value on warehouse What were you inventory dimensions settings before (batch) and after (with serial) Things like 'Physical invent' and 'Financial Invent'. Also 'Allow blank' You model is Avg? FIFO? Did you take out all the stock when you switched to serial number? Or did you edit dimensions and add serial number to existing transactions? Or did you just leave transaction with blank serial? Thanks James -Original Message- From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of anishafakir1 Sent: 09 February 2007 17:52 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: [Axapta-Knowledge- Village] Remainder cost value on warehouse Hi, Can anyone please help in providing a workaround in solving this problem, The scenario, An item was initially set up to use batch numbers. Many transactions and inventory closings were made against this item. Months later the item's dimension is changed to use serial numbers, hence the batch number functionality is turned off. Transactions are then made against this item (with serial number). When an inventory close is done, the item has a cost value with no quantity. This is shown on the Physical inventory by inventory dimension report. How can we remove this value? We tried to do an inventory adjustment but the inventory closing reverse's the value back. Any ideas? Thanking you in advance. Sharing the knowledge on Axapta. Visit www.frappr.com/ axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledg e-village. tk Yahoo! Groups Links _ _ _ _ _ _ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo. com/collections/ 265 [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/ axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledg e-village. tk Yahoo! Groups Links The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com
RE: [Axapta-Knowledge-Village] Remainder cost value on warehouse
What were you inventory dimensions settings before (batch) and after (with serial) Things like 'Physical invent' and 'Financial Invent'. Also 'Allow blank' You model is Avg? FIFO? Did you take out all the stock when you switched to serial number? Or did you edit dimensions and add serial number to existing transactions? Or did you just leave transaction with blank serial? Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of anishafakir1 Sent: 09 February 2007 17:52 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Remainder cost value on warehouse Hi, Can anyone please help in providing a workaround in solving this problem, The scenario, An item was initially set up to use batch numbers. Many transactions and inventory closings were made against this item. Months later the item's dimension is changed to use serial numbers, hence the batch number functionality is turned off. Transactions are then made against this item (with serial number). When an inventory close is done, the item has a cost value with no quantity. This is shown on the Physical inventory by inventory dimension report. How can we remove this value? We tried to do an inventory adjustment but the inventory closing reverse's the value back. Any ideas? Thanking you in advance. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links
Re: [Axapta-Knowledge-Village] Remainder cost value on warehouse
One more thing, the value is sitting on the old transactions. The transactions with the batch numbers. After the setup changes occurred this issue does not appear on the serial transactions. How do I get rid of the values on the old transactions? Regards, Anisha - Original Message From: James Flavell [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, February 9, 2007 12:04:38 PM Subject: RE: [Axapta-Knowledge-Village] Remainder cost value on warehouse What were you inventory dimensions settings before (batch) and after (with serial) Things like 'Physical invent' and 'Financial Invent'. Also 'Allow blank' You model is Avg? FIFO? Did you take out all the stock when you switched to serial number? Or did you edit dimensions and add serial number to existing transactions? Or did you just leave transaction with blank serial? Thanks James -Original Message- From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of anishafakir1 Sent: 09 February 2007 17:52 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: [Axapta-Knowledge- Village] Remainder cost value on warehouse Hi, Can anyone please help in providing a workaround in solving this problem, The scenario, An item was initially set up to use batch numbers. Many transactions and inventory closings were made against this item. Months later the item's dimension is changed to use serial numbers, hence the batch number functionality is turned off. Transactions are then made against this item (with serial number). When an inventory close is done, the item has a cost value with no quantity. This is shown on the Physical inventory by inventory dimension report. How can we remove this value? We tried to do an inventory adjustment but the inventory closing reverse's the value back. Any ideas? Thanking you in advance. Sharing the knowledge on Axapta. Visit www.frappr.com/ axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledg e-village. tk Yahoo! Groups Links We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265 [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Remainder cost value on warehouse
You must have inconsistency on the old transactions. If you want to have inventory closing close out the old transaction with the new method you have, they have to have same serialnumber - or at least same enough to be able to settle them in pairs. So my guess is that your old transactions issue and receipt holds different serial numbers. You have to trace them down and fix them to be able to close out the old remaining values. You should be able to find the old transactions causing the trouble, because they shouldn't be closed out (you can see this on the inventory transactions). Now I'm not a developer so I can only tell you, that you can manipulate the dimensions on individual inventory transactions from the inventory dimension editor on the item. If you have several 1000 and serial number wasn't used for any valid purpose on the old transactions you could choose to make a job, that simply clear the serial number on any of the old transactions. [cid:image001.jpg@01C74C52.FAC87960] Karina Normann Jakobsen Program Manager Microsoft Dynamics AX Microsoft Corporation From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Anisha Fakir Sent: 9. februar 2007 11:55 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Remainder cost value on warehouse One more thing, the value is sitting on the old transactions. The transactions with the batch numbers. After the setup changes occurred this issue does not appear on the serial transactions. How do I get rid of the values on the old transactions? Regards, Anisha - Original Message From: James Flavell [EMAIL PROTECTED]mailto:djf%40columbusindo.com To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Sent: Friday, February 9, 2007 12:04:38 PM Subject: RE: [Axapta-Knowledge-Village] Remainder cost value on warehouse What were you inventory dimensions settings before (batch) and after (with serial) Things like 'Physical invent' and 'Financial Invent'. Also 'Allow blank' You model is Avg? FIFO? Did you take out all the stock when you switched to serial number? Or did you edit dimensions and add serial number to existing transactions? Or did you just leave transaction with blank serial? Thanks James -Original Message- From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of anishafakir1 Sent: 09 February 2007 17:52 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: [Axapta-Knowledge- Village] Remainder cost value on warehouse Hi, Can anyone please help in providing a workaround in solving this problem, The scenario, An item was initially set up to use batch numbers. Many transactions and inventory closings were made against this item. Months later the item's dimension is changed to use serial numbers, hence the batch number functionality is turned off. Transactions are then made against this item (with serial number). When an inventory close is done, the item has a cost value with no quantity. This is shown on the Physical inventory by inventory dimension report. How can we remove this value? We tried to do an inventory adjustment but the inventory closing reverse's the value back. Any ideas? Thanking you in advance. Sharing the knowledge on Axapta. Visit www.frappr.com/ axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledg e-village. tk Yahoo! Groups Links __ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Remainder cost value on warehouse
Hi, What version / release of AX check out for the Hot fix... there is a procedure out on MBS website for fixing On hand value when Qty = 0. Hemant - Original Message From: Karina Normann Jakobsen [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, February 9, 2007 7:02:48 AM Subject: RE: [Axapta-Knowledge-Village] Remainder cost value on warehouse You must have inconsistency on the old transactions. If you want to have inventory closing close out the old transaction with the new method you have, they have to have same serialnumber - or at least same enough to be able to settle them in pairs. So my guess is that your old transactions issue and receipt holds different serial numbers. You have to trace them down and fix them to be able to close out the old remaining values. You should be able to find the old transactions causing the trouble, because they shouldn't be closed out (you can see this on the inventory transactions) . Now I'm not a developer so I can only tell you, that you can manipulate the dimensions on individual inventory transactions from the inventory dimension editor on the item. If you have several 1000 and serial number wasn't used for any valid purpose on the old transactions you could choose to make a job, that simply clear the serial number on any of the old transactions. [cid:image001.jpg@ 01C74C52. FAC87960] Karina Normann Jakobsen Program Manager Microsoft Dynamics AX Microsoft Corporation From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Anisha Fakir Sent: 9. februar 2007 11:55 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: Re: [Axapta-Knowledge- Village] Remainder cost value on warehouse One more thing, the value is sitting on the old transactions. The transactions with the batch numbers. After the setup changes occurred this issue does not appear on the serial transactions. How do I get rid of the values on the old transactions? Regards, Anisha - Original Message From: James Flavell [EMAIL PROTECTED] commailto:djf% 40columbusindo. com To: Axapta-Knowledge- [EMAIL PROTECTED] ups.commailto:Axapta- Knowledge- Village%40yahoog roups.com Sent: Friday, February 9, 2007 12:04:38 PM Subject: RE: [Axapta-Knowledge- Village] Remainder cost value on warehouse What were you inventory dimensions settings before (batch) and after (with serial) Things like 'Physical invent' and 'Financial Invent'. Also 'Allow blank' You model is Avg? FIFO? Did you take out all the stock when you switched to serial number? Or did you edit dimensions and add serial number to existing transactions? Or did you just leave transaction with blank serial? Thanks James -Original Message- From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of anishafakir1 Sent: 09 February 2007 17:52 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: [Axapta-Knowledge- Village] Remainder cost value on warehouse Hi, Can anyone please help in providing a workaround in solving this problem, The scenario, An item was initially set up to use batch numbers. Many transactions and inventory closings were made against this item. Months later the item's dimension is changed to use serial numbers, hence the batch number functionality is turned off. Transactions are then made against this item (with serial number). When an inventory close is done, the item has a cost value with no quantity. This is shown on the Physical inventory by inventory dimension report. How can we remove this value? We tried to do an inventory adjustment but the inventory closing reverse's the value back. Any ideas? Thanking you in advance. Sharing the knowledge on Axapta. Visit www.frappr.com/ axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledg e-village. tk Yahoo! Groups Links _ _ _ _ _ _ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo. com/collections/ 265 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Remainder cost value on warehouse
Without knowing what the BEFORE and AFTER setting are it is not really possible to say how to fix. Before used batch, after still used batch but added serial number? OR batch number longer used/active? To be honest you say you cleared out the stock with a stock journal and then brought in new stock with serial number. I assume you did an inventory close in between doing these two steps right? Maybe you can post the exact steps you did plus the dimension settings before and after, e.g. 1) Clear out stock 2) Closing 3) Deactivate batch dimension 4) Enable serial 5) Bring in stock I think your stock was not cleared out (could be due to several reasons) but it could be something else also...need more info -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Anisha Fakir Sent: 09 February 2007 18:55 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Remainder cost value on warehouse One more thing, the value is sitting on the old transactions. The transactions with the batch numbers. After the setup changes occurred this issue does not appear on the serial transactions. How do I get rid of the values on the old transactions? Regards, Anisha - Original Message From: James Flavell [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, February 9, 2007 12:04:38 PM Subject: RE: [Axapta-Knowledge-Village] Remainder cost value on warehouse What were you inventory dimensions settings before (batch) and after (with serial) Things like 'Physical invent' and 'Financial Invent'. Also 'Allow blank' You model is Avg? FIFO? Did you take out all the stock when you switched to serial number? Or did you edit dimensions and add serial number to existing transactions? Or did you just leave transaction with blank serial? Thanks James -Original Message- From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of anishafakir1 Sent: 09 February 2007 17:52 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: [Axapta-Knowledge- Village] Remainder cost value on warehouse Hi, Can anyone please help in providing a workaround in solving this problem, The scenario, An item was initially set up to use batch numbers. Many transactions and inventory closings were made against this item. Months later the item's dimension is changed to use serial numbers, hence the batch number functionality is turned off. Transactions are then made against this item (with serial number). When an inventory close is done, the item has a cost value with no quantity. This is shown on the Physical inventory by inventory dimension report. How can we remove this value? We tried to do an inventory adjustment but the inventory closing reverse's the value back. Any ideas? Thanking you in advance. Sharing the knowledge on Axapta. Visit www.frappr.com/ axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledg e-village. tk Yahoo! Groups Links We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265 [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links
