I have created a UDF in the IM_ItemCustomerHIstoryByPeriod table to store the item unit sales forecast.
I want to import the forecast qty to this field, but any item that has never been sold to the customer does not have an existing record, so can't import the forecast.

I notice that in VI, the Qty sold is not a field you can import to on the IM_ItemCustomerHistoryByPeriod table. 
Is there a way to create a record for zero sales qty and dollars so that I can import the forecast qty?