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)

Verified answer

QQY on at

Like (0)

Report

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

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

Which step are you stuck on?

Was this reply helpful? Yes No
ibidapobabatunde 10 on at

Like (0)

Report

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

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

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

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

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