Show Sale for Last No of Days

YouTube: How to Show Sales for the Last Defined Number of Days in Purchase Orders?

How to Show Sales for the Last Defined Number of Days in Purchase Orders?

This tutorial explains how to display Sales Quantity for the last defined number of days directly in the Purchase Order screen in Logic ERP. This feature helps users make data-driven purchasing decisions by showing recent sales trends during order creation.

---

Objective of This Feature

• View recent sales quantity while creating Purchase Orders

• Improve purchase planning based on demand

• Reduce overstocking and understocking

• Enable quick decision-making

---

Access to the Configuration

• Open Configuration Window

• Navigate to General Options

• Locate and enable the option labeled as:

“Show Sale for Last No. of Days”

Define Sale Days

• Enter the number of days (e.g., 15 days)

• This defines:

  • Sales data period to be displayed in Purchase Order

• Click OK to apply changes

---

Add Sales Quantity Column

• Open Purchase Order Window

• Go to Column Attributes

• Select and enable:

  • Sale Quantity (Packs)

---

Implement Purchase Order

• Start a New Purchase Order

• Enter item details

System Behavior

• Displays Sales Quantity in the column

• Based on the defined number of days

---

Verify Sales Data

• Navigate to Reports/Queries → Sales Register (Detailed)

Apply Filters

• Select:

  • Same Item

  • Same Date Range (e.g., last 15 days)

Validation

• Compare:

  • Sales Report Quantity

  • Purchase Order displayed quantity

---

Key Benefits

• Enables smart purchasing decisions

• Provides real-time sales insights

• Reduces dependency on manual report checking

• Improves inventory planning accuracy

---

Best Practice Tips

• Use realistic sales period (7 / 15 / 30 days)

• Combine with stock reports for better planning

• Regularly verify sales data accuracy

---

Final Outcome

• Sales quantity is visible during Purchase Order entry

• Purchase decisions become data-driven

• Inventory levels are better optimized

• Workflow becomes faster and more efficient