By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
1
Posts
1
Users
1
Reactions
925
Views
December 14, 2022 11:58 am
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
