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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Issue with SOP quote s...
Microsoft Dynamics GP (Archived)

Issue with SOP quote subtotal.

(0) ShareShare
ReportReport
Posted on by Dineshkarthy 65

Hi All, We are using GP10.00 and a Sop Quote was created by entering two items and report was generated but the subtotal was not equal to the Sum(Extended price) and unknowingly they posed that entry. I can't understand weather it happen while creating quote or the line got updated after some time. Is there any specific setup which cause this.  I have check with the table  SOP30200 and SOP30300 the value seems wrong only. What is reason of this and how could it can be fixed? Thank you.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at

    Hi,

    If you notice a document where the subtotals don't match the sum of extended prices, and that document is still in "WORK", you can run "Reconcile Sales Documents" to correct it.  (Tools - Utilities - Sales - "Reconcile - Remove Sales Documents".  Then entered the document range, mark "Reconcile Sales Documents" and then hit Process.

    One question, did you transfer this quote to another document (order or invoice)?  If so, how does the order/invoice look?

    Once a document is in history there is little you can do within GP to correct this, and if I were in your situation I would manually update the SOP30200 and 30300 as needed (as always, be careful, make a backup, etc...before making direct sql updates).

    Thanks,
    Justin

  • Verified answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at

    I have seem this problem few times before. There is not a setting issue and it is likely to be a bug caused by either GP or a 3rd party product. Is this an intermitting problem?

    If the quote is already in the SOP history tables and you want to fix the amounts you can only do this by using SQL.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Is this a frequent issue or it is the first to occur ? Do you have any integration running ?

    Your feedback is highly appreciated,

  • Dineshkarthy Profile Picture
    Dineshkarthy 65 on at

    Hi..This is the first time we are facing this issue no we are not using and integration tools.

  • Dineshkarthy Profile Picture
    Dineshkarthy 65 on at

    No..the client just posted that quote and created the new one with correct value and transfer it to order.  

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at

    The Reconcile Sales Documents sometimes fixes these issues while the Sales Transaction is still in the WORK tables. I said sometime because I found cases were it didn’t solve it.

    When I face this type of problem I prefer to void the quote, order or invoice and create a new one.

    This issues sometime happen in GP and become only a problem is they happen too often.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans