How to release the whole Order base?

vsevs · #1 (**permalink**) March 11th, 2009, 02:28

Hi,
Can anybody clarify me how to release the whole order base at once. The action has only Release lines or Ship units. We have to release it manually each line. Can anybody help me on this.

Thanks.

vidya · #2 (**permalink**) March 12th, 2009, 12:47

Hi

It can be achieved by enabling "Shippable" check box in the Line Item tab, by which a order release is generated for the whole order base.

vsevs · #3 (**permalink**) March 13th, 2009, 05:45

Hi,
Thank you for your reply. It works. But when we have many lines, like in hundreds or thousands, it is diffcult to do this everytime. Do we have any such attributes in header level?

Thanks,
Venkat.

NickTizzy · #4 (**permalink**) March 15th, 2009, 22:25

Hello,
I have created an agent for a customer that had many line before. I made it trigger when they flipped a custom status on the order base, then the agent fired and released all the lines.

vsevs · #5 (**permalink**) March 18th, 2009, 02:42

Hi Nick,
Can you help me in creating that agent. Our Planner will decide whether to create order release for whole order or not. So if it is possible by updating an external status it will be great.

Thanks.

joecallan · #6 (**permalink**) March 18th, 2009, 13:13

Another option within the UI could be to use the 'Simple Ready to Ship' functionality:

1. Go to Order Management>Purchase Order>Order Base Line/Ship Unit
2. At search screen, enter the Order Base ID and click Search
3. Select all Lines/Ship Units
4. Click Actions and choose Simple Ready to Ship
5. Click the Ship Complete button found at the bottom of the page
6. Click the Save button found at the bottom of the page

NickTizzy · #7 (**permalink**) March 21st, 2009, 12:40

Vsevs,
That agent would be an order base agent triggering off of Order Base status change. The status would be the custom status that you create we did Order Rerelease_Yes and _No. Then the actions are a direct sql update of update OB_LINE set IS_SHIPPABLE = 'Y' where order_base_gid = '$gid' this checks the shippable in all the lines. Then the next action is to Release Order Base.

vsevs · #8 (**permalink**) March 23rd, 2009, 09:04

Hi Nick,
Thank you for your update. I created an agent as you mentioned. I see the release is getting created but no quantity has been released actually. Can you please verify whether my actions are correct. Please find the file attached.

Thanks.

NickTizzy · #9 (**permalink**) March 23rd, 2009, 17:19

The only thing that comes to mind quickly is your release method. If you go into an order and do this by hand on a couple lines, does it create the release with the quantities and everything in place?

NickTizzy · #10 (**permalink**) March 26th, 2009, 12:40

I did a quick reply a while back and it looks like it didn't work, I am unsure. Anyway that is the correct setup that you have there. The only thing that comes to mind is your release method that you are using. We are using a variation of auto-calc for our ob's so I don't know if this has something to do with it.