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
Last updated