Default Value in Mapping not working

I am trying to take a CSV file and create a Process.CustomerPartyMaster BOD and I have the majority of it figured out, but I am having trouble getting the AccountingEntityID set to a default value. It is found under the DataArea->Process section of the BOD. Via the Mappings window, I am setting a default "number" as 1 to this field, but when the document flow processes the CSV file, the AccountEntityID is not set to a 1 as I thought it would be.

This wouldn't be a problem, but when I drop the XML into our folder we have set up to process the CustomerPartyMaster files, I get an error BOD stating " Invalid or Missing Required Data - AccountingEntity null is not numeric ProcessCustomerPartyMaster BOD ID". If I manually set the AccountingEntityID field to a 1, then re-process the file, the BOD processes and a customer is created.

I'm just wondering what I'm doing wrong.

Thanks,
Trevor

Find more posts tagged with

ION Mapper & Scripting

Accepted answers

Legacy Contributor

Hey Trevor,

In your case, assigning a constant value would be the most suitable solution unless you have a value or series of values provided in the source document. If so, you could map those to the target AccountingEntityID and use a function to further transform the output, if needed. Otherwise, if it's a fixed and never-changing value, a constant's your best best.

All comments

Legacy Contributor

May be you need to recreate the custom bod in the registry and make the AccountingEntityID as Integer and then save changes. I saw similar issue.

Legacy Contributor

The custom BOD is a CSV and it only has 5 fields that are mapping to other fields. This is not being set via a BOD, but rather I am trying to set this via the Mapping modeler and the "Set Default VAlue" option in the mapping modeler.

Legacy Contributor

Are you writing any XSLT ?

Legacy Contributor

Hey Trevor,

If you feel comfortable, happy to take a look at your mapping and investigate. Just upload your custom BOD and mapping export.

What version of ION/Infor OS are you running?

Does your source document produce an AccountingEntityID field? If no such field exists, you may want to add in a constant to your AccountingEntityID field.

Legacy Contributor

I am not writing any of the XSLT.

Legacy Contributor

The custom BOD is just a CSV file that has the fields: cust_name, state, payment_term, div_no, & sls_rep_out.

I have attached the XSL of the exported BOD mapping. I believe we are using Infor ION 12.0.

[View:/cfs-file/__key/communityserver-discussions-components-files/94/CustomCustomer2ProperXML.zip:150:150]

The source CSV does not have the AccountingEntityID field. I may be able to add that, but I thought I could add it via the "Set default value" option like I did with other values in the mapping.

Thanks

Legacy Contributor

Hey Trevor,

Thanks for the additional information. Are you mapping anything from the source document to the target AccountingEntityID field? If not, then the default value won't help too much here

Ordinarily, you should use the default value when you have a mapping to a target element defined. At runtime, we read the source BOD and if no value was provided, then we fill it in with the default value.

Thanks much

Legacy Contributor

I currently don't have anything being mapped to the AccountingEntityID from my source document. I figured by setting the default value on the destination document, the value you set as the default would be populated in the destination document. After doing some tests, that is what appears to be happening. I'll have to do another test to see if that is correct.

The other problem I have is the source document has a limited range of data to pull from and the AccountingEntityID is not available from the source.

Thanks.

Copyright © 2025 Infor. All rights reserved.