AnsweredAssumed Answered

Stock calculation problem?

Question asked by mayor on Apr 25, 2011
Latest reply on Jan 30, 2012 by MojtabaFazeli

Title

Stock calculation problem?

Post

Hello,

I'm using FMP ver 9.0, have design inventory system. I have 4 tables,

staf (name, title, division, stock_id)

stock (stock_id, stock_name ....)

out_stock (stock_id, stock_name....)

in_stock (stock_id, stock_name....)

PO (po_no, po_date, po_amount, stock_id)

Relational : stock_id

I face problem how to make calculation on current stock after add new stock for example.

example

stock              Total            Qty-Out                     Balance
------              ------           ----------                   -----------
CD                     50                5                              45
Pen                    10                3                               7

How to make the calculation for the balance of the stock for each good calculated

after in or out of the store. Your idea much appriciated.

TQ

Outcomes