How Can I Link These Records?

Hi,

I’m trying to link two Navision tables, but I’m getting a #Value! Error. This is the first time I’m attempting to link two different tables that have related information so any help that would be able to help me solve this error is greatly appreciated. Below is the specifics of what I’m doing and the desire result.

Desired Result:

• I want to see a data dump of all the items with purchase prices and link those records to the related unit price that resides in the sales price table


Criteria Currently Used that’s creating the error:

Column/Row
• D9= Links:
• E9: ∞||"Purchase Price","Item No.","=Item No.","InclusiveLink=","∞||""Sales Price"",""Item No."",""=Item No."","""","""","""","""","""","""","""","""","""","""","""","""","""","""","""","""","""",""""","","","","","","","","","","","","","","","",""
• F9: ∞||"Sales Price","Item No.","=Item No.","","","","","","","","","","","","","","","","","",""

• Headers: E10: Item No. F10: Description G10: Description 2 H10:Minimum I10: Cost Quantity J10:Cost Currency Code K10:Start Date L10: Ending Date M10: Unit Price N10: Location Code

• Fields: E11: Item No. F11: Item Description G11: Item Description 2 H11: Minimum Quantity I11:Direct Unit J11: Cost Currency Code K11:Starting Date L11:Ending Date M11: Unit Price N11: Location Code

• Table: =NL("Table","Purchase Price",$E$11:$M$11,"Headers=",$E$10:$M$10,"TableName=","purchase price","Filters=",$C$5:$D$7,"InclusiveLink=purchase price",$E$9)

Result: #Value!


Final Note: The JFX is saying: Invalid field “Unit Price”