Irina Kon Posted August 6, 2019 Share Posted August 6, 2019 I have an integration going from Dynamics CRM to Dynamics NAV. I'm inserting a Sales Header followed by Sales Lines.I'm using Skip if Repeated to properly insert the header and the lines and that all works fine. However, I need to be able to do an additional step and update a flag on the header when the last line is inserted but no combination of ROWNUM() and SUMROWS that I have tried seems to work as SUMROWS only adds individual lines as they are processed. I can't seem to find any method that will give me either a total row count or identify that this is the last row. I'm sure this is a common scenario but can't quite figure out the combination of functions to make it happen. Any help would be much appreciated. Link to comment Share on other sites More sharing options...
Audrey Buettner Posted August 26, 2019 Share Posted August 26, 2019 What is the source-- are you using the CRM publisher to create an XML If so use ScribeChildCount=ScribeChildNum to know it's the last record. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now