I want to manage stock date by date.
For Example if one item comes first it should be gone first. When I issued stock the first date stock should be finished first then other.
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Add a receive date field in the inventory table, and then you can update the quantity in hand on behalf of this field. Below is an example:
Where the v_sale_qty and v_item are the variables for the item you want to update the inventory.
This is just an example to give you an idea. You can modify more as per your requriement.
Nomi
Dear Sir,
If I received the 50 things at date (03-12-2020) and 25 things at 10-12-2020 and customer demand 64 things can this solution first empty the first date stock then other.
Vinish Kapoor
Ok you can try the below approach:
Nomi
Thanks a lot sir its a great solution for me.
Nomi
Dear Sir,
I want to get method of making inline views for reports making.
If you don't mind please share your great experience about this.
I shall be highly appreciated your kindness.