Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

We use GP 10. We offer discounts in the form of buy 5,000 get 1,000 free. This sometimes creates a unit price of say $0.1066666..... On the order form we overwrite the extended price to the advertised dollar value i.e buy 5,000 get 6,000 for $700. Howev

Posted on by 50

*This post is locked for comments

  • Erwin Metius Profile Picture
    Erwin Metius 50 on at
    Re: We use GP 10. We offer discounts in the form of buy 5,000 get 1,000 free. This sometimes creates a unit price of say $0.1066666..... On the order form we overwrite the extended price to the advertised dollar value i.e buy 5,000 get 6,000 for $700. H

    Thanks for you help - I will take it up again with the customization folk

  • Verified answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: We use GP 10. We offer discounts in the form of buy 5,000 get 1,000 free. This sometimes creates a unit price of say $0.1066666..... On the order form we overwrite the extended price to the advertised dollar value i.e buy 5,000 get 6,000 for $700. H

    If the system is recalculating the unit price when the price is transferred to an invoice, you have a customization that is affecting pricing that needs to be fixed.

    As for the extra line, create a new product that reflects the additional quantity but does not require image approval?

  • Erwin Metius Profile Picture
    Erwin Metius 50 on at
    Re: We use GP 10. We offer discounts in the form of buy 5,000 get 1,000 free. This sometimes creates a unit price of say $0.1066666..... On the order form we overwrite the extended price to the advertised dollar value i.e buy 5,000 get 6,000 for $700. H

    Thanks for your response and suggestion.The problem with this the item has a custom image associated with it that requires customers approval.  By putting the items on 2 lines the customer gets 2 requests to approve the same image.  It seems that GP recalculates the extended price when transfering to invoice - is there a way to avoid this?

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: We use GP 10. We offer discounts in the form of buy 5,000 get 1,000 free. This sometimes creates a unit price of say $0.1066666..... On the order form we overwrite the extended price to the advertised dollar value i.e buy 5,000 get 6,000 for $700. H

    Put in the order for 5000 on one line at the standard price and the quantity of 1000 on a second line with a price of $0.  Otherwise, you will need to accept the minor price differences.

  • Erwin Metius Profile Picture
    Erwin Metius 50 on at
    Re: We use GP 10. We offer discounts in the form of buy 5,000 get 1,000 free. This sometimes creates a unit price of say $0.1066666..... On the order form we overwrite the extended price to the advertised dollar value i.e buy 5,000 get 6,000 for $700. H

    Cont.... however when the order transfer to an invoice GP calculates the extended price again by quantity x unit price.  This creates a small variance between the order total and invoice total and causes confusion and the need to write off these amounts in the customers accounts.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans