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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 89

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)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 718 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 609 Super User 2025 Season 2

#3
CU05031448-0 Profile Picture

CU05031448-0 604

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans