Comments on Profile Post by Nitin Kumar

I am not getting your query

SIr, I want to fetch stockitem details like stockitemname, rate, amount, and consumption using odbc by creating collection. but I am not able to fetch consumption along with rate amount and bill quantity.

how do I fetch consumption??

[#Collection : StockItem]
Type : Voucher
IsODBCTable : Yes


[Collection : DailyBook]
Source Collection : StockItem
Walk : AllInventoryEntries

IsODBCTable : Yes
Fetch : Date, VoucherNumber, VoucherTypeName, PartyLedgerName,StockItemName, BilledQty, Rate, Amount, Consumption

In the above collection I am able to fetch all details except consumption. How do I fetch That one??