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/arp/sponsoredsearch_v2.php [Non-text portions of this message have been removed]
