Show Sales For Last Number of Days
YouTube: How to Configure Last N Days Sales Display in the Sales Order Entry Grid?
How to Configure Last N Days Sales Display in the Sales Order Entry Grid?
In this tutorial, we will learn how to display an item's recent sales quantity in the Sales Order entry screen using the Show Sales For Last Number of Days feature in Logic ERP. This feature helps users view the quantity sold during a specified number of past days, enabling more informed order planning.
Objective of This Feature
Display recent sales quantities during Sales Order entry.
Improve order planning using historical sales data.
Help users make informed stocking decisions.
Reduce the need to manually check sales reports.
Increase efficiency during order creation.
Access to Sales Order Configuration
Go to the Sales Order module.
Open Configuration.
Select the required Sales Order Configuration.
Locate the option labeled as:
"Show Sales For Last Number of Days"
Enter the required number of days.
For example: 10 Days
This means the Sales Order will display the total quantity sold for each item during the previous 10 days.
Save the configuration.
Create a New Sales Order
Click New Order to refresh the window.
Proceed with creating a new Sales Order.
If the Sale Quantity Units column is not visible:
Open Setup Column Attributes.
Enable the Sale Quantity Units column in the Item Details grid.
Observe the Functionality
Proceed to transact an item in the Sales Order.
Result
The system automatically displays the sales quantity for that item based on the number of days defined in the configuration.
For example, if 10 days are configured, the Sales Quantity column displays the total quantity sold during the last 10 days.
Verify the Sales Quantity
To verify the displayed quantity:
Open the Sales Register Detailed Report.
Filter the same item.
Generate the report for the last 10 days.
Result
As shown in the report:
The total quantity sold for the item during the last 10 days is 15 units.
The same quantity is displayed in the Sale Quantity Units column within the Sales Order entry screen, confirming that the feature is working correctly.
Key Benefits
Displays recent sales history during order entry.
Supports better inventory and replenishment planning.
Reduces the need to switch between reports and transaction screens.
Improves order accuracy.
Speeds up the sales order creation process.
Best Practice Tips
Set the number of days based on your business cycle and sales trends.
Keep the Sale Quantity Units column enabled for quick reference.
Periodically review the configured number of days to ensure it aligns with your inventory planning requirements.
Use the Sales Register Detailed Report to validate sales quantities whenever needed.
Final Outcome
After enabling Show Sales For Last Number of Days, Logic ERP automatically displays the quantity sold for each item during the specified period directly within the Sales Order entry screen. This provides users with valuable recent sales history, enabling faster, more accurate, and better-informed order creation.
Last updated