we are facing very strange issue in our production system. i will try to explain you our current scenario for Inventory. The Problem we are facing is in "Inventory Aging Query"
We have a copy of standard cube 0IC_C03 and we have done lots of customization in Z copy - ZIC_C03.
Inventory Aging Report - All Aging buckets do the calculation based on "Last GR date " which we have fetched from "Batch" . We have create "ZBATCH ( Not using standard data source) .
we have added few extra object in ZIC_C03 and we are getting those objects by writing Transformation routines. Objects like Sales Order , Item , Sold_to haven been fetched from Sales Cube into ZIC_C03. we are using SOLD_TO as a customer in Inventory queries.
Now Problem is :
Customer is a free char in query designer . without customer Inventory Aging report gives exact data. Now, when we drag customer in report it will give many negative values for quantity .Also, The final result is matching with the ECC but user does not want this negative values as in ECC the actual value is 0.