how to get opening stock for all items from given date range in XL reporter

[Former Member]

Hi All,

In XL Reporter i want to create report for seeing opening balance of item, item produced, item sold per day for date range

INPUT:item code range, date range

OUTPUT

Opening stock- previous date closing stock

produced item- produced from production order

sold item- Inventory transfer to another warehouse

all the three affect the instock,is there any opening stock table for items for each day

how to prepare this report

Regards

Krish

[wilma_wang · Accepted solution]

Hello Krish,

OITW fields are not yet avaiable in the XL Reporter standard modules.

If you need to retrieve stock information from OITW table, you'll need

to use the ixGetData formula.

This function can be found after you enter Excel from XL Reporter and

go to XL Reporter Toolbar -> Formula Builder (the last icon) ->

Functions Tab -> Other -> Get Other data.

Regards,

Wilma Wang

SAP Business One Forums Team