Order Entry -- Order Type

[johnCronin]

Can someone please explain to me the significance of the orig_ord_type vs the ord_type in OEHDRHST. When would they be different?

 

[MacolaHelp]

I have experienced this field changing when converting a quote to an order & then billing & invoicing the order, but haven't tested in other scenarios (like master order). If you convert a quote to an order, in the oeordhdr_sql you will see the reference to orignal quote #, but after you convert to an order & invoice you will see the original reference to the quote deleted in oehdrhst_sql, only the order that was created when converting from quote to order. You need to follow this order all the way through the invoicing process & report your findings to macola. I know they are currently working on the break between the orginal quote # & the eventual invoice number, but there may be other things such as master order that affect what you are seeing & you should make them aware of the break in the code. Or blanket orders, an entire new ball of wax. I just don't think most users use all the "features" macola can offer, therefore they aren't programatically well designed. Thank heavens for Peak(Tectura) for the interim source code solutions. We need to be proactive to get macola to incorporate some of these things into ES development strategies!!

 

[kscheeler]

Though I can't explain why it's set up this way, the ord_type in OEHDRHST is always going to be an 'O'. The orig_ord_type is what was used when the order was originally entered. For credit memo's, the ord_type will be an 'O' and the orig_ord_type will be a 'C'.

Kevin Scheeler