Evening IFS Experts!

I wonder if any of you can help me with a migration challenge…

In IFS Apps 10 Aurena, manually adding a line to an Instant Invoice causes the “Tax Code” field to be auto populated. Our Sales Objects have no tax code on them, and so the Tax Code is taken from “Customer (page) > Address (section) > Delivery Tax Informant (tab) > Taxes (group) > Tax Code (field)”.

When we migrate an Instant Invoice line, we need to replicate this function (i.e. the migration job also needs to read the Tax Code from “Customer > Address > Delivery Tax Informant”) but I’m struggling to work out how to do that.

The field help for “Migration (page) > Source mapping (tab) > Default Values (field)” explains that SQL can be used and gives the following examples…

substr(SOURCE_COL,1,25)

decode(SOURCE_COL _1,'Y','Yes','N','No','No')

Part_Catalog_API.Get_Description(SOURCE_PART_NO)

Intface_Method_List_API.Get_Sequence_No('<sequenceName>','<valueType>') 

I was hoping to find an API call that returns the tax code from the customer address. Something like…

Customer_Info_API.Get_Tax_Code(customerID, AddressID, CompanyID, Date)

However, I was unable to find any such API call? 

I tried using a Select statement in the “Default” field instead...

select FEE_CODE from CUSTOMER_DELIVERY_FEE_CODE CDFC where COMPANY = 'XXXX' and CDFC.CUSTOMER_ID = CUSTOMER_ID and Address_ID = (select DELIVERY_ADDRESS_ID from INSTANT_INVOICE II where II.Invoice_ID = INVOICE_ID)

However, this resulted in the migration job failing to validate.

Does anyone have any advice on how we can obtain the correct TaxCode within the migration job?

Thanks in advance