SD at 559 Status Not Advancing

KKJ70

Well Known Member
We currently have many SD type sales orders that are stuck at 559 status (awaiting PO receipt). The OD order that was auto created has been received, but the SD will not advance, thus we can not invoice the SD order.

Also, some of the OD orders will not allow us to receive. In the receiving screen, the error shows "System Event still in Process", "Status Flow Not Set Up", "Status Invalid for this Order Type", and a red box appears around the Foreign select box.

Checked the Order Activity Rules and Processing Options, but nothing looks out of the ordinary.

This seems to be happening more and more.
Any ideas?
 
Hi,

It seems like the Order flow was not set up for the OD type of Orders.

You need to define the "Order activity rules" in the G4241 menu for the OD order type for that Line type and then the errors - 'Status Invalid for this Order Type" , "Status Flow npt set up" can be resolved.

Please try after setting the Order activity rules appropriately and then let us know if you still have the problem with OD orders.

Thanks
Mark
A7.3,Cum 12,One World - XE.
 
Thanks Mark for the reply.
The Order Activity Rules have been set up for this order and line type and double-checked. That is what is so puzzling on this. Below is the setup for order type SD, line type D.
Last 520, Next 559, Other 580
Last 559, Next 580
Last 580, Next 620
Last 620, Next 999
Last 999

520 Enter Sales Order
559 Waiting on PO Receipt
580 Print Invoices
620 Sales Update
999 Complete - Ready to Purge

We also have problems with receipts on the POs. Most often they can not be received, or paid. Below is the OD/D flow.

Last 220, Next 230, Other 240, 280, 400
Last 225, Next 230, Other 220, 225, 999
Last 230, Next 280, Other 220, 225, 230, 240
Last 240, Next 280
Last 280, Next 400, Other 300
Last 300, Next 400, Other 300
Last 400, Next 999
Last 999

220 Enter PO
225 Rejected Order
230 Approval Process
240 Print Purchase Order Proof
280 Print Purchase Order
300 Record Supplier Acknowledgement
400 Record Purchase Receipt
999 Complete - Ready to purge

I was not directly involved in setting up these rules, and some give us problems.
Any insight to my original issue or the settings is greatly appreciated.
Thanks!
 
I haven't got this one resolved yet.
Any other suggestions on this one?

[ QUOTE ]
We currently have many SD type sales orders that are stuck at 559 status (awaiting PO receipt). The OD order that was auto created has been received, but the SD will not advance, thus we can not invoice the SD order.

Also, some of the OD orders will not allow us to receive. In the receiving screen, the error shows "System Event still in Process", "Status Flow Not Set Up", "Status Invalid for this Order Type", and a red box appears around the Foreign select box.

Checked the Order Activity Rules and Processing Options, but nothing looks out of the ordinary.

This seems to be happening more and more.
Any ideas?

[/ QUOTE ]

[ QUOTE ]
Thanks Mark for the reply.
The Order Activity Rules have been set up for this order and line type and double-checked. That is what is so puzzling on this. Below is the setup for order type SD, line type D.
Last 520, Next 559, Other 580
Last 559, Next 580
Last 580, Next 620
Last 620, Next 999
Last 999

520 Enter Sales Order
559 Waiting on PO Receipt
580 Print Invoices
620 Sales Update
999 Complete - Ready to Purge

We also have problems with receipts on the POs. Most often they can not be received, or paid. Below is the OD/D flow.

Last 220, Next 230, Other 240, 280, 400
Last 225, Next 230, Other 220, 225, 999
Last 230, Next 280, Other 220, 225, 230, 240
Last 240, Next 280
Last 280, Next 400, Other 300
Last 300, Next 400, Other 300
Last 400, Next 999
Last 999

220 Enter PO
225 Rejected Order
230 Approval Process
240 Print Purchase Order Proof
280 Print Purchase Order
300 Record Supplier Acknowledgement
400 Record Purchase Receipt
999 Complete - Ready to purge

I was not directly involved in setting up these rules, and some give us problems.
Any insight to my original issue or the settings is greatly appreciated.
Thanks!

[/ QUOTE ]
 
I finally figured this one out.
The purchase order Receiving processing option for Direct Ship next status was set to 560, but our Order Activity Rule went to 580.

Revised the option to 580 and the update works.

blush.gif
 
[ QUOTE ]
I finally figured this one out.
The purchase order Receiving processing option for Direct Ship next status was set to 560, but our Order Activity Rule went to 580.

Revised the option to 580 and the update works.
blush.gif


[/ QUOTE ]

I now have several SD orders with a status of 559 and PO has been received.
How can I advance the status without using SQL? Or can I?
Speed or Standard invoicing was used to create invoices since the Sales Update would not function and I don't want to possibly duplicate anything in the system.

I know how to advance a status in PO's, but it appears no such option exist in sales orders?

~Kelli
 
Look at G4212 "Status Code Update" P42040
Note that this form is unusual in that it will enter updates simply by double-clicking on a row, so don't go double-clicking out of curiosity.

FYI,
Robert Berkey
B7333 SP18.1 SQL Server 2000
 
[ QUOTE ]
Speed Status Update - P42040

[/ QUOTE ]

Thank you Larry!
That helped me find it via the menus, or something like it, just hadn't looked, and didn't think it would be, under Daily Processing.

Now I have to sort out what needs to be done based on if invoices have been made or not and paid or not.

Any insight on this?

Thanks again Larry.
~Kelli
 
"Speed Status Change" is related to financials, not SD.<font color="white">.</font> <font class="small">Code:</font><hr /><pre>Select MTMNI, MZOBNM, Rtrim(MTMNTX) MTMNTX
From PRODCTL.F0083 (Nolock)
Join PRODCTL.F00821 (Nolock)
On MZMNI = MTMNI and MTSELN = MZSELN
Where MTMNTX In ('Speed Status Change', 'Status Code Update')
Order By MTMNI, MZOBNM
<font color="white">.</font>
MTMNI MZOBNM MTMNTX
G03B12 P03B114 Speed Status Change
G03B131 P03B114 Speed Status Change
G03B161 P03B114 Speed Status Change
G0412 P0411S Speed Status Change
G0413 P0411S Speed Status Change
G4212 P42040 Status Code Update
G43A13 P43025 Status Code Update
G43B13 P43025 Status Code Update
G43D13 P43025 Status Code Update
G47266 P0411S Speed Status Change
</pre><hr />
 
For SOs that were invoiced via Std Invoices you probably want to advance the status on those lines past invoicing to Sales Update (620 here). However this depends on what the process flow is in your organization.

Cheers,
 
Query to Find Menus and Parent Menus From Object Name and/or Menu Text

<font class="small">Code:</font><hr /><pre>Select
(Select Rtrim(MTMNTX)
From PRODCTL.F0083 (Nolock)
Where MTMNI = Parent.MZMNI and MTSELN = 0.0
) [Parent Menu Description],
Rtrim(Parent.MZMNI) [P.Menu],
(Select Rtrim(MTMNTX)
From PRODCTL.F0083 (Nolock)
Where Parent.MZMNI = MTMNI and Parent.MZSELN = MTSELN
) [Parent Menu Text],
(Select
Rtrim(MTMNTX)
From PRODCTL.F0083 (Nolock)
Where MTMNI = OBNM.MTMNI and MTSELN = 0.0
) [Menu Description],
Rtrim(MTMNI) Menu,
Rtrim(OBNM.MTMNTX) MTMNTX,
Rtrim(Child.MZOBNM) MZOBNM
From PRODCTL.F0083 OBNM (Nolock)
Join PRODCTL.F00821 Child (Nolock)
On MZMNI = OBNM.MTMNI and MTSELN = MZSELN
Join PRODCTL.F00821 Parent (Nolock)
On MTMNI = Parent.MZMTOE
Where OBNM.MTMNTX In ('Status Code Update') and Child.MZOBNM = 'P42040' /* or MTMNI = 'G76B' */
Order By Rtrim(Parent.MZMNI), OBNM.MTMNI, Child.MZOBNM
<font color="white"> . </font>
Parent Menu Description P.Menu Parent Menu Text Menu Description Menu MTMNTX MZOBNM
Daily Processing G4210 Additional Order Processes Additional Order Processes G4212 Status Code Update P42040
Sales Order Processing G4211 Recurring & Batch Additional Order Processes G4212 Status Code Update P42040
Sales Order Processing G4211 Credit Order Management Additional Order Processes G4212 Status Code Update P42040
Sales Order Management - Brazil G76B42 Additional Order Processing Additional Order Processes G4212 Status Code Update P42040
</pre><hr />
 
You can check in F4211 where So02 is '1'
//A value of 1 reflects that the Sales Update program (R42800) has relieved inventory and written a cardex record to the Item Ledger File (F4111)//

and DCT having R* Invoice Doc Type.

These orders are already updated thru sales update.

Remaining you can update after updating through speed status.

Alternatively you may also check the status of PO and SO
by joining and using RORN and (SO11 and NXTR)

Bala
 
[ QUOTE ]
For SOs that were invoiced via Std Invoices you probably want to advance the status on those lines past invoicing to Sales Update (620 here). However this depends on what the process flow is in your organization.

Cheers,

[/ QUOTE ]

Our next status after 580 is 620 as well.
As it was explained to me, we run the Sales Update when the sales order's next status gets to 580 - proof, then final. The invoice is created during Final Sales Update.
When I set the status to 620, I still need to run the Sales Update, correct? Hmmm .. this looks to create an issue since an invoice is to be created during final.

Currently, I am trying to work thru an AAI issue that is not allowing the Sales Update to run, so that potential invoice problem will be tackled once I get it going again.

Thanks for all the information.
~Kelli
 
Hi Kelli,

I am also facing the similar issue. SL order status is not advancing from 561 and shipment status stuck at 25 and not advancing.

Any help would be appreciated.

This issue is happening for only few orders and i am not able to replicate the issue either in QA or DV.

Below are the Order Activity Rules:


Order Type Line Type Last Status Description Next Status
SL S 520 Sales Order Entry 557
SL S 524 BATCH PREPAYMENT AUTHORIZARION 557
SL S 525 NYP ORDER HOLD 557
SL S 532 GOLDEN TITLE HOLD 557
SL S 534 REMAINDER STAUS HOLD 557
SL S 539 PENDING B/O RELEASE 557
SL S 541 STATUS TO CANCEL ORDER 999
SL S 555 REROUTING 559
SL S 557 REROUTING 559
SL S 559 WMS DOWNLOAD 560
SL S 560 SHIP CONFIRMATION 561
SL S 561 JDE SHIP CONFIRM 571
SL S 566 SHIP CONFIRM PAPER 620
SL S 571 FREIGHT UPDATE 580
SL S 577 PACK REEVALUATION 580
SL S 580 Print Invoices 620
SL S 620 Sales Update 999
SL S 999 Complete - Ready to Purge

As you mentioned that you have figured the issue by changing the processing option for Direct Ship next status in purchase order receiving. Could you please let me know the program name.

Thanks in advance,
Regards,
KPK
 
Back
Top