When do we select this option in SOP Setup? Is there any valid requirement that would arise so we setup SOP that on a Sales Document, Serial/Lot numbers automatically get assigned?
I am talking about *Auto-Assign Serial Numbers* and *Auto-Assign Lot Numbers* options in Sales Order Processing Options Setup window.
As a normal practice, I would always keep it unselected. I would like to make sure that I handpick items with specific serial numbers so I won’t let the system pick recent ones first and retain old ones.
Simply speaking, I would always want to sell old items first to make sure that I don’t leave it in my stock as unsold. Like a FIFO.
There are prominently two queries that arise on my mind:
1. How GP automatically takes Serial/Lot numbers for a particular item, if we select the above options? Does it follow FIFO approach or does it randomly pick some serial/lot number?
2. Is there a practical scenario where we require these options selected?
I would be grateful to receive your inputs as comments.
Thanks in advance.
Vaidy, The lot numbers can be automatically assigned by receipt date (or) expiration date (as defined in the Inventory Control Setup). If we choose to assign by Receipt Date, the automatic assignment will happen in the order of the receipt date for the lot. If we choose to assign by the expiration date, the automatic assignment will happen in the order of the expiration date (i.e.) the lot number with the nearest expiration date will be used first.In case of automatic assignment of serial numbers, it will be based on the valuation method defined for the item (FIFO or LIFO etc). Hope this helps.
Vaidy, As I had discussed with you on the phone, if an item with valuation method defined as Average Perpetual, is tracked with Serial Numbers, the serial numbers are assigned automatically in the order of the Receipt Date (FIFO) by default. You can check this from the Serials Inquiry window from Inquiry >> Inventory >> Serials.Let me know if you have any questions.
Well, that's quite clear. Unless we select Serial Numbers manually, it indeed takes S/N based on receipt date FIFO. Thank you very much for your inputs.
Np. Glad I was able to assist. 🙂