Yes, possible but only in 3.2 or 4.0.

https://www.realisable.co.uk/support/documentation/sage-300-user/supported-import-types/order-entry.htm#O/E3

Very cool. Thank you!

Ok I'm at the correct version and looking for a little advice about how to get the shipments that have been created against a single order all joined into a single concatenated field. Is there an example I could reference? If not could I get some advice?

So far I've:

Done a DB read to pull the relevant shipments and orders

Added a MAP transform to add a new header field, 'SHIPMENTS' - this is where I'm wanting to concatenate the list of shipments, stored in the 'ShipNo' field.

HIERARCHY - Hierarchized by Order number, effectively grouping the shipments by order number

FLATTEN - I was thinking I'd need to do this to make the 'ShipNo' field appear at the header level.

I'm just looking for some advice to get me pointed in the right direction at this point. There could be 2 or there could be 8 shipments against the order. How do I tell IMAN to grab any ShipNo field associated with this order and separate with a comma?

Thanks for any suggestions.

Arline, try the following steps:

1. DB Read - No changes.
2. Hiearchy Transform - Create the hierarchy as if you're creating the invoice. If you're creating a single invoice against multiple shipments hierarchise the data so that you have the invoice (header) with all the lines from the shipments you wish to invoice.
3. You need to specify each of the shipments that you wish to invoice. In a map transform use the consolidate function. I.e. 

   Consolidate("ShipmentNumberField", "DetailLevelId", ",")

   This function will return all the shipment numbers delimited by a comma. There will be duplicates, but don't worry about these.

4. In you Sage300 connector map the field created in the previous step to the Shipment Number field on the header. If you need to map the details you can, but it's not mandatory.

Thanks for the advice- couple clarifications.

I'm assuming you mean Concatenate function? I didn't find anything on the Consolidate function and when I tried it, IMAN threw an error that the function was invalid.

I had given Concatenate a try yesterday and ran into issues- maybe I'm still doing it wrong. I have the SHIPMENTS field on the header. The SHIPMENTS field is where I want to have my string of ShipNo values separated by a comma.

I tried this on the detail and header lines but still need a little help please with the formula for the SHIPMENTS field. I've tested with a few versions of the below:

Concatenate("%ShipNo", "Shipments", ",")

Concatenate(%ShipNo, "Shipments", ",")

Concatenate("%Shipments.ShipNo", "Shipments", ",")

Image attached. I don't get why  the "ShipNo" field is invalid. Thanks for any ideas!

Arline

Arline, yes Concatenate, apologies.

Alter your function to:

Concatenate("ShipNo", "Shipments", ",")

The aggregate function requires the name of the field it's referring not the value of the field.

I must be close but now it's telling me "Object Required". So something is still not right in that formula- help?

Error whilst evaluating field [SHIPMENTS] on transaction type [Shipments].
Resolved Function - Concatenate("SH1025828", "Shipments", ",")
Error - Description: Object required

You just want it in the header.