Cannot map custom string field containing value in CIG Mapping tool

rshishmanyan — Wed, 29 Nov 2023 08:11:52 GMT

Dear Experts,

I am struggling with mapping a custom field in AdvancePaymentExportRequest. Our customizations consultant has created a new custom field in the Advanced Payment creation in B&I UI which is for Tax Amount for the line items. Since I read the CustomMoney segment can't be mapped because it's a complex structure, we created a CustomString field which copies the value from the Amount field in the source, under the TaxAmount segment.

However, I cannot map the CustomString field properly - no value seems to be transferred to the outbound XML. Please see below example, I aim to copy the mapping of APMTTaxCodeExport and I want the value to be transferred for each line item.

Expected result:

example with custom field <CustomString name="APMTTaxCodeExport">V1</CustomString>

Actual:

Aim is to map the custom field <CustomString name="LineItemTaxAmountExport">128.26</CustomString>

in the same way as the APMTTaxCodeExport

Inbound XML:

Result (value is not mapped):

Steps taken to execute the mapping:

Open the AdvancePaymentExportRequest custom mapping
Duplicate the Item node within Extension2
Create/replace node over item #2
Create For-each over Item in source
Drag the CustomString to Valuepart 2
Add source condition over @name with value LineItemTaxAmountExport
Add constant value LineItemTaxAmount over Valuepart1
Add constant value ITEM over Structure

Please let me know what I am doing wrong.

Thank you!

Re: Cannot map custom string field containing value in CIG Mapping tool

bullettt — Wed, 29 Nov 2023 09:56:27 GMT

i think you are doing good

i think you mapped @name instead of the CustomString to the right side

Re: Cannot map custom string field containing value in CIG Mapping tool

rshishmanyan — Wed, 29 Nov 2023 11:35:08 GMT

Louis, thank you for your input. However I am mapping the CustomString, not the @name. Still doesn't work...

Question Re: Cannot map custom string field containing value in CIG Mapping tool in Technology Q&A

Cannot map custom string field containing value in CIG Mapping tool

Re: Cannot map custom string field containing value in CIG Mapping tool

Re: Cannot map custom string field containing value in CIG Mapping tool