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, ...
Answered

Sales Line Price Rounding issue using econnect schema

(0) ShareShare
ReportReport
Posted on by 242

Hi,

Recently I came across one issue in Sales Transaction entry screen unit price / extended price calculation. Please consider the following scenario,

There is an item named item 1 having list price as $ 9.06, when user enter the sales line with the item for quantity 2000 and the unit price with some discount lets say 23% on the list price and enter unit price as 6.98 (6.9762 = 23% discount on 9.06) in screen and then extended price will show as 13960.00 (2000 * 6.98). Now the actual extended price should be 13952.40 (6.9762 * 2000) , so user changes the extended price to 13952.40 but the unit price will still remain 6.98. This is the way sales invoices are booked manually. 

now when the sales line is pushed through econnect SOP line schema  with both unit price and extended price as 6.98 and 13952.40, but it is creating line as 13960.00 only. 

Item List Price Item 1 9.06
SOP Line entry ItemID Quantity Unit Price Extended Price
Scenario 1 - Manual Entry Item 1 2000 6.98 13960.00
Scenario 2 - Manual Entry change extended price to 13952.40 Manually Item 1 2000 6.98 13952.40 Unit price still remain 6.98
Scenario 3 - Push line through eConnect Schema Integration Item 1 2000 6.98 13952.40 after integration the extended price is still 13960.00

Please let me know how to solve this issue. 

Categories:
I have the same question (0)
  • Nicole Hellerud Profile Picture
    1,712 on at

    Hi Ramanan-

    Thank you for your post.

    I would recommend creating a support case on this issue and in the support case offering an example XML so we can analyze the issue further.

    Has anyone else in the community come across this issue and could offer a suggestion to Ramanan?

    Wishing you and yours healthy and happy days ahead!

    Nicole Fiskum

    Support Engineer

    Microsoft Dynamics GP

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    Hi Ramanan,

    This is the type of questions that are hard to resolve thru a forum post as there are many parameters coming into play.. especially with integrations. Nicole's suggestion to open a support call might be your best bet to resolve this. It could be the way that eConnect is passed information along the transaction to calculate the sub-totals and/or the discounts.

    Have you checked the details about the eConnect schema ? docs.microsoft.com/.../ff623781(v=msdn.10)

  • Verified answer
    Ramanan Profile Picture
    242 on at

    Hi Bucher,

    Thank you for your reply.

    I have resolved the issue by writing custom update of the extend price (calculated) to the SOP table on the taSopLineIvcInsertPost

    Thanks & Regards,

    Ramanan

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