In your test company, I suggest hand keying in a few of your transactions, then use Visual Integrator to export the data; that way you will better understand how the data is formatted.  IM_PriceCode types are 0=Price Code Record, 1=Item Price Record and 2=Item/Customer Price Record. Look at how you set the import for the Price Code Record Type.  

Ok good suggestion will try. The weird thing is I have run many and created a few VI jobs and I didn't have to do anything with Record Tab/record type.. wondering why this one requires it.. 

Pricing data structure in IM_PriceCode is not intuitive, and in VI you have to duplicate all the normal column data (when pricing data of that type is created normally via the Sage client).  That has nothing to do with the Record tab in VI.

what is or is there a difference between the price code record and price code I see both these fields ..

PriceCodeRecord is a data field tagging the record type in IM_PriceCode.  Users never see this value, and it needs to be the correct value for the record type you are adding.  Enter a pricing record manually, and mimic the column value that Sage adds to the table's raw data.

PriceCode is the value seen in Sage screens.

https://help-sage100.na.sage.com/2023/FLOR/index.htm#File_Layouts/Inventory_Management/IM_PriceCode.htm

If you see values in the field other than 0,1,2... that just means the help files are not fully accurate (or you have an enhancement that changes things).  Use the value that the Sage program adds to the table on your system.