Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Item Prices based on Price Methods

Posted on by Microsoft Employee

Any Body knows is there any econnect out method to get the item prices in Item price List window

that item prices are calculated based on Price Methods.

My Item price method are

1. Currency Amount (This method is OK, I can pick the prices)

2. % of List price (This is also OK for formula wise)

3. % Markup - Current Cost

4. % Markup - Standard Cost

5. % Margin - Current Cost

6. % Margin - Standard Cost.

(1,2 are ok but the remaining four methods I am unable to pick the prices or unable to formulate the item price in .Net coding)

or

Can you tell me the table name in which the final calculated item price is stored.

As I am integrating with .Net code.

in GP based on the round policies and round conditions and selling options the calculated value will be some figure.

if perform formula in .Net code the calculated value would be different.

How can I solve this problem?

please can any one help me out this.

 

Regards,

Rasool

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Prices based on Price Methods

    These four methods #3 to #6 are not store in a table. Instead, it's calculated by GP and the formula to get it to your report is:

    For 3-4: (Standard Cost or Current Cost) * (1 + (%/100)) = PRICE

    For 5-6: (Standard Cost or Current Cost) / (1 - (%/100) ) =  PRICE

    Current Cost and Standard Cost are located at IV00101

    % percent are located at IV00108 field of UOMPRICE 

    Hope this help to everyone.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans