- If stock is increased,
- and the lot number does not exist, an entry is created in this table
- RCRDSTTUS is set to 0
- IUSCOUNT is set to 1
- and the lot number and the lot number already exists, the entry is updated
- IUSCOUNT = iuscount + 1
- If stock is decreased or transferred
- and the lot number does not exist, an entry is created in this table
- RCRDSTTUS is set to 2
- IUSCOUNT is set to 1
- and the lot number and the lot number already exists, the entry is updated
- IUSCOUNT = iuscount + 1
- IUSCOUNT represents the number of lots with the same name (it should never be negative)
Saturday, February 1, 2014
Dynamics GP - IV00301 Lot Attribute Table Explanation
Subscribe to:
Post Comments (Atom)
The IUSCOUNT seems to go negative when the an Invoice is being entered for more than the quantity available and the difference goes to backorder.
ReplyDeleteThis comment has been removed by the author.
ReplyDeletei have too many rows with IUSCOUNT -VE ., with some values up to '-286'. what should i do with these... should i change all to 1 ? rcrdsttus for all these entries are 1.
ReplyDeleteTo be safe, I would adjust all of your stock out, then adjust it back in under a different lot number and abandon those lot numbers altogether. However, there must be some underlying issue that is causing them to go negative, and this needs to be identified and dealt with, otherwise it's just going to happen again.
Deletethan you dear. will check with the inventory team.
ReplyDeletethan you dear. will check with the inventory team.
ReplyDelete