Microsoft Dynamics Job Openings


Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics SL (Solomon) > SL - Customization and Integration
  New Posts New Posts RSS Feed - Object Model-how to query Hdr/Dtls then Append Dtl
  FAQ FAQ  Forum Search   Register Register  Login Login


Object Model-how to query Hdr/Dtls then Append Dtl

 Post Reply Post Reply
Author
Message
jansuan View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: March 08 2012
Location: USA
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote jansuan Quote  Post ReplyReply Direct Link To This Post Topic: Object Model-how to query Hdr/Dtls then Append Dtl
    Posted: April 12 2012 at 3:09pm
Hi gurus,
 
I have a VS2005 VB.Net object model window that loads data from an Excel to an SL windows (a window with Hdr and Details). The Hdr's primary key field (Batch_Nbr) value is generated internally by SL system. For exceptions, my code will send the bad records with reasons to "Exceptions" sheet in the Excel. User will then make correction and then recycle corrected Excel back to the same process.

It is required that when running my object model on corrected data, I need to append these records to the same (Batch_Nbr) generated from the 1ST run.

My code runs fine on the 1ST run when both Hdr and Details are new records. However, on the 2nd run against corrected data, how to code object model so I can query Hdr/Details, then append Details?

Can someone help me out?

Thanks,

Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com