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) / 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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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.

  • Damien McCarthy Profile Picture
    Damien McCarthy 95 on at

    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.

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    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

  • Community Member Profile Picture
    Community Member on at

    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.

  • Damien McCarthy Profile Picture
    Damien McCarthy 95 on at

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

  • Damien McCarthy Profile Picture
    Damien McCarthy 95 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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.

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