hello Lynn Pettis,

You're right, I'm really sorry. I apologize to you and to the whole community for this inconvenience.

up please

I would like for item 'M0001 apply the FEFO(First Expired First Out) system.

In my case I would like to withdraw the stock of 400 units this item but first I...

Hello,

Here is a sample insertion of relevant tables by my request.

--insert table article

INSERT INTO [HEALTHBOARD].[dbo].[ARTICLE]

([CODART]

...

hello SSChampion

thank you for answered

As done in my previous request I would like to apply the FEFO system so if I have for example the following product data:

Numlot 1 Prod:...

up help me please

please somebody help me

I have grouped the results according to max (m.DATMVT) but I still do not know how to do subtraction qte_entree qte_sortie and for all according to my EtatStock approach chrism...

hi chrism@Work thanks for your reply but when I apply your solution, here in attachment is the result I get:

but I would like to have a column that displays EtatStock...

HanShi when I apply your proposal query gives me the results with lots of numbers, but not my stock