Dear Experts, I am developing one partywise itemwise report in which I want only quantity to be fetched from sales order, delivery challan/note, credit note and sales. Means all vouchers quantity in one report for partywise itemwise report. At gate of tally we have added the Detailed Inventory Register On 24th Jan 2014 though we have entered sales order and delivery challan for the same party and item yet the quantity is not getting fetched. Request you to please go through the code and assist to solve this issue. Enclosing code and sample data.
Mr. Ganesh I think there is a problem in a collection field by key because the first thing you are fetching is Voucher No & date the same can not be in Sales Order and DN / CN because they are non accounting entries. So i would like to suggest that you should try it by deleting the Voucher No & Date. And then making a drill down / trigger in the Ledger wise Inventory Wise report. Am not sure but i think that Due to Voucher No. & Date. It gets conflict for fetching the Sales Order & DN/CN data.