Help : "Confirmed" field in Sales Order maintenance.

[Chris Kelleher]

In MFG/PRO Sales Order Entry screen there is a field named
"Confirmed ".
I would like to know that in which table and in which field it is storing
the value of the
"Confirm" field of each sales order.

I am writing a cim update program for "Sales Order Entry", but after
executing the program it updates everything except the "Confirmed" field. It
is showing as 'no' even though the control file it has entered as "yes".
When we r entering Sales order normally it is coming as "yes".

We are on MFG/PRO version 7.4G.

Regds & thanx

 

[Chris Kelleher]

The MFG/PRO field is so_confirmed. This will prevent
the order from allocating, picking and shipping. In
addition, MRP will not recognize this as an actual
order until it is confirmed. There is a Maintenance
screen that will confirm orders. I recommend setting
that up in your CIM Load process or batch job, instead
of just flipping the flag. I don't think the proper
records will be created if you modify it through a
direct database update.

Derek M. Rodner
RODSTAR Business Consulting, Inc.
dmr@rodstar.com

 

[Chris Kelleher]

Hi,
I'm using Mfg/Pro v.7.4H which should be almost the same as your version
(7.4G), so I believe that the so_confirmed field works the same way. You
have mentioned that you have a "yes" in your control file "Confirmed Order"
field (soc_confirm). Thus, my guess is that when you do your CIM, you rely
on the default "Yes" value of the field and you simply tab over it (i.e. a
hyphen ("-") in your CIM input file). Try putting a "Y" instead.

I hope this helps.

Ron Shneor Tel: +972-3-6455148
Information Systems Manager Fax: +972-3-6474681
Radcom Ltd. E-mail: ron@radcom.co.il
<mailto:ron@radcom.co.il>
http://www.radcom-inc.com <http://www.radcom-inc.com> - for on-line product
information http://www.protocols.com <http://www.protocols.com>