Stock Balance Calculation after Stock has been Issued out

(0) Share

Report

Posted on by ibidapobabatunde

Hello All,

Please I am building an Inventory Management App,

1. I need the Stock Balance to be displayed automatically, pull out details from the Database, instead of entering the Quantity manually

2. I need a formula to display the Available Stock Balance after Stock Out (Amount of Stock Issued) has been Done

Note: On entering a new Data , I want the Stock Balance to auto-populate /display from the last Stock Balance

i.e Stock Balance = Stock Balance - Stock Out (Amount of Stock Issued)

I need a solution that the Stock balance will be updated after the Stock has been issued Out

Thanks for your suggestion.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

QQY on at

Like (0)

Report
Copy link

Link copied!

hi

you could follow below steps:

1, Set the selected record as VarRecord, and set the editmode property of stock out to viewmode
2, add a Slider out of the EditForm to show the stock out qty this time you want issue, min Value 0, max Value = VarRecord,.Stock Balance - VarRecord,.Stock Out
3, add a text out of the EditForm to show the stock balance after you drag the slider, set the text property = VarRecord.Stock Balance - Slider.Value
4, use a patch function in Form Oncuess property: Patch(datasource,VarRecord,{Stock Out: VarRecord.Stock Out+Slider.Value})

Was this reply helpful? Yes No
ibidapobabatunde 10 on at

Like (0)

Report
Copy link

Link copied!

Hello,
Thanks, I tried it but it does not work. I think I am not getting what you are trying to explain.
kindly assist if you can break it down.
I am a beginner in PowerApp Development.
Note: On entering a new Data, I want the Stock Balance to auto-populate /display from the last Stock Balance.

many Thanks

Was this reply helpful? Yes No
QQY on at

Like (0)

Report
Copy link

Link copied!

Which step are you stuck on?

Was this reply helpful? Yes No
ibidapobabatunde 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your response, I have been available to do the Slider only

I am stuck at No. 1,2,3,4

Was this reply helpful? Yes No
QQY on at

Like (0)

Report
Copy link

Link copied!

just change as below

1, set the editmode property of stock out to viewmode
2, add a Slider out of the EditForm to show the stock out qty this time you want issue, min Value 0, max Value = Gallery.Selected.Stock Balance - Gallery.Selected.Stock Out
3, add a text out of the EditForm to show the stock balance after you drag the slider, set the text property = Gallery.Selected.Stock Balance - Slider.Value
4, use a patch function in Form Oncuess property: Patch(datasource,Gallery.Selected,{Stock Out: VarRecord.Stock Out+Slider.Value})

Was this reply helpful? Yes No
ibidapobabatunde 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks, a lot.
There is much improvement now.
The only problem I have now is at Step 4
After selecting the Form and at On Sucess Property, I got this error message below:

Was this reply helpful? Yes No
QQY on at

Like (0)

Report
Copy link

Link copied!

Patch(datasource,VarRecord,{Stock Out: VarRecord.Stock Out+Slider.Value})
I saw you have missed the 2nd parameter in the Patch Function.

Was this reply helpful? Yes No
ibidapobabatunde 10 on at

Like (0)

Report
Copy link

Link copied!

Hi,
I appreciate your response.
It is not working, I think I missed Step 1 and also see the error when I include the 2nd parameter as screenshot below,

Was this reply helpful? Yes No