Facility to Create Purchase Orders on Stock Level and Formula Basis
Last updated
Last updated
YouTube:
In inventory management, timing is everything⏱️. Placing orders too late can lead to stockouts, while ordering too early can tie up capital in excess stock. Reorder Levels (ROL) provide an effective solution by allowing businesses to automate the purchase order process based on inventory thresholds📉📦.
This guide walks you through the entire setup—right from defining reorder levels to generating purchase orders automatically. The process ensures your inventory stays at optimal levels🎯without constant manual tracking.
A Reorder Level (ROL) is a predefined quantity set for an item in stock. When the stock quantity falls to or below this level, the system triggers the need to reorder📉🔔.
It acts as a buffer, helping your business maintain continuity in operations and customer satisfaction😊.
🧠 Example: If the Reorder Level is set at 600 units, and current stock is 294 units, the system will automatically calculate and generate a Purchase Order for the remaining 306 units.
📁Navigate to the Main menu, click on Setup, then expand Setup items, and click on Setup Item Multiple Pack/Sizes.
🧾Select the desired Item.
📦Open the Pack Size Details tab.
🔢Find the field labeled Order Level.
✍️Enter the appropriate Reorder Level quantity based on historical sales, lead time, and safety stock.
💾Click Save.
💡 Tip: Set ROLs based on average consumption and supplier lead times for best results.
📌Proper supplier linkage is essential to ensure that the purchase orders are directed to the correct source👨💼🏢.
✅ Link Supplier with the Company
Go to: Setup, then expand Party wise Settings and select Supplier + Companies option.
👤Choose the relevant Supplier.
🏷️Select the Brand/Company the supplier provides.
💾Click Save.
✅ Link Supplier with Specific Items
Go to: Setup, then expand Party wise Settings and select Supplier + Items option.
👤Choose the Supplier Name.
📦Select the Item(s) you wish to associate with that supplier.
💾Click Save.
🔄 This mapping ensures that when an item’s stock hits its reorder level, the system knows which supplier to contact.
🛒Go to: Order Processing and click on Purchase Order Stock Level Basis option.
📦Choose the order generation type:
Item-wise – if you want to create orders for specific items.
Supplier-wise – to batch items together by supplier.
👤Select the Supplier from the dropdown.
🏬Choose the relevant Godown (warehouse).
⚙️Click Generate Order.
📊 The system calculates the quantity needed based on the reorder level and current stock. If ROL = 600, and current stock = 294, the system suggests ordering 306 units.
🧐Review the order.
💾Click Save Order to confirm✅ and initiate the purchase process.
If you'd rather base your orders on maximum stock levels instead of reorder levels, follow these steps:
📁Go to: Configuration and then select Other Settings
🔧Choose the logic for Purchase Order Quantity Calculation:
🟢Reorder Level.
🟣Maximum Stock Level.
⚙️Other custom-defined criteria (if available)
💾Save your settings.
⚙️ This flexibility allows businesses to tailor ordering behavior based on their inventory strategies🎯.
Reorder Level
600 units
Current Inventory
294 units
Required Quantity
306 units
Supplier
ABC Distributors
Godown
Main Warehouse
✅ System auto-generates a Purchase Order for 306 units from ABC Distributors for the Main Warehouse.
🧠Automated stock monitoring.
❌Prevents stockouts.
🛒Streamlines purchase order generation.
🧾Reduces manual errors.
⏱️Saves time and 📈boosts procurement efficiency.
By setting reorder levels and linking suppliers accurately, your business gains a powerful, automated inventory control mechanism🛠️in Logic ERP. This ensures that stock is replenished at the right time and in the right quantity, supporting uninterrupted operations.
Keep your shelves stocked, orders flowing, and customers happy—all while optimizing your working capital 💡📊.