Skip to main content

Notifications

Microsoft Dynamics NAV forum
Suggested answer

Selling to sales orders with the last price

Posted on by 5

Dear All,

There is more than one price information with a start and end date for a product on sales price table. Because the price is updated on the 1st of every month.

If we create a sales order for October 2022, the October prices appear in that order and an invoice is generated at those prices. It is ok.

However, if the order created in October 2022 is invoiced in November 2022, it must be invoiced with NAV November prices. How can I make this price update automatically on sales order?

The NAV shows the prices on the day the order was created and the invoice generate of these prices.

Even if one of the products in the order is invoiced, the order date cannot be changed. Therefore, the product prices are not updated by changing the date.

Is there a setting to update the products in the sales order to the last price or to create the invoice with the last prices?

Thank you fir your interest.

  • KTA Profile Picture
    KTA 1,200 on at
    RE: Selling to sales orders with the last price

    As ZHU said it isn't standard. In some countries is a legal requirement that the price order has to be respected on invoice

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,612 Super User 2024 Season 2 on at
    RE: Selling to sales orders with the last price

    Hi, as far as I know, the standard doesn't have this feature, but I used to develop a function to update prices for a client. Add a new action that, when clicked, updates the price of the lines based on the current date.
    But this requires customization.

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Amit_Sharma Profile Picture
    Amit_Sharma 2,545 on at
    RE: Selling to sales orders with the last price

    Hi,

    Prices will populated in Sales Line form Sales Price and Sales Price gets according to the Order Date in Sales Header.

    If you change the date and enter the item, then it will insert the price as per your requirement.

    Regards

    Amit Sharma

    www.erpconsultors.com

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans