Customized Stock Activity Report

Stock Activity Report Project Instructions Please study attachment file for samle data. Input Every item on "Transactions Report" is requiring 1 Stock Activity Report output. Vendor Bill and Item Receipts are incoming stocks. Invoice and Cash Sale is outgoing / sale stocks. Each transaction needs to be filled in one line. **VERY IMPORTANT** ---> If in 1 day same item has several transactions, system must sort the transactions incoming to outgoing or buying to selling. First receiving transactions ( Vendor Bill and Item Receipt transactions ) and then sale transactions ( Invoice and cash sale transactions ) All items should be in 1 workbook with page brakes. If 1 items transactions exceeding 43 transactions it should extend to new page with row 1 to 8 details included in the extended page also. Cells information Cell: Row 2 - column 7 = is page number. if only 1 page report for this item then it is "1" if report for this item extends to more pages then page number also increases for this cell. middle aligned. Cell: Row 9 - column 1 = is date of transaction ( transaction date from transactions report ). Date format should be like 16-Nov-2010 in Thai Buddhist calendar format. All transactions report should be sorted oldest to newest ( olderst is on top ). middle aligned. Cell: Row 9 - column 2 = is invoice no for this transaction. middle align. Cell: Row 9 - column 3 = is the QTY for buying transaction ( Vendor Bill or Item Receipt ) middle align. Cell: Row 9 - column 4 = is the QTY for selling transaction ( Invoice or Cash Sale ) middle align. Cell: Row 9 - column 5 = is the Balance QTY after this transaction. middle align. Please see sample report for item A-001. Project Budget $100 USD. Time 1 Day.