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 :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SOP Invoice extended p...
Microsoft Dynamics GP (Archived)

SOP Invoice extended price differences when using two different workstations

(0) ShareShare
ReportReport
Posted on by Jackie McNab 214

There are two SOP invoices with lines that have identical quantities and unit prices but the calculated extended prices are different.  Each invoice was entered using a different workstation. 

Can anyone explain what would cause this difference.  Below is the calculation for each invoice line.

QTY           Unit Price             Extended Price             Extended Price

_____         ___________               Invoice #1                    Invoice #2

4.000       1870.05                   $7480.20                      $7480.21

4.000         504.43                   $2017.72                      $2017.74

2.500         220.01                     $550.03                        $550.02

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: SOP Invoice extended price differences when using two different workstations

    The difference I came up with was rounding.

    If you put the extended price in first, the system will calculate the unit price.

    7480.21/4 = 1870.0525.

    2017.74/4 = 504.435

    550.02/2.5= 220.008

    If you go the other way and enter unit price first the calculation comes up with the extended price

    1870.05 * 4 = 7480.20

    504.43*4 =2017.72

    220.01*2.5 = 550.025

    Do you know how the raw data was entered?

    Leslie

  • Jackie McNab Profile Picture
    Jackie McNab 214 on at
    RE: SOP Invoice extended price differences when using two different workstations

    Hi Leslie,  Thank you for the response.  In both instances the qty. and unit price were entered to arrive at the extended price.  I understand that we can enter the extended price and have the  unit price be calculated but our prices for these items are fixed so that would not work for us.  Mu concern is why the two different rounding results  Is this something driven by the individual workstation?  If so I would expect that this would be consistently determined by the database and not the client machines 

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: SOP Invoice extended price differences when using two different workstations

    Jackie,

    I'm stumped. I couldn't recreate the error. This is a huge long shot, but are the international settings on all of the workstations the same? Are these inventory or non-inventory  items? Have you been able to isolate this problem to just a few items? Are you using multicurrency? On the inventory item, what is the decimal places for currency on the item card?

    Please let us know if you find a solution.

    Leslie

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans