Hello,

I'm trying to export the history tab of Item Inquiry window (see above) to excel sheet for reporting purpose. I created query which pulls data from the table of IM_PeriodPostingHistory. However, the beginning quantity of each month shows 0 except for Jan. I can do calculation in excel using the field of PeriodChangeQty to get the beginning quantity and ending quantity of following months. I'm wondering if there's a reason why the query result shows beginning quantity of 0 for months of Feb to Dec, and if I can fix it so there's no need for additional calculation in excel.

(query result in Excel)

(same item reported in Item Inquiry window)

Thanks!