Status & Selection_Cd in OE 1

[cparralesl]

Hi guys,

I need to identify what is the meaning of the contain in the Satus & Selection_Cd fields.

I have identified some in the Selection_Cd field becuase the DRMDocument, but I can not find anything to the Status field.

For example, in the Status field there is an "L". I do not know does it means.

I appreciate your help about it.

Cesar Humberto Parrales
Application Support

 

[maccrystal]

I "Assume" you mean Status and Select_CD in OEORDHDR_SQL
Status
1 = Booked Order
4 = Pick Ticket printed
5 = Confirm Pick (only if configured)
6 = Packing Slip
7 = Confirm Ship (only if configured)
C= Credit Hold
8= Selected Billing
9= Invoiced Printed

Select_CD
C = Complete order or has been unselected for Billing
I = Incomplete order (usually header no lines)
N = Usually indicates problem during billing
S = Order selected for Billing
X = Order Invoiced
Z = Order has been posted

http://www.appstratinc.com

 

[cparralesl]

Thank Maccrystal,

But there is an "L" in the Status field that I do not know what is the meaning.

Thanks again.

Cesar Humberto Parrales
Application Support

 

[rustylee]

It means "Closed". Usually it needs to be checked when doing reports because if you are doing reports for live orders, you have to exclude records with the status of L and of course the inverse is true - if you want to know what orders are closed, look for L.

-Rusty

 

[cparralesl]

Thanks Rusty,

If you can help me on how to know where is a customer order using these fields I will thank.

It is basically track the document in order to know in what departament the order is. It will help the customer service to give information about it.

Idea will be appreciated

Thanks again.

Cesar Humberto Parrales
Application Support

 

[rustylee]

Macola has built into it the ability to track an order at various stages.

1 = Booked Order
New order or order with backordered items after posting has occured.

4 = Pick Ticket printed
Self explanatory

5 = Confirm Pick (only if configured) -> you have turn the "Confirm Pick" selection on to get a status of 5. By using this you can know where in the pickingp processs an order is, but there is an extra step in Macola necessary to arrive at this.

6 = Packing Slip printed
When a packing list is printed, the status changes, much like when a picking ticket is printed. This could be used at some in the order process to determine it's location between packing and shipping.

7 = Confirm Ship (only if configured)
Like "5", you have to configure the system to get a status seven, and again, an extra step is necessary in Macola to change this status.

C= Credit Hold
Self explanatory.

8= Selected Billing
The order has been billed.

9= Invoiced Printed
In invoice has been printed after billing.

Just follow the series, and define where an order would likely be given the status. In our organization, if the status is 8, we can assume that the order has been picked, packed, and processed for shipping by the carrier. If the status is 4, we know the order is somewhere between the picking and billing stages.

The status code won't change if you don't print picking tickets, packing lists, select orders or invoice. It's a good practice to do these things throughout the lifecycle of the order when visibility of the various stages are needed.

Make sense?

 

[cparralesl]

Yes, it is.

Thanks for your help that is the information I need.



Cesar Humberto Parrales
Application Support

 

[vbajock]

Just a side question - at what point does an "L" closed order move to the history file?

 

[maccrystal]

Once the order is "Closed" it remains in the Open order file until it is purged. It is not moved to histroy. To purge the order Reports/Order status/Closed Orders.

http://www.appstratinc.com

 

[cparralesl]

I have seen that happen with those orders that the items were partially selected to bill.

Part of those items selected to bill go to the history file when posting, the rest of them stay in the transaction file and after the order is closed, the system put the "L" satus.

As a final step those orders in the transaction file have to be purged in the future.

Cesar Humberto Parrales
Application Support