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.