Back to forum list… Back to How Do I?...

Sage 300 connector disallowing insert NULL value for Item Location (No replies)

Arline Welty
10 months ago
Arline Welty 10 months ago

Can someone advise on why I can't seem to force the Sage 300 connector to map a NULL value to a line item Location value for a PO? I am able to do this in the user interface, but the connector won't allow it. I suspect that it has to do with the PO header level 'Ship to' and 'Bill to' location values being inherited at the line level but I'm not clear why I can't edit the line item value through Iman when I create the PO. 

Maybe a formula issue?

Use case: allow the Sage 300 connector to insert a value of NULL for Location when we create a PO line with a non-inventory item. 

The value is supplied from a spreadsheet with the "Location" value specified. We expect the user to explicitly declare the Location value for each line. So if a user provides a NULL value for Location, I would like the mapping to then use a value of NULL for the item location.

Current formula:

IIf(InStr(%Location, "") = 0," ", %Location )

 

The Iman job is not recognizing the NULL value. If nothing is specified in the spreadsheet, it inserts the default value for Location rather than inserting a NULL value.

Ideas?

Thank you

Arline

 

 

https://www.realisable.co.uk/wp-content/uploads/2024/01/Iman.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