Quote to sales order BPM

Yahoo Archive
1
Epicor support helped me out with this one - this is what they sent me.... works great!

------------------
Create a new Post Processing Directive, leave conditions blank, click Actions and select Synchronously execute 4GL code (Note the username will need the Advanced BPM user checkbox checked in user maintenance to use this).

Click the 'Code' link and select the first radio button to perform the code below: Paste this into that box:

/* Copy UD fields from QuoteDtl to OrderDtl */

for each ttquotedtl where ttquotedtl.RowMod = "" , each orderdtl whereordernum = orderdtl.OrderNum:
run lib\updatetablebuffer.p(input buffer Orderdtl:HANDLE, 'Character01',ttquotedtl.character01).
run lib\updatetablebuffer.p(input buffer Orderdtl:HANDLE, 'Character02', ttquotedtl.character02).
run lib\updatetablebuffer.p(input buffer Orderdtl:HANDLE, 'Number01', ttquotedtl.Number01).
/* Etc..
Provide all UD fields to be transferred in this fashion.
*/
end.


Use the format for copying fields over as I have demonstrated (best to just copy and paste and change the Fieldnames and ttTable.Fieldname for
each you want copied. OK back out of these windows, check the enabled checkbox and save yourdirective.

------------------


Thanks,
Kunal




________________________________
From: Kunal Ganguly <kunal_vantage@...>
To: Vantage Yahoo Group <vantage@yahoogroups.com>
Sent: Wednesday, July 8, 2009 3:25:39 PM
Subject: [Vantage] quote to sales order BPM





Hello,

We have some specific data in ShortChar01 in quotehed and detail that needs to be transferred over to orderhed and orderdtl in the same field once the quote is converted to a sales order. Is there an easy way to to this via a BPM. I strongly suspect some 4GL may be needed.

Thanks,
Kunal

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
2
Hello,

We have some specific data in ShortChar01 in quotehed and detail that needs to be transferred over to orderhed and orderdtl in the same field once the quote is converted to a sales order. Is there an easy way to to this via a BPM. I strongly suspect some 4GL may be needed.

Thanks,
Kunal





[Non-text portions of this message have been removed]