cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Stock

I'm new here and I'm doing an inventory management application, I still don't understand what function to use to discount a product from the initial quantity. and that this saves me in Excel which is my database. Thank you for your help. I will appreciate it.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Stock

Hi @Anonymous ,

Do you want to understand the stock in inventory management application?

Please notice these formulas in ProductDetailsScreen.

1)CurrentStock:

First(ProductRecord).DefaultSellingQuantity

//current product stock

2)IdealStock:

LookUp(Products,ProductNumber=First(ProductRecord).ProductNumber,Stock)

// the  ideal ProductNumber of the selected product

3)OrderQuantityText:

Value(IdealStock.Text-CurrentStock.Text)

//default value is ideal ProductNumber-current product stock

4)Button1_1:

Patch(Products,LookUp(Products,ProductNumber=First(ProductRecord).ProductNumber),{DefaultSellingQuantity:Value(OrderQuantityText.Text+CurrentStock.Text)});Navigate(ConfirmationScreen,ScreenTransition.Fade)

 //update product table ideal ProductNumber=current product stock+ OrderQuantity

 

Please notice : the first label is the current stock, the second label is total stock, the textinput is to enter the number that you want to order(demand). The product number in products table is total stock number.(=order+current)

479.PNG

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Stock

Hi @Anonymous ,

Do you want to understand the stock in inventory management application?

Please notice these formulas in ProductDetailsScreen.

1)CurrentStock:

First(ProductRecord).DefaultSellingQuantity

//current product stock

2)IdealStock:

LookUp(Products,ProductNumber=First(ProductRecord).ProductNumber,Stock)

// the  ideal ProductNumber of the selected product

3)OrderQuantityText:

Value(IdealStock.Text-CurrentStock.Text)

//default value is ideal ProductNumber-current product stock

4)Button1_1:

Patch(Products,LookUp(Products,ProductNumber=First(ProductRecord).ProductNumber),{DefaultSellingQuantity:Value(OrderQuantityText.Text+CurrentStock.Text)});Navigate(ConfirmationScreen,ScreenTransition.Fade)

 //update product table ideal ProductNumber=current product stock+ OrderQuantity

 

Please notice : the first label is the current stock, the second label is total stock, the textinput is to enter the number that you want to order(demand). The product number in products table is total stock number.(=order+current)

479.PNG

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Memorable Member
Memorable Member

Re: Stock

Hi @Anonymous,

Suggest to look into the out-of-the-box features of Products, Product Catalogs, Prices Lists and Discount Lists which should satisfy your requirements. This requires Dynamics 365 Sales app which sits on top of CDS.

For more info, here are some Microsoft documentation:

Hope this help!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (6,677)