hi gary, yes the i manage to make the code works. the data result when displayed to grid is also identical to the screenshot post #6. but im having issue how to make running balance for each item. again i used stored procedure sp_tempweb_requisition_status post #1 and it could also be the right place to take balance result if im not wrong.

thanks.