Sage 100

version 2020 PU1 - The profit margin in SO entry is wrong.  There is Sage KB 85794 which indicates engineering is reviewing.  It was first reported in August 2017.  Four+ years later and apparently nobody can figure it out.  Thoughts?


------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

I think the profit margin percent is actually calculated using the last cost.  At least that is how it was for a version that Beth Bowers brought to my attention.  So is it actually calculating it incorrectly when using the last cost or were you expecting it use the average or standard cost and that is why you might think it is incorrect?

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Thanks @David Speck II  You are correct.  It is using the last cost.  It is confusing to the user and to me that the last cost is used.  Intuitively one would think the cost to use would be the cost that is read into the line item field.  Further, the screen displays the average cost in parenthesis so a user thinks this is the cost that is being used.  So, this is probably working as designed but I believe it to be a poor design. using the last cost to calculate the GP and to make pricing decisions may, in some cases lead to losing money on a sale.. 
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Original Message:
Sent: 10-27-2021 00:14
From: David Speck II
Subject: The profit margin in SO entry is wrong.

I think the profit margin percent is actually calculated using the last cost.  At least that is how it was for a version that Beth Bowers brought to my attention.  So is it actually calculating it incorrectly when using the last cost or were you expecting it use the average or standard cost and that is why you might think it is incorrect?

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

The average cost in parenthesis is controlled by this option.  It is confusing that they are displayed side by side.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 10-27-2021 10:28
From: Doug Higgs
Subject: The profit margin in SO entry is wrong.

Thanks @David Speck II  You are correct.  It is using the last cost.  It is confusing to the user and to me that the last cost is used.  Intuitively one would think the cost to use would be the cost that is read into the line item field.  Further, the screen displays the average cost in parenthesis so a user thinks this is the cost that is being used.  So, this is probably working as designed but I believe it to be a poor design. using the last cost to calculate the GP and to make pricing decisions may, in some cases lead to losing money on a sale..
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------


Original Message:
Sent: 10-27-2021 00:14
From: David Speck II
Subject: The profit margin in SO entry is wrong.

I think the profit margin percent is actually calculated using the last cost.  At least that is how it was for a version that Beth Bowers brought to my attention.  So is it actually calculating it incorrectly when using the last cost or were you expecting it use the average or standard cost and that is why you might think it is incorrect?

------------------------------
David Speck II
Tennessee Software Solutions

Good to know.  Thanks.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Original Message:
Sent: 10-27-2021 10:31
From: David Speck II
Subject: The profit margin in SO entry is wrong.

The average cost in parenthesis is controlled by this option.  It is confusing that they are displayed side by side.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 10-27-2021 10:28
From: Doug Higgs
Subject: The profit margin in SO entry is wrong.

Thanks @David Speck II  You are correct.  It is using the last cost.  It is confusing to the user and to me that the last cost is used.  Intuitively one would think the cost to use would be the cost that is read into the line item field.  Further, the screen displays the average cost in parenthesis so a user thinks this is the cost that is being used.  So, this is probably working as designed but I believe it to be a poor design. using the last cost to calculate the GP and to make pricing decisions may, in some cases lead to losing money on a sale..
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles


Original Message:
Sent: 10-27-2021 00:14
From: David Speck II
Subject: The profit margin in SO entry is wrong.

I think the profit margin percent is actually calculated using the last cost.  At least that is how it was for a version that Beth Bowers brought to my attention.  So is it actually calculating it incorrectly when using the last cost or were you expecting it use the average or standard cost and that is why you might think it is incorrect?

------------------------------
David Speck II
Tennessee Software Solutions