Back to connectors… Back to Sage 300...

The field [OEORDH].[TERMTTLDUE] contains more decimals than the currency code [USD] allows. (1 reply)

Jay Converse
7 years ago
Jay Converse 7 years ago

Hi, we're receiving the above error.

This is only occurring on a single site.

Support
7 years ago
Support 7 years ago

Jay, there is a small deficiency in the Sage300 API which doesn't auto round the value to the number of decimals for the currency.

Typically this is caused by a discount amount either on the order header (INVDISCAMT).

Try placing a Round function on the discount amount field in a Map transform prior to the order import.

Thanks

 

Contact

    Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

    Looking to purchase IMan, please see our resellers here.

    Realisable Software
    Ph: +44 (0) 208 123 1017

    Copyright © Realisable. All rights reserved.
    Realisable is a registered trademark

    Close

    Request Demo

      Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

      Looking to purchase IMan, please see our resellers here.

      Realisable Software
      Ph: +44 (0) 208 123 1017

      Copyright © Realisable. All rights reserved.
      Realisable is a registered trademark

      Close

      Access Downloads

        Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

        Looking to purchase IMan, please see our resellers here.

        Realisable Software
        Ph: +44 (0) 208 123 1017

        Copyright © Realisable. All rights reserved.
        Realisable is a registered trademark

        Close