Good Morning @Maria Frandzeskakis,I have often used the script below to achieve what you're asking about. It is not limited to just sales though. It identifies what the consumption point was regardless of origin (i.e. inventory adjustments, assemblies, returns, etc.)https://community.dynamics.com/gp/b/dynamicsgpessentials/posts/cost-layers-analysis-sql-scriptYou may need to tweak it to meet your needs, but it is a good starting point.
If you've found this thread useful, dive deeper into User Group community content by role