Is there a utility or easy way to build a report for unit sales volumes by general product posting groups?
*This post is locked for comments
Is there a utility or easy way to build a report for unit sales volumes by general product posting groups?
*This post is locked for comments
The needed information is presented in Value Entry table (5802). You can drill down to Value Entries from the item card and clear all filters (alternatively, run table 5802 if you have access to development environment). There you can filter date range, type of operation (Item Ledger Entry Type = Sales), and select needed General Product Posting Group. You can export this data to Excel and buildup a Pivot Table by General Product Posting Group.
Alternatively, you can design a simple report with the same logic.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156