Inventory Balance Details

[former_member621217]

Hello All,

We're using the Inventory Balance Details report to see material transactions. However instead of seeing a list of all the transactions, we would like to see just the last transaction of a specific type. For example we would like to see the last goods receipt date for a material. We would also like to see the last Consumption date for a material.

Any suggestions on how we can go about seeing 'latest date' for a transaction type in Business Analytics ?

Thanks,

Kevin.

[former_member497128]

Dear kevindward,

If we have date as key figure then such requirements (find the details as per latest date) can be fulfilled easily (by creating and using ranked conditions) but in this case, date (for example: Actual Execution On) is a characteristic, so we have to first change it to key figure which can be only done via SDK.

You can check below KBA and your implementation partner
2579377 - Cannot use Characteristic to Create Calculated Key Figure

Regards,

Saurav Kumar