Inventory management

Hello everyone. I am a beginner and for the first time creating my inventory management application. I sell several types of goods in three places. For this I created an application with three primary views: “Product list”, “sales” and “add stock” and I have following questions:

  1. I want to see not only the balance of goods, but also the profit for the day and the total profit. How can I do this?
  2. Is it possible to make my sellers see and use only one primary view “Sales” in the application?

Hi @Chikesh

1) I want to see not only the balance of goods, but also the profit for the day and the total profit. How can I do this?

You may want to use the “group by” option in the view options, and select Group aggregate option: SUM.

Please find below an example.

2) Is it possible to make my sellers see and use only one primary view “Sales” in the application

Yes. Select the “Ref” position for the other views, or use the “Show-If” expression, for example:

USEREMAIL()="me@example.com"

3 Likes