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

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

Arline Welty
9 months ago
Arline Welty 9 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