Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Looking for solution t...
Finance | Project Operations, Human Resources, ...
Suggested answer

Looking for solution to update purchase price and sale price for ITEMS in AX

(0) ShareShare
ReportReport
Posted on by chrisfg77 45

Hi,

Need some help with this topic. The current process they are using to update purchase price or sale price is time consuming. Checking to see if they are other solutions available. Current all products needs to be stopped in order to update purchase price or sale price. They are using the data import export framework.

To update the new price and upload all the other products price in data import export framework. That means when we update even one price in AX, actually we have to work on ALL purchase price.

  • Sofur Profile Picture
    Sofur 10 on at
    RE: Looking for solution to update purchase price and sale price for ITEMS in AX

    Hi, is there any possibility to update also the prices in already existing POs and SOs that are not yet invoiced?

  • Suggested answer
    Prashant Singh Profile Picture
    Prashant Singh 8,797 on at
    RE: Looking for solution to update purchase price and sale price for ITEMS in AX

    Dear chrisfg77,

    If you have DB access it would be very easy to do.

    I would suggest try this in Dev server 1st.

    1. Import new price with Item no and sales price and purchase price in DB directly

    2. Update the InventTableModule(Purch).Price and InventTableModule(Sales).Price.

    Please take help of developer if you don't have good understanding of SQL statements.

  • qianwang Profile Picture
    qianwang 7,151 on at
    RE: Looking for solution to update purchase price and sale price for ITEMS in AX

    Hi Chris F,

    You can try to use Excel add-in function. Select the entity data source 'Released products V2' and needed field. 

    Then do modification and publish it.

    87546.png

    Regards,

    QianQW

  • chrisfg77 Profile Picture
    chrisfg77 45 on at
    RE: Looking for solution to update purchase price and sale price for ITEMS in AX

    Hi,

    Was wondering if there is another way update the Purchase price and sale price. The current way using the data import and export framework is taking a while. The wanted to know if there is a better solution.

    thanks,

    Chris F

  • qianwang Profile Picture
    qianwang 7,151 on at
    RE: Looking for solution to update purchase price and sale price for ITEMS in AX

    Hi chrisfg77,

    Yes. Generally, if no trade agreement or sales (purchase) agreement is attached to the item, when the price is updated using the data import and export framework, the new price of all items can be obtained in the new PO and SO.

    Greetings,

    QianQW

  • chrisfg77 Profile Picture
    chrisfg77 45 on at
    RE: Looking for solution to update purchase price and sale price for ITEMS in AX

    Hi,

    I was able to get more information about the request they are asking.

    1)  if there is a way to update the Purchase Price for all items in the system. The new purchase price will appear on any new PO.

    2)  if there is a way to update the Sale  Price for all items in the system. The new Sale Price will appear on any new Sale Order.

    Thanks,

    Chris

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,645 on at
    RE: Looking for solution to update purchase price and sale price for ITEMS in AX

    hi chrisfg77,

    Not sure if i understand your issue based on information you have provided. Can you add bit more details. Are you just updating your prices in price tables OR you are updating the open PO's etc. In standard system, you can update one price, you don't have to update all prices.

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

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans