No announcement yet.

How to update new record from previous month record - Stock Module

  • Filter
  • Time
  • Show
Clear All
new posts

  • How to update new record from previous month record - Stock Module


    I'm trying to create a stock maintaining module inside of the CRM. So I got below entities

    Items - for maintain stock items
    Stocks - maintaining Previous month stock/New stock/New Stock date/Total Stock/Total Issue/Month End Stock/Stock Month
    Supplies - Item Name/Branch/Supply Units/Supply Date

    In this case im stuck with the data fetching from the previous month. I hope that can be done but something there i missed.

    What I need at the moment is to fetch previous month "Month End Stock" to new month field "previous month stock"

    Eg: January 2020 "Month End Stock" = 100 & February 2020 "Previous Month Stock" = 100

    is there anyone know a way to do this. ? Im going to continue this thread as this is help us to built a different module with some complex conditions im guess.

  • #2
    Can I have someone's input for above ?


    • #3

      Your question is difficult to answer. It's not clear. Whether you asking about how to better design your module or how to fetch something from DB with a specific parameters.


      • #4
        yurikuzn If you can help me on better design its much easier for me

        Basically what I need is to fetch data with specific parameters.

        As per to the attachments Jan.png containing Month End Stock as 345 what I need is to put that 345 to the Feb.png Previous Month Stock

        Attached Files


        • #5
          yurikuzn any luck with above ?