Finance | Project Operations, Human Resources, ...

Using standard cost field to have a manually calculated cost

(1) Share

Report

Posted on by Ajit K

957

Hi,

We are in GP 2018 and currently using average cost as our valuation method and percentage of list as our pricing method. We would like to update the standard cost field to store a manually calculated cost that includes all other expenses, more accurate than our current cost. We want to use this field in custom sales reports to calculate more accurate profit margins. Is there any other implications in using standard cost field to store a number ? Are there any utilities available to update standard cost for all items other than integration manager ?

Thanks

Ajit

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Dean Marty Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Good Day

While I can't think of any particular reason why you couldn't do this, that's of course not what that field is intended for.

As such, it's not something that would 'officially' be supported and we can't really say what, if any, issues you may run into down the road.

Thanks!

Dean

Was this reply helpful? Yes No

Suggested answer

Almas Mahfooz

11,009 User Group Leader on at

Like (0)

Report

Copy link

Link copied!

As per the GP Help files.

Fields

Price method

Notes

Standard Cost

%Markup–Standard Cost

%Margin–Standard Cost

You can enter or update a standard cost value anytime, unless an outstanding shipment or shipment invoice exists in Purchase Order Processing. You also can use year-end close activities to update standard cost information.

Regarding mass update, you can use macro or custom code to automate Change Item standard cost window. Via custom code this can be done effeciently.