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

How to prepare Raw metarials item wise purchase register



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

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

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.



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