import error on using 'Demand forecast entries' in Microsoft Dynamics 365 Finance and Operations

import error on using 'Demand forecast entries' in Microsoft Dynamics 365 Finance and Operations

This entity 'Demand forecast entries' is used to import demand forecast

I was getting error on primary key violation even on having unique numbers provided in column FORECASTENTRYNUMBER

even in auto generation D365FO gives same error

What problem was happening is the number sequence format must match and the series as well, once fixed import goes in well