Import Scenario - Equipment - FS.20.50.00 - Legacy ERP Equipment to Acumatica

Here’s also the XML file with the mapping corrections.

Hi Rodrigo,

I updated the commits for owner type, customer (ownerid), location type, customer (customerid) as you demonstrated and even though the prepared data shows 12 records processed, I see only one new equipment being created without any errors being thrown.

Thanks,

Patrick

Hello @PatrickBacon ,

Assuming the TRACE captured the issue details on other 11 records not processed, try reviewing the trace details or share it here.

Attached is the trace.

I have a solution. 

I notice that only one record is added no matter how many records are in my import and that I could change the equipment record to be active and only the last record was being added.

For the fun of it (and in spite of my setting that the equipment number should follow a sequence), I created a unique entry for each entry I am loading like this: 

= PadLeft([owner_id] ,6, '0') +'.'+[item_no] +CStr([transmitter_id] )

whereas it was: 

=-1

Once I made this modification, all the records load without errors.

I assumed that the "ForEach" row, a new equipment identifier was being created for each row, but that appears not to be the case when I had "='1" for the equipment identifier.

Thoughts?

Patrick

@riglesias Directed me to review training associated with autonumbering enabled as referenced here,  Webinar: Common examples of import scenarios | Community (acumatica.com).