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.com<mailto: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]