web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Problem Description (Dynamics GP – Price Sheet / Item Price Not Loading)

(2) ShareShare
ReportReport
Posted on by 137

I’m working with a Dynamics GP company database named NA.

The BASE price sheet (PRCSHID = 'BASE') was accidentally deleted from the tables IV10401 and IV10402.

 
 

To fix this, I restored a temporary backup database called INSIG, and I copied the original records of IV10401 and IV10402 (for PRCSHID = 'BASE') from INSIG back into the NA database.

After doing this, the price sheet now appears again in GP without errors.

 

However, I still have one remaining problem:

 

When I create a new Sales Transaction Entry (SOP Invoice/Order), and I enter the item METROWTWC, Dynamics GP does NOT bring the correct item price automatically (the price for this item in the BASE price sheet is 115.000).

 

So the item exists, the price exists in IV10402, but GP does not load the price into the SOP line.

 

What could be causing this, and how can I fix it so the item pulls its price normally in a new sales invoice?

 

How do I solve the problem so that when the user fills in the item on the sales screen in the LINE, the item's price is automatically retrieved?

Categories:
I have the same question (0)
  • Suggested answer
    Lisa at AonC.com Profile Picture
    1,062 Super User 2026 Season 1 on at
    Is the Extended Pricing functionality possibly enabled?
     
    Via SQL Queries: 
    • Search the IV00 tables in the INSIG database, looking for the item number METROWTWC in each one.  (I'm thinking it is missing from something like IV00105 Item Currency or IV00107 Item Price List Options or IV00108 Item Price List.)
     
    Via GP:
    • Have you reviewed the item in GP Item Maintenance windows (including all the options under the Go To menu)?
    • Have you run Check Links on Item Master?  (Make sure you have a backup before doing this!)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 617

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 461 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans