Stock Out Validation
YouTube: How to Validate Stock Out Using FIFO by Expiry or Purchase Date in Sale Bill?
How to Validate Stock Out Using FIFO by Expiry or Purchase Date in Sale Bill?
In this tutorial, we'll walk you through the Stock Out Validation feature in Logic ERP. This feature helps ensure proper inventory control by validating the order in which stock lots are selected during billing or stock issuance, based on expiry or purchase dates.
Accessing Stock Out Validation Settings
Open Sale Voucher Configuration.
Select the relevant Billing Series.
Select Other Settings 3.
Locate the option titled "Stock Out Validation".

This setting provides three parameters:
None
FIFO on Lot Expiry
FIFO on Lot Purchase Date
Stock Out Validation: None
Behavior: No validation is applied.
Effect During Billing:
The user is free to select any available lot, regardless of expiry or purchase date.
No prompts or warnings are displayed.
Example:
An item has multiple lots with different expiry dates.
The user can choose any lot — even one with a later expiry date — without any system alerts.
Stock Out Validation: FIFO on Lot Expiry
Behavior: Enforces First-In-First-Out (FIFO) logic based on lot expiry dates.
Purpose: To ensure that stock with the earliest expiry is billed first.
Effect During Billing:
If the user selects a lot with a later expiry date, while an earlier one is available:
The software will display an error message.
It will also show details of the earlier expiring lot.

Example:
Two lots available:
Lot A: Expiry – 10/08/2025
Lot B: Expiry – 05/08/2025
If Lot A is selected, the system prompts:
“A lot with an earlier expiry date is available: Lot B (05/08/2025)”
Stock Out Validation: FIFO on Lot Purchase Date
Behavior: Enforces FIFO based on purchase date of the lot.
Purpose: To ensure that stock purchased earlier is used first, avoiding stock holding issues.
Effect During Billing:
If the user selects a lot with a later purchase date, while an earlier one is available:
The software will show an error message.
It will also display details of the older purchased lot.

Example:
Two lots available:
Lot A: Purchased – 01/07/2025
Lot B: Purchased – 15/07/2025
If Lot B is selected, the system alerts:
“A lot with an earlier purchase date is available: Lot A (01/07/2025)”
Summary of Stock Out Validation Modes
None
No validation
Any lot can be selected; no system prompt
FIFO on Lot Expiry
Expiry Date
Prompts if a later-expiry lot is selected over an earlier one
FIFO on Lot Purchase Date
Purchase Date
Prompts if a later-purchased lot is selected over an earlier one
Best Practices
Use FIFO on Expiry for perishable goods or pharmaceuticals.
Use FIFO on Purchase Date for general inventory rotation.
Keep your lot information accurate to get the best results from this feature.
Last updated