I have created 2 UDT table in Sales Order Screen called MAWB (Master Airway Bill) which contains MAWB Number, FlightNo, AccountCode3, Account Name and HAWB (House Airway Bill) Which is Linked with the Master Airway Bill.
I have the following FMS to search for Master Airway Bill
select * from MAWB.
I have 2nd FMS which picks House Airway Bill
SELECT HAWB from HAWB where MAWB = $[$U_MASTER.0.0]
I have 3rd FMS which picks Flight No.
SELECT flightno from HAWB WHERE MAWB = $[$U_MASTER.0.0]
All the Above FMS are displaying the Correct Values.
In the Sales Order Main Window I need to Display AccountCode3 from MAWB Table in the Customer Code.
I have the Following FMS
SELECT account3 from HAWB WHERE MAWB = $[$U_MASTER.0.0]
When I execute the above FMS I get error message
Internal Error (3006) occurred [Message 131-183]