Back to connectors… Back to Sage 300...

ARCUS.Codecurn and ARCUS.Idratetype not available to IMan (4 replies)

John G
5 years ago
John G 5 years ago

Our client needs to have currency code and rate type included in new customers added to Sage 300 from IMan.  Those fields are not available in the dropdown list of Sage 300 fields in the Sage 300 connector.

I see the problem in two installations, both using IMan 4.11 and Sage 300.  The installation where those fields are required has Sage 300 Advanced 2016. The other has Sage 300 Premium 2018.

Is there a patch needed for IMan?  How can I update those fields?

 

Support
5 years ago
Support 5 years ago

John, in reply.

  1. The currency is driven by the Customer account set; there isn't a direct field you can set for currency.
  2. Rate Type Field - Yes this is missing (for some reason). We will open a ticket and issue you a patch.

Thanks

John G
5 years ago
John G 5 years ago

Codecurn is a field in ARCUS.  It's not available to IMan.

https://www.realisable.co.uk/wp-content/uploads/2019/11/mstsc_2019-11-12_13-06-24.png
John G
5 years ago
John G 5 years ago

ARCUS documented

https://www.realisable.co.uk/wp-content/uploads/2019/11/firefox_2019-11-12_13-07-59.png
Support
5 years ago
Support 5 years ago

John, whilst it may be in the data dictionary and indeed the database, it doesn't mean you can write to it via the Sage300 API (the AR0024 view).

You need to look how the Sage300 works as we follow the same logic (it's ultimately controlled by the logic provided by the API/views).

Below is a screenshot of a new customer record (before the Add/Save button is pressed). I have set the Account Set field to one which has a currency other than the Sage300 home currency.

You will notice the Currency field is not editable....this is way IMan also works.

(I sent you an update for the IDRATETYPE field).

Hope this helps.

https://www.realisable.co.uk/wp-content/uploads/2019/11/ARCustomer.png

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