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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Issue related to Unit Price in Sales Batch - taSopLineIvcInsert

(0) ShareShare
ReportReport
Posted on by 60

 Hi Forum,

I am a novice at Dynamics GP.
I have entered some values into GP using econnect

Then. I took the sales batches from Transactions--> Sales -->Sales Batches from GP.
I viewed the data on screen. (SOP Posting Journal)

The output was shown like

I need to see just one value $30.50 under the Markdown Unit Price. Shall I change any feild in my xml that populates the taSopLineIvcInsert or taSopHdrIvcInsert ? I dont want the $0.00.

What is causing the problem?
How can I fix it?

Regards,

Naveen Jose

*This post is locked for comments

I have the same question (0)
  • Mark Roux Profile Picture
    670 on at

    Hi Naveen,

    I cannot see the screenshot. Are you able to email it? mark.roux@calyxgroup.com

    Thanks

    Mark

  • naveenj Profile Picture
    60 on at

     Hi Mark,

    Yeah I have mailed you the screen shot.
    Thank you for the help.

    Regards,

    Naveen Jose

  • Mark Roux Profile Picture
    670 on at

    Hi Naveen,

    Thanks for sending through the screenshot.

    Are you confusing the lines on the actual report? There are two header lines for the report, and two SOP item lines on the report per item.

    In other words the report would look like this if there was enough space to fit it all on one line:

     

    Description     Markdown     U of M     Site     Quantity     Unit Price     Extended Price

    #1- 1 inch       $0.00            Box         Main    1               $30.50          $30.50

     

    It looks like your xml is populating correctly... and its just the report in GP that needs modifying if you dont want to see the Markdown column on it.

     Thanks

    Mark

  • naveenj Profile Picture
    60 on at

     Hi Mark,

    Thank you for the information and thespeed at which it was delivered.
    I really appreciate that. Thanks a lot.

    Regards,
    Naveen Jose

     

  • Mark Roux Profile Picture
    670 on at

    Thanks Naveen.

    Cheers, Mark

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans