Dynamics Community Forum Thread Details

Transaction Import Issues

We have been using Transaction Import for over a decade mostly with the inventory item maint screen. We are about to go live on SL 2015 and I'm having a hard time getting what used to work to work in SL 2015.

The first issue is that the AliasConstant functions do not seem to be recognized. In the past we would start data for level0 with the work "InventoryItem". This doesn't work in 2015 and complains about an invalid level. Changing the data file from InventoryItem to Level0 does work but we have a lot of automated processes which would need to be modified.

	case TI_Start
		call AliasConstant( "Level0", "InventoryItem" )
		call AliasConstant( "Level1", "CompanyDefaults" )

My next issue is that code doesn't seem to execute. I have a few little pieces of code in the intelligent control file. The first of which is building a proper inventory ID. We use a 5 char manufacturer code followed by the manufacturer model number. In the control file we take the mfr code, pad it out, and concatenate it model number. We are getting a message "'System Message 8013: Error In Field. Control: cinvtid Key Value:" which to me suggests the field is being set blank. Doing the calculation in excel allows this work so my current theory the VB script code is not functional. This same code works in SL 7.

const brandname =3
const brandnum = 4
modelnum = importfield(brandnum)
brand = importfield(brand)
l = len(brand)
if l < 5 then
	brand = brand & space(5-l)
end  if
brand = trim(ucase(brand & modelnum))
serr = SetObjectValue( "cinvtid", brand )

Anyone else been running TI on SL 2015? I have bundled up control, data, and error log files. Don't expect it run on your inventory maintenance screen since I have custom fields but in case anyone wants to see you can find my current test at http://intra.vcaglobal.com/public/rseiwert/ti_issue/ti_issue.zip

Quick Links

Leaderboard