DMT Closed Order

To do via dmt you would have to replicate the process used in the client.  if you can open release, then open line, then open order, then change sales rep, then close the order again in the client it should work in dmt. Each would be a separate dmt file.

 

Since these are already closed, you can dmt the needed information into a ud table and then update the OrderHed with a bpm on the ud tables update method.

 

I think the code below should work. I have not run, but I have used similar when we did our data migration.

 

Greg Payne

 

 

/* Update from UD15 */

 

               

For each ttUD15 where (ttUD15.rowmod = 'A' or ttUD15.rowmod = 'U') and ttUD15.Company = cur-comp.

 

           For each OrderHed where OrderHed.Company = ttUD15.Company and string(OrderHed.OrderNum) = ttUD15.key1.

                                If Available Orderhed then Do:

                                                               

                                                OrderHed.SalesRepList = ttUD15.key2                                 

                                                OrderHed.RepRate1 = 100.00.                                  

 

                                                Message "DEBUG Updating Rep list for " + ttUD15.key1 + "  " + ttUD15.key2 .

                                                                               

                                End.  /* End Valid orderHed  */

       

      End.

                                                                                               

End.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of senske3@...
Sent: Friday, April 04, 2014 10:12 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: DMT Closed Order

 

 

Tom -- we tried and couldn't figure it out --- I would be very interested to know what you find out on this one.
Can anyone help us?



CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
I am trying to DMT a primary salesperson (OrderHed.SalesRepCode1) into legacy orders.  The DMT is not working because the orders are closed.  I have tried updating openline, openorder, and openrelease, to open the orders via DMT without any success.  Has anyone ever done something like this before?  Is it possible?
Tom -- we tried and couldn't figure it out --- I would be very interested to know what you find out on this one.
Can anyone help us?