Order Status Codes

[TXejh]

I am getting some order status codes that don't seem to be listed in the help section. Does anyone know what a status of "N", "S" or "P" in select_cd for 7.5.103f on SQL means? I'm getting locked out of some orders during confirm ship and am trying to figure out the issue(s)

 

[vbajock]

those sound like Select codes

 

[TXejh]

They may be, but they seem to be the same code that is showing in the status code field on the OE screens so I wasn't sure plus I don't understand what they mean since they aren't listed with descriptive info anywhere that I can find!

 

[MacolaHelp]

C=Order Complete I=Incomplete N=Order Not OK
S=Order Selected X=Order Invoiced Z=Posted

This information is available in the tcol75.zip that shipped on one of the CDs. It may even be installed in your technote folder. If not, you can download the files individually from the support/reference library section. If you don't have current support or access to the customer portal, post your email & I'll send you the docs.

 

[TXejh]

Ok I'll look for that on my Cd(s)...it isn't in my technote folder and my support is current so I shouldn't have a problem finding it. However...I would like to know what causes an order to get a status of N and how that gets corrected other than deleting and starting from scratch

 

[MacolaHelp]

This field is in oeordlin_sql.select_cd. I tried one of my databases & there was only 1 record w/N in this field. It happened to be an order that was partially shipped (shipped 4, 8 total on the order) & it was a PP/pull item, so qty to ship is = 0 while the qty ordered shows 4 right now waiting for production to complete the 4 remaining items. There may be other conditions that created an N in this field. It's probably a macola support question. The docs I told you about give you the valid values for the fields, not necessarily what conditions produce the values.

 

[kscheeler]

If you are getting locked records, I would run the following script in query analyzer. This will tell you which records Macola is locking and which user is using that record.

====================================

--Sets the database to the locking database
use msllockdb

--show's the user(session id), table and row (ie: order no, item no)
--you can also add dbname if you have multiple companies
select sessionid, tablename, rowid
from maclocks
go

--system command to show all users attached to SQL by spid (sessionid) and what login
--name is using that spid. First, have that user log out of the screen that most likely has
--the row open that is locked.
sp_who

=====================================

Kevin Scheeler

 

[TXejh]

Thanks for that script I'm sure it will come in handy!

In this situation I'm not actually having an issue with locked records at the DB level but rather the ship confirm process didn't complete properly due to a COM/ADO error in MACMSS.dll which then essentially makes the order unavailable. In looking in the OEORDLIN_SQL to see if I could identify anything out of the ordinary I was seeing those codes but couldn't find any description as to their meaning...

 

[MacolaHelp]

It appears that the N flag is set whenever there is a partial shipment against a line item. When you get the errors during confirm ship, what status are the orders before confirm ship? 1 booked, 4 picked, 6 packed? If the items are stocked & controlled the problem may actually be in the iminvtrx file where it is trying to remove the allocation record & replace w/issue records. Or in trying to create the GL entries. Does it set the order to incomplete when it fails? Is that what you mean by "unavailable"?