I am trying to create a GI that pulls the sales orders as well as the PO orders tied to them to the same GI but I am having trouble figuring out how to properly link these two tables in relations to get the data to pull properly.
I am trying to create a GI that pulls the sales orders as well as the PO orders tied to them to the same GI but I am having trouble figuring out how to properly link these two tables in relations to get the data to pull properly.
Best answer by dcomerford
You will need to join the SOLineSplit to the SOLine
The join the POLine to the SOSplitLine
You can join the POORder by
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.