From: Jesse P. <jes...@st...> - 2004-04-15 05:14:05
|
When a Serialised Item has a Reverse GRN processed, here are the options = I've come up with: Under both ways:=20 + all existing code is executed. + Additional conditions must be met=20 =3D> can only reverse GRN for stock that has not been sold (ie, current = StockMove for item cannot be Invoice type).=20 =3D> item must have been received against the PO we are reversing = pieces of =3D> any conditions a specialised stock module checks + Delete records from Item-specific tables (only affects you if you have = specialised stock modules) then, either: 1) Change/Invalidate SerialNo in StockItems Records. a) Change Serial in All affected StockItem records to something bogus = like 'XXXXXXXX' or just '' b) Update StockItems w/ new StockMove No. for each. c) Create StockItemMove for tracking (StockItemNo, OldStockMoveNo, = New/Eff StockMoveNo) 2) Delete Item history a) Delete records from StockItems c) Delete StockItemMoves I'm keen on using the second method b/c it creates a lesser chance for = problems in the future if the Items being reversed are actually received = later on. I figure at face value most would balk since I'm deleting, but = I really don't see much point in maintaining these records. Thoughts from others? Am I missing something or forgetting about = something? |