The issue is that you may have 1:N:N record links from your Invoice => Delivery => Sales Order. If you know that its always a 1:1:1 link then express the direct links under the environment section of the object definition.

If the 1:1:1 relationship does not exist, then you can always write a function that returns the Sales Order number, to do that remove the table and field column in the selection grid, and in the expression call you function, "func SPESIH.GET_SOH([F:SIH]NUM)", and the variable type is text. 

Hi there,

In SINVOICE, there is a field called SIHORINUM. If you go through deliveries into the invoice, it should populate with a single delivery number only. I have not come across a scenario where multiple deliveries are tied to a single invoice. In terms of sales orders, yes there can be multiple deliveries and invoices per order, but with only one delivery per invoice, you can use SIHORINUM to call the SOHNUM that is tied to the delivery, using INTFLD, whcih you can put as an expression at the bottom of the SIH object in the expression field on a new line:

func AFNC.INTFLD('SDELIVERY','SOHNUM',[F:SIV]SIHORINUM)

The result: 

For anything that isn't tied to a delivery, then Order no. would just be blank.

Let me know if you need more help with this. If you can give some example where an invoice has multiple deliveries, I could work out a more complex code for you that could work as well.

Zoey

We just tried to add it as you described, but it throws a field error "Incorrect link". Any suggestions? 

Hello Kelsey Rendon 

There should be no value in the table or field spots in the selection fields there. It is a custom expression. The expression should be put the selection tab of the object SIH which is shown in your second picture, sorry if that was not clear. Please remove the automatic link and line #2 in your selection fields where it says SDELIVERY, then at the bottom of the selection fields, you can set it up like this. Once you have confirmed it works, then you can move it to a higher row number in the selection fields. Also please make sure to include "func" before AFNC:

func AFNC.INTFLD('SDELIVERY','SOHNUM',[F:SIV]SIHORINUM)

func - declared this to run a sub function

AFNC - name of the src file

INTFLD - name of the function (INTFLD returns a value)

SDELIVERY - table to read

SOHNUM - field to return

[F:SIV]SIHORINUM - Simple key used to read SDELIVERY table, passed through from the existing SINVOICEV table that is already open in the SIH object

*Updated the table name as per Regard Hulsbos  (my mistake)

There is no link to make because we are not opening a table to read in the window itself, or creating a link to it, we are just reading and returning a specific value using a sub function that is built in.

Please let me know if it works

Best,

Zoey

Also be mindful of the table you are referencing, the column SIHORINUM is on table SINVOICEV and not SINVOICE. 

func AFNC.INTFLD('SDELIVERY','SOHNUM',[F:SIV]SIHORINUM)

Thanks so much for this; your explanation was really helpful and it worked perfectly!

Best,

Kelsey

Hi Kelsey Rendon 

I'm glad it worked! Please consider marking an answer as verified if it is correct!

Best,

Zoey

Thank you Zoey :) 

Thanks, Regard we noticed that as well.

Hi Zoey Mattison ,

Although we have added the column, and can sort by it, we can't seem to filter by it. Any suggestions? 

Found a better solution that allows us to filter by the added column. 

Go to Development>Script Dictionary>Objects and add the link to the Environment Tab

Once the link has been added, in the selection tab you can add the field.