# 856 SN105 won't accept numericFormat?

**URL:** <https://techcommunity.softwareag.com/t/856-sn105-wont-accept-numericformat/110438>\
**Category:** Forum\
**Tags:** EDI\
**Created:** [October 5, 2012, 9:01pm UTC](https://techcommunity.softwareag.com/t/856-sn105-wont-accept-numericformat/110438 "2012-10-05T21:01:03Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![irfanjamal](https://avatars.discourse-cdn.com/v4/letter/i/cdc98d/32.png) [@irfanjamal](https://techcommunity.softwareag.com/u/irfanjamal)\
**Post date:** [October 5, 2012, 9:01pm UTC](https://techcommunity.softwareag.com/t/856-sn105-wont-accept-numericformat/110438/1 "2012-10-05T21:01:03Z")

</div>

I am trying to map an 856 document from a flat file. After mapping the “number of pieces ordered” into SN105, I then have another step to convert SN105 to a numeric format (pub.string.numericFormat)…

The value still comes out as “9.24E2” rather than 924. I vaguely remember reading somewhere that this field has that format (scientific notation) but is there no way to override this?

Ps - if the field is not meant for this value, it is irrelevant, as the customer wants the pcs ordered to be placed here, so I need some sort of solution…

Thanks,

I. Jamal

---

<div class="post-metadata">

**Author:** ![reamon](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@reamon](https://techcommunity.softwareag.com/u/reamon)\
**Post date:** [October 6, 2012, 5:18am UTC](https://techcommunity.softwareag.com/t/856-sn105-wont-accept-numericformat/110438/2 "2012-10-06T05:18:54Z")

</div>

One way is to turn off the use of the formatting services for EDI. In IS Administrator, go to EDI under Solutions. Click Configure Field Formats. Set isEnabled=false. Review the EDI User’s Guide for more info.

---

<div class="post-metadata">

**Author:** ![irfanjamal](https://avatars.discourse-cdn.com/v4/letter/i/cdc98d/32.png) [@irfanjamal](https://techcommunity.softwareag.com/u/irfanjamal)\
**Post date:** [October 10, 2012, 6:36pm UTC](https://techcommunity.softwareag.com/t/856-sn105-wont-accept-numericformat/110438/3 "2012-10-10T18:36:29Z")

</div>

We have about 200+ mappings that probably use the field formatting in some way…if I turn it off, I would need to go through those and add custom formatting…  
Is there no other option?

---

<div class="post-metadata">

**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\
**Post date:** [October 10, 2012, 7:08pm UTC](https://techcommunity.softwareag.com/t/856-sn105-wont-accept-numericformat/110438/4 "2012-10-10T19:08:27Z")

</div>

> [@irfanjamal;86645](#):
>
> We have about 200+ mappings that probably use the field formatting in some way…if I turn it off, I would need to go through those and add custom formatting…  
> Is there no other option?

No you shouldn’t have any issues with other maps…but I would say first turnoff section below in a lower level environment (DEV/QA) and test it:

\<FormatService name=“formatDecimal" isEnabled=“true” internalFormatString=”#.##########" externalFormatString=“#.#####E0” applyFormat=“false”/\> —\> from true

HTH,  
RMG

---

<div class="post-metadata">

**Author:** ![reamon](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@reamon](https://techcommunity.softwareag.com/u/reamon)\
**Post date:** [October 12, 2012, 6:02am UTC](https://techcommunity.softwareag.com/t/856-sn105-wont-accept-numericformat/110438/5 "2012-10-12T06:02:32Z")

</div>

The docs cover the level of control you have via configuration.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:06pm UTC](https://techcommunity.softwareag.com/t/856-sn105-wont-accept-numericformat/110438/6 "2021-04-02T15:06:10Z")

</div>


