Skip to Content
0
Former Member
Oct 27, 2015 at 06:58 AM

QUERY FOR INVENTORY OPENING AND CLOSING ON HANA

316 Views

Hi All

Can any one give me a query on HANA for Inventory with Opening and Closing balance ??

I need these fields

1) Item Code

2) Description

3) Average Cost

3) Opening Balance

4) Purchase

5) Purchase return

6) Closing balance

Parameter should be Date range , Item group, Warehouse, Item wise,