Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Extended pricing

Posted on by Microsoft Employee

Hello,


i am working with extended pricing i have few questions

1) How To get Item Final Price.

2) what is item specific price

3) what happens item will exists in price sheet and price group and also that price group assigned to some price sheet which price will apply ?

for example my item "A" assigned to Price Group "B"

Price Group "B" assigned Price Sheet "C"

and item "A" directly assigned to Price Sheet "D" ,Price Sheet assigned to customer "SAMPLE"

Now what price it will take price sheet "C" or "D"?

Thanks,

Naresh.Sangana

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Extended pricing

    Please have a look on the below link. Normally it will works based on the minimum date range.

    roseasp.com/extended-pricing-in-dynamics-gp

    Hope this helps!!!

  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Extended pricing

    Extended Pricing uses dates and some other rules (e.g. a valid price directly assigned to a customer will override a group) to determine which price to select.   The Manual and the help file have great explanations.  In the help file, see "How prices are calculated for Extended Pricing."

    The best way to test your scenario is to use Price Trace Inquiry.

    Inquiry >> Inventory >> Extended Pricing >> Price Trace

    Tim Foster

  • Mallesh Deshapaga Profile Picture
    Mallesh Deshapaga 198 on at
    RE: Extended pricing

    Extending Prices:

    ITEM: to be included in sales transcation.

    it should contan the price group and price sheet.

    .........

    price group:it contain same prices.

    ........

    price sheet: it wil apply only during the date range,specified item can exist in multiple    price sheet as a part of same price book.

    ........

    price book: basic pricing of all items.

    ......

    customer: customer can be used for price book and price sheet.

    ......

    HOME-->Extending Price-->Price sheet mainteneance.

    the window will open-->click on price sheet window select an-->ID.

    In the box click on--> item numbet/price group Id.

    Click on price book maintenance-->select price book Id

    clcik on customer Pricing Maintenance-->select customer ID--CLCIK on price sheet Id-->

    select the some more option and check it. u can get ur required information.

    u can test with some sql quaries also.

    i hope it wil be some what helpful for ur task.

    thanku.

    Mallesh VarMa

    +919640508585

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