Order Quantity Formula

YouTube: How to Set Up Formula- Based Order Quantity in Purchase Orders?

How to Set Up Formula- Based Order Quantity in Purchase Orders?

This tutorial explains how to automatically calculate and add item quantities in a Purchase Order using an Order Quantity Formula in Logic ERP. This feature helps in making smarter purchasing decisions based on sales and stock data.

---

Objective of This Feature

• Automate purchase quantity calculation

• Base ordering on sales performance and stock levels

• Reduce manual calculations and errors

• Improve inventory planning and control

---

Define Order Quantity Formula

• Open Configuration Window

• Go to Other Settings

• Click on Order Quantity Formula

Create Formula

• Use Field List Option to view available fields

• Define formula based on:

  • Sales Quantity

  • Closing Stock

  • Other relevant parameters

• Click OK after defining the formula

---

Review Stock & Sales Data

• Generate Stock Query Report

Analyze Key Data

• Review:

  • Sales Quantity

  • Closing Stock

Purpose

• Whether ordering is required

• Approximate quantity needed

---

Create Purchase Order

• Open Purchase Order Window

• Enter Supplier Name

Go to Item Details

• Navigate to Item Details Section

Add Items Using Formula

• Click on Add Items on Formula

• Search and choose the item to be ordered

Define Parameters

• Enter:

  • Date Range (for sales calculation)

  • Godowns (for stock consideration)

---

Automatic Quantity Calculation

• Based on the defined formula:

  • System calculates required order quantity

Result

• Displays:

  • Auto-calculated Order Quantity

---

Key Benefits

• Eliminates manual quantity calculation

• Ensures accurate and data-driven ordering

• Prevents overstocking and stock shortages

• Enhances inventory efficiency

---

Best Practice Tips

• Define formula carefully based on business logic

• Always review stock reports before ordering

• Use appropriate date ranges for accurate results

---

Final Outcome

• Purchase quantities are automatically calculated

• Orders are based on actual sales and stock data

• Inventory management becomes smarter and more efficient

• Decision-making becomes data-driven and reliable