Inventory result

[MurilloReis]

Hi,

I have a problem that i havent been able to solve for a long time. I`ll get straight to the point:

I have a purchases and sales table linked to a items list wich is pulling data from the products table. I need the full quantity of the products.

So, if i purchase 4 and sell 2 then i have 2 left.

very simple but i cant get it to work.

Let me simulate my problem:

lets say i purchase 20 pieces of gum. In the items list it creates a new row of a record saying i have bought 20 pieces in a quantity field.

Now, i have sold 10 pieces of gum. In the items list it shows i have Sold 10 pieces on an exclusive quantity field.

Finaly, I go in the products table and i have a quantity field to subtract the 2 values. it just gives me the result of the first row and the first row only.

if i make 2 purchases, the sum will only show me the first purchase.

------------------------------------

2nd test:

I thought of adding the inicial "purchase quantity" directly into the product table, as if i input it only as the delivery.

But still no good.

To make things a bit more clear:

::LIST ITEMS:::

ITEM ---------- QNT

Piece of gum = +1

Piece of gum = +3

Piece of gum = -1

::PRODUCTS::

Pieces of gum = 3 ((subraction on qnt bought - qnt sold))

---------------------------

or

---------------------------

::Products::

Product Name Quantity

Piece of gum = 5

::Sales::

Piece of gum = -3

::Inventory::

Pieces of gum = 2

So if someone knows how to help me out PLEASE DO.

i am breaking my back on this issue and i think it is something simple to resolve.

I would prefer if you add me on msn so we can talk more clearly and directly.

THANK YOU FOR YOUR CONCERN

msn:: [email protected]

Edited April 14, 2009 by Guest

[bcooney]

I think that this thread might help:

Inventory

[MurilloReis]

Thank you for your response.

But i didnt find the answer neither on the demos or on the links.

I have purchases/line item/Sales/

but if i try to count something in the purchases or line items it just gives me the first number not the individual number.

sory if i didnt get the whole picture but i just need a way to get from the purchases and the sales the sum of the QUANTITY OF ITEMS INDIVIDUALLY so i can subtract them both.

Am i going the right direction?

thanks again

[bcooney]

Really? Hmm..Well in a typical Inventory setup, the tables would include: Products, POs, POLineItems, Sales (Invoices), SaleLineItems, Customers, Vendors.

From products to calc a Qty Sold, you would create a calc field = sum (relationshipProductID::SaleLineItems:Qty).

If you can get that to work, the rest will follow.

[MurilloReis]

That is exactly what i am doing.

But the calculation doesnt work

example.

Products

ID ::::: NAME

1 --- CANDY

2 --- popsticle

3 --- GUM

Purchases

PRODUCT ID ::: NAME ::: QNT ::: PURCHASE ID

1 ----------- CANDY --- [color:red]3 ----- 1

1 ----------- CANDY --- 2 ----- 2

2 ----------- popsticle -[color:red]1 ---- 3

1 ----------- candy --- 1 ----- 4

2 ---------- popsticle - 2 ---- 5

going back to PRODUCTS AND ADDING A QNT FIELD

QNT = SUM (PURCHASES QNT)

PRODUCT ID ::: PRODUCT NAME ::: QNT

1 ------------ candy --------- [color:red]3

2 ------------ popsticle ----- [color:red]1

so the sum is only giving me the first value of each product.

so i dont know what is going worng.

am i doing it wrong ?

thx

[comment]

See if the attached helps.

SumPurchases.fp7.zip