Notifications
Announcements
No record found.
Hi All,
How to identify where is the huge sales.
1. Under which warehouse huge sales are coming.
2. What kind of products are selling
How can i know these things.
Regards,
Srinivas
*This post is locked for comments
SalesTable has a Warehouse field, maybe you could count the RecId while grouping on the inventory location id. That will tell you the volume of sales orders raised per warehouse.
The answer for your second question lies in SalesLine, counting RecId groupped by ItemId.
These information could be easily pulled in an X++ job, or even in the Table Browser.
Hi vaasu,
An alternative for identifying is to start from the ledger voucher. If you drill down to the original document that caused the large sales, the respective sales order will open and allow you to analyze the warehouse and products sold.
Best regards,
Ludwig
There is a sales cube
There are item and customer statistics inquiry screens
There is a top 10 customer report
Use the use the Sales order report for a list of sales orders sorted by customer by order total -you can always open that in Excel for analysis
Similarly there is an open sales order line Inuiry, under Sales and marketing - Ctrl-F3 and change the query to invoiced orders rather than open orders then dump the results to Excel
etc etc.
.........
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
