trying to export a GI via an export scenario so that it can be automated to be exported weekly.
when I export the data directly from the GI, all of the number fields keep the number formatting in excel.
When I export the GI data using the export scenario, the number fields go into excel as text format.
below is one of the feilds from the GI
here is the data field detail from above:
=[SOLine.BaseOpenQty]*[UOM8IN.UnitRate]
below are the settings on the data provider used in the export scenario
Best answer by bhalvorsen
My next try would be to clear out the schema field in the GI. I can’t remember if float is an available data type in export scenarios, if it is I’d try that too.
Have you looked into the formatting of the file associated to the data provider? I’ve seen where that file format takes precedence over the export setting.
My next try would be to clear out the schema field in the GI. I can’t remember if float is an available data type in export scenarios, if it is I’d try that too.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
