Jump to content

Add Margin % or Selling Price in Stock Management


This topic is 1572 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I would like to have options to enter either fields (selling price or margin) and the other should be automatically calculated for instance:

    

     Cost Price = 100 (Available)

     Sell Price  =  Calculation field or ?? Input amount

     Margin     =  Calculation field or ?? Input percentage

    

     If i put 160 on sell price it should automatically put 37.5% in margin or if i put 37.5% in margin field it should automatically fill sell price for 160.

File uploaded

Login name: admin

No Password: 

 

Thank you in advanced.

TEST.fmp12

Edited by Kishan_Canoo
Add file
Link to comment
Share on other sites

Hi Kishan_Canoo,

We need more information about what you are trying to do because, I suspect that you have more then one product and the sales price isn't always 160. 

One of the great thing about this forum is that you can always attach a file which will speed things up in finding an answer to your question. See the Guideline for how to deal with confidentiality.

 

Link to comment
Share on other sites

I looked at your file -  "TEST.fmp12"

I don't understand why you're applying a Margin based on cost. The  "TEST.fmp12" clearly shows the problem with doing that, i.e. you have 3 items with a cost $100 with 3 different Margins.

Shouldn't your margin / selling  price be  based  on the products themselves?

Lee

Link to comment
Share on other sites

This topic is 1572 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.