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
jansuan View Drop Down Member 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?


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

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