Question

Purchase Receipt to Purchase Order Header - Document Connection

  • 29 April 2021
  • 2 replies
  • 175 views

Userlevel 2
Badge +4

Hi 

 

I'm trying to setup a media connection from purchase order receipt to the purchase order header. 

This is so we can scan delivery notes via the camera functionality on the WaDaCo receipt arrival process and the PL team can then see this in attachments. 

 

Can anyone possibly help with the transformation method on this?

 

thanks 

 

Nick 

 

 

 


This topic has been closed for comments

2 replies

Userlevel 2
Badge +4

There are two ways that I know of to set this up.  Both approaches use the Object Connection Transformations located under: Application Base Setup > System Setup > Object Connection Transformations.


The first way works when an existing relationship is already established in the system.  Since you are going from PurchaseReceipt to PurchaseOrder, you may be able to get it to work by double clicking in the Transformation field and filling in the order_no as the only field.  It would be a source of PurchaseRequest and a target of PurchaseOrder for a DocReferenceObject type service.  You can set the other parameters per your requirements.  Anything attached to the purchase requisition will then be available on the purchase order.

 

The second way is by create a utility package and deploying it to the database.  You can scroll through the other transformation methods you see in this screen to find an API to use as a template.  You would need to have the rights to publish packages to the database or develop in a development environment and submit to IFS to packaged into a delivery to deploy to production.  

Userlevel 2
Badge +4

Hi 

 

The first way was the route ive been trying but the issue is on the purchase order not having LINE_NO.