Skip to Content
0
Jan 26, 2011 at 10:50 AM

How to prepare Raw metarials item wise purchase register

77 Views

Hi,

I need your assistance regarding for generate of this purchase register report.

please check link below where i upload xls file of my report.

http://www.sendspace.com/file/4bmse5

For making this report all data will come from Vendor info, GRPO info. or OINM table

Remember, when i put any date range, it will show Opening Qty and OP Value which one was the Closing Qty and value for last date.

like put the date range 01-10-2010 and 31-10-2010 and itemname ABC it will show 30-09-2010 closing QTY and value

for 01-10-2010 Opening QTY and Value

Please help me about this report.

Regards,

Mizan

Edited by: mizan700 on Jan 26, 2011 4:56 PM