Stock Movement Report

[klwu]

I wanted to create a Stock Movement Report, but I am not quite sure how.....I need some help.....

I have these tables:
M_Stock (Stock information)
T_GRN & T_GRN_Detail (Good Received information)
T_IIS & T_IIS_Detail (Internal Issue information)

I need to do a report stating the opening balance, the activities (ins & outs), and the closing balance....like this:

StockCode: A01-001

DocNo Bal B/F In Out Bal C/F
-------------------------------------------
I98999 10 0 2 8
56557 8 4 0 12
22222 12 0 1 11

Can someone lend me a hand on this? I have tried to build queries for this, but the running balance keeps counting from the first opening balance (10).....thanks in advance

 

[M8KWR]

i would need a bit more info in order to help you.

Is it possible for you to post an access file so I can see you table layout, and if you could leave some sample data in there it would help, the i could design the queries and reports for you, and re-post it back to you.

Hope this helps.

 

[cyborgoddess]

Are there a fixed number of fields between the opening and closing numbers?