'As at' - any of the places in the system where you ask the system to calculate back in time the inventory. I personally would suggest if you are not aware of how this 'As at' works and makes use of inventtrans and inventposting records then I would not go any further with deleting them until you do understand
Also I would guess your consisitency check will be of no use as it will be throwing up a lot of errors after you have deleted Thanks James -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of satish Sent: 30 January 2007 08:56 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Inventory closing/inventory adjustment uses closed inventTrans????? Thanks James, I want to delete them. Can you explain me what do you mean by "As at" function" and why do you think it may impact the processes? Any idea might benefit me.... Thanks, Satish --- In Axapta-Knowledge-Village@yahoogroups.com, "James Flavell" <[EMAIL PROTECTED]> wrote: > > Mmm not sure but I would think the 'As at' function to calculate back in > time the onhand values might not work but I could be wrong (maybe this > function only looks at InventoryPosting records I cannot honestly > remember...do you intend to delete these?) > > James > > > -----Original Message----- > From: Axapta-Knowledge-Village@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Satish Panwar > Sent: 29 January 2007 05:37 > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: [Axapta-Knowledge-Village] Inventory closing/inventory adjustment > uses closed inventTrans????? > > Hi All, > > Let's assume i have 100 records in InventTrans table related to any of the > modules in axpata, I have done inventory closing once (month back) and that > inventory closing updated 30 records ie. inventClosing date == some value > other than 1900. > > Now i deleted those 30 records from inventTrans table, I want to run > inventory closing once again, My Questions are as follows: > a) Is there any impact of deleted records on inventory closing.? > b) Is there any other process in axapta which updates inventClosing field in > inventTrans table? > c) Is there any impact of deleted records on inventory adjustment.? > > > Thanks, > Satish > > > [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 > 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
