How to release the whole Order base?

[vsevs]

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]

Re: How to release the whole Order base?

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]

Re: How to release the whole Order base?

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]

Re: How to release the whole Order base?

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]

Re: How to release the whole Order base?

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]

Re: How to release the whole Order base?

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]

Re: How to release the whole Order base?

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]

Re: How to release the whole Order base?

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]

Re: How to release the whole Order base?

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]

Re: How to release the whole Order base?

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.

[vsevs]

Re: How to release the whole Order base?

Hi Nick,
Can you help me on this one?

[uppiliyappan]

Re: How to release the whole Order base?

vsevs

the agent is working fine... No corrections needed...

[vsevs]

Re: How to release the whole Order base?

Hi Uppiliyappan,
Can you please send me the screenshot of Agent and actions?

Thanks,
Venkat.

[uppiliyappan]

Re: How to release the whole Order base?

Attached the screen shot.. Agent will be triggered once the external status created for this is changed..

[vsevs]

Re: How to release the whole Order base?

Thank you.