Question

Mass update multiple PO lines across various purchase orders

  • 20 July 2023
  • 3 replies
  • 134 views
Mdangelo
Rank
Userlevel 4
Badge +8

Hello IFS Experts, hoping someone can provide a recommendation.

We have international containers that come in that contain multiple po lines from various POs. 

When we receive updates on changes in planned arrival dates, we want to mass update all po lines across all purchase orders using one mass change.  We understand that you cannot mass update using PO Lines, which would be ideal, but this is not standard IFS functionality. It is very time consuming when we have to update potentially 50+ various lines across many purchase orders.

Does anyone have ways which they have found to do this even if through a customization?

 

Michelle DAngelo, Caldwell Manufacturing Company

3 replies

ROVECH
Rank
Userlevel 3
Badge +6

Hi Michelle, you could configure a custom event on the PO Lines view with a PL/SQL script action that does the modification on the PO lines. If you can define a search that enables you to select all relevant lines, then you can execute the customer menu and do the planned arrival date change.

Regards, Roel

J
Rank
Userlevel 4
Badge +9

We have the same requirement in intercompany scenario, when we ship components from Austria to Canada or US locations.This is always a mix of po-lines from different PO’s

We send dispatch advices (delivery note) per container..Dispatch advice contains the shipping container ID. Expected arrival dates of containers are communicated from our shipment forwarder.

We have done a small customization on the incoming dispatch advice. The Buyer in Canada has a customized field to save the expected arrival date of the container. A RMB function is used to update the planned arrival dates on the connected purchase order lines. 

That gives most accurate planning data on all purchase order lines immediately after containers are leaving from Austria, already 4 to 6 weeks before arrival.

Regards Johannes

 

Mdangelo
Rank
Userlevel 4
Badge +8

I do like both options. 

As for response from JohannesWittwer, we are also going to use the Incoming Dispatch Advise. We just learned of that recently and will help us greatly and we also have an update to po lines.  BUT, we must create the shipment from there and then receive into arrival because we must book that own the material that is in transit. Therefore, once we receive the Incoming Dispatch into arrival, we then cannot change that planned delivery date any longer. So we are trying to find another way.

The response from ROVECH, I may be able to do if we can run a script using a search for the Delivery note number that resides on the PO lines.  I will work on testing this. 

Thank you both for your feedback.

Michelle DAngelo, Caldwell Manufacturing Company

Reply


Terms & ConditionsCookie settings