Solved

export by scenario to excel - number fields in text format

  • 14 December 2022
  • 5 replies
  • 199 views
M
Rank

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

 

 

icon

Best answer by bhalvorsen 14 December 2022, 21:43

View original

5 replies

smilner3
Rank
Userlevel 3
Badge

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.

 

M
Rank

thanks for the suggestion. We did try that and had no luck. 

smilner3
Rank
Userlevel 3
Badge

Maybe wrap the GI field in CDec() to make sure the results are decimal?

M
Rank

Tried that as well with no luck, but thanks again. 

B
Rank
Userlevel 2

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. 

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved