AppSheet [Inventory Management]: Setting for Stock in and Stock out in Key in Quantity

AppSheet AppSheet Q&A
, ,
1

Respected Sir, Madam, Miss,

I have first trial for this custom of the template to a system app of the E-com purpose. I have facing to edit function as subject above.

My question:

How to I edit or formulate that’s setting for the features

Stock in increases Stock out decreases

HSE122_0-1651004302282.png
HSE122_0-1651004302282.png1905×648 73 KB

Stock in/out under

Form add Table the extra as

HSE122_1-1651004437857.png
HSE122_1-1651004437857.png1289×385 24.1 KB

The Supplier +Stock

The Sales -Stock

With our e-com company multiple account of the Shopee and Lazada

I think if it successful functioning will recognized for the E-com business as our types.

Thanks for the all people contribution in these session. :folded_hands:

All best :grin:

Best from
Assistant HSE122

2

Hi @HSE122

I do not understand your question. Did you manage to solve your problem?

1 Like
3

Hi @HSE122 ,

Here is the expression we use in our inventory management app to find the amount remaining for each item.

SUM(
  SELECT(
    Inventory[Amount],
      ([Item ID] = [_THISROW].[ID])
  )
)

Copy & Customize: Inventory App

Let me know if you have any other questions.

Thanks,

Austin from AppSheet Training

1 Like
4

Respected Mr Austin,

Greetings. Thank for your answer of my query.

Thank you.

All the best.

With regards.

Assistant

1 Like