Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Updating Sales Line It...
Microsoft Dynamics GP (Archived)

Updating Sales Line Item Distribution using eConnect - GP 10

(0) ShareShare
ReportReport
Posted on by Damien McCarthy 95

I am having an issue trying to change the Sales Line Item Distribution entries for orders entered into GP through eConnect. Looking at the documentation, it seems this is possible in taSopLineIvcInsert. In particular, I am trying to change the Cost of Goods Sold entry (CSLSINDX). I am passing the account number but it always sets it to what is set up in Inventory (Item Account Maintenance). I can update the field (using the account index) through SQL with no problem. I have been working through eConnect and GP with limited knowledge and was hoping to get some quick advice. Thanks in advance.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    Re: Updating Sales Line Item Distribution using eConnect - GP 10

    Hi,

    As long as you are maintaining the the Line Item Sequence Number - you should be good. I'm not 100% sure about the Dex_Row_ID - as I have never noticed - but thinking about it, it would make sense if it does change.

    The best test would be to send a simple change - such as changing the linet item description - and see does that update your line.

    Ian.

  • Damien McCarthy Profile Picture
    Damien McCarthy 95 on at
    Re: Updating Sales Line Item Distribution using eConnect - GP 10

    Ian,

    Regarding 'Its definately updating the old line and not inserting a new one?':

    I know it is definitely hitting the call with UpdateIfExists set to 1, but what is the best way to tell if it is actually updating that record. If DEX_ROW_ID is changing on each update does that mean it is doing an Insert instead of an update? I have found that it is incrementing with each update.

  • Damien McCarthy Profile Picture
    Damien McCarthy 95 on at
    Re: Updating Sales Line Item Distribution using eConnect - GP 10

    Ian,

    The CreateDist is set to 1 and we creating the header first. I tried a different change as you suggested by updating the quantity. The quantity changed but the distribution remained the same. Also as a test, I changed the distribution directly in GP, saved, and then ran the same update in the application that is using eConnect. It changed it back to the account number that was set up in Item Account Maintenance.

    Thanks...

  • Community Member Profile Picture
    Community Member on at
    Re: Updating Sales Line Item Distribution using eConnect - GP 10

    Only the distribution amounts will default at posting time.

    The distribution accounts used will be what is recorded on the invoice?

    What if there were multiple updates to the line distribution before it was posted?

    It should be possible to update the Distribution accounts on the line.

    On the Header schema - there is a CREATEDIST - is this set to '1' or '0'? Not sure if it makes a difference though (lines created first?).

    Also - create another change on the line such as a quantity change and send along with the distribution update - verify that the quantity changes.

    Its definately updating the old line and not inserting a new one?

    Ian.

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,297 on at
    Re: Updating Sales Line Item Distribution using eConnect - GP 10

    McCarthy,

    Cost of Goods sold  entry will generate when you post transaction. I would have create reversal Journal entry for Original COGS account and correct entry with new account into General Journal immediately after creating sales transaction.

    Assume that when you post Sales Transaction : 1100 COGS is Debited

    On Sales Transaction integration you create another integration with General Journal with 1200 COGS (New COGS) and Credit 1100.

    Thanks

    Sandip

  • Damien McCarthy Profile Picture
    Damien McCarthy 95 on at
    Re: Updating Sales Line Item Distribution using eConnect - GP 10

    Ian, thank you for your reply. Yes, the RecreateDist is set to 1. The UpdateIfExists is also set to 1. Would this be the proper setting when trying to update the Line Item Distributions. Previously, as a test and since I was not a 100% sure on the functionality of RecreateDist, I had  tried set RecreateDist to 0, but that didn't make a difference.

  • Community Member Profile Picture
    Community Member on at
    Re: Updating Sales Line Item Distribution using eConnect - GP 10

    Is Re-Create Dist on the Lime Item Schema set to '1'?

    You can update through SQL because SQL does not obey any of the GP business or eConnect logic.

    Ian.

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

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans