Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Calculate Monthly Stock

Dear

I tell you that I am new to this topic and I need to calculate the monthly stock of a product, in short, I need to know my stock in January, February, March, etc. The data I have are, Code of my product, Income, Expenses and date.

2 Replies

  • All your stock in that example is zero

     

    We want to help you but your description is too vaugue. Please write it again clearly.

    Provide example input data as table text (not a screen print) so we can import the data to build a solution for you.
    Also provide the example desired output, with a clear description of the process flow.

    Remember not to share private data ... we don't want you to get into trouble. 😧

    Take care to use the same table and field names in the input, output and description so we can understand your problem and help you.

    You will get a quick response if you put time and effort into writing clear problem descriptions.

    Vaugue descriptions can waste your time and ourtime.

    Look foward to helping you when the above information is forthcoming

  • Good afternoon

    What I need is to be able to calculate stock monthly, For example, my product xx1, on January 1 has stock 10, in January I sold 3, in February 2 and in March 1. I need to be able to visualize that information every month.

    CodeIncomeExitDate
    xx110 01/01/2022
    xx1 102/01/2022
    xx1 213/01/2022
    xx1 104/02/2022
    xx1 115/02/2022
    xx1 106/03/2022

    And the result would be

    Stock JanuaryStock FebruaryStock March
    754

    In my source table, I own Code, Date Movement, Income and Outputs