Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Item Prices based on Price Methods

(0) ShareShare
ReportReport
Posted on by

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
    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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans