1

Under the Date Migration from the Excel to the Business Central. We have two options either the Edit in Excel or the Configuration Packages. However, under both the options, the excel need to be perfectly managed without any single error like Drop down option not filled properly, Character length is exceeding than permissible. Corrections of these errors take many efforts and time. The following idea has been suggested as mentioned below to overcome this problem:


Whenever the excel is downloaded from the Configuration Package or Edit in Excel Button, the excel should be downloaded in the following manner as mentioned below:


01.  Field having character length limit: The downloaded excel must be restricted to enter the data more than specified limit in such specific field.


02.  Field having multiple value like City, Country Code in Customer card: The master data maintained in the Business Central must be provided under the Drop-Down Options in the Downloaded Excel from Business Central.


03.  Fields having limitation of field type like Proper date syntax in the posting date / order date: The downloaded excel must not accepted any value in the line-item other than approved under the business central.


04.  The field having No. Series in the excel: The configured No. series as mentioned in the No. Series Setup should be only allowed to enter in the Excel File and any value contradicting the same should not be allowed to mention in the Downloaded Excel.


I strongly recommend you all to support this for the easy and hustle free Data Migration.

STATUS DETAILS
New