Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Insert Record With Con...

Insert Record With Control File?

(0) Share

Report

Posted on by Community Member

Hi All,

My Company has been working with Dynamics for about 18 months now. I feel like I have a good handle on using Transaction imports, but I have run into a speed bump. We have been using several different versions of a 40100 Control Macro to import orders for different clients we do business with.

For a new client, we would like to import a "MiscCharges" line item that does not appear in the data file. We basically want to fabricate a line from the control file that does not appear in the data file. We have hard coded Values in the control file, but If we don't put a line in the data file at the end with "MiscCharges" in column A, the data we hard code doesn't show up.

Is there a way to create a "MiscCharges" line item on a Sales Order without having a line for it in the data file?

*This post is locked for comments

All responses (2)

Answers (1)

Community Member on at

Like (0)

Report

RE: Insert Record With Control File?

Thanks for getting back to me. I had a feeling this was the case, but I thought I'd ask.
Verified answer

Mark E 6,437 on at

Like (0)

Report

RE: Insert Record With Control File?

Without the MiscCharges row in the data file, the TI process does not know there is data to be imported. The CTL file is the map, and can contain static values, but without the row in the data file, it does not know there is an action to be taken.