Solved

show an invoice in an order

  • 6 September 2022
  • 2 replies
  • 93 views
D
Rank
Userlevel 2
Badge +5

Hello community,

I have a document attached to a customer invoice (CustomerOrderInvHead) and I want to show this document also in the attachments of a customer order (CustomerOrder). I tried to use Object Connection Transformations, but I could not find the INVOICE_ID in the Target LU Key list. 

Which transformation method should I use to link the documents from invoice to customer order ?

Can I use SQL ? if yes, how to do it ?

Thanks in advance for your help!

icon

Best answer by Mayura Wasantha 6 September 2022, 10:34

View original

2 replies

Mayura Wasantha
Rank
Userlevel 7
Badge +15

Hello community,

I have a document attached to a customer invoice (CustomerOrderInvHead) and I want to show this document also in the attachments of a customer order (CustomerOrder). I tried to use Object Connection Transformations, but I could not find the INVOICE_ID in the Target LU Key list. 

Which transformation method should I use to link the documents from invoice to customer order ?

Can I use SQL ? if yes, how to do it ?

Thanks in advance for your help!

Do you have access to the Product Documentation. Specifically the “About Object Connection Transformation “ page?

/ mayura
D
Rank
Userlevel 2
Badge +5

Hello community,

I have a document attached to a customer invoice (CustomerOrderInvHead) and I want to show this document also in the attachments of a customer order (CustomerOrder). I tried to use Object Connection Transformations, but I could not find the INVOICE_ID in the Target LU Key list. 

Which transformation method should I use to link the documents from invoice to customer order ?

Can I use SQL ? if yes, how to do it ?

Thanks in advance for your help!

Do you have access to the Product Documentation. Specifically the “About Object Connection Transformation “ page?

Hello Mayura,

Yes, I didn’t notice that there’s explanation. 
I think I got the answer for my question. Thanks!

“For some scenarios it is not possible to map the target and source columns due to the fact that the source columns are not included in the target database view. You then have two options which both require some programming work. You can either extend the target view with the necessary columns or create a stored function that makes the actual key transformation. The name of the function should in this case be registered as the transformation method. Note that it should also hold the package name, e.g. My_Package_API.My_Transformation. It needs to be defined as a function that returns a string value. It also requires two values in parameters (strings); the Target Key Reference and the Service Name (in that specific order).”

 

Reply


Terms & ConditionsCookie settings